Re: wierd database error
Thanks, Dave, Mike. I got ahold of CT support - they don't allow you to access databases across domains. Thus, I was getting the error. The solution for me was to create a new database in the test account, then they are going to restore the database at the live server to the test server. Prolly better this way, anyways, since I really should be using a test DB for future changes. Ray Dave Watts wrote: >>I have a site that is running at CrystalTech using SQL Server >>2000, and everything is running fine on the live site: >> >>http://www.nellco.org >> >>I've been making some serious improvements to the site, and have >>uploaded the entire (improved) site to a test server also at >>CrystalTech. I've created the DSN, etc on the test server. >>But I keep getting this weird error: >> >> Error Executing Database Query. >>[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name >>'TD_NEWS_News'. >> >>Like I said, the site is running fine locally here and the site is >>running fine on their live server, but not on my test server. I've >>Googled this error, but I'm not finding what could be causing this >>problem. Has anyone seen it and point me to the reason it might be >>happening? > > > One common cause of this sort of problem is object ownership. When you log > into a database server, and you then create objects within a database, you > will be the owner of those objects. If your user account happens to be dbo > within a specific database, the ownership prefix will be "dbo", but you > won't have to worry about specifying that within your object names when > querying. If your account isn't dbo within that database, the ownership > prefix will be something other than dbo, and you'll have to explicitly > specify that object owner when referencing the object by name. > > There are two ways to solve this. One is to explicitly use the ownership > prefix in your code. The other is to change the owner of your database > objects to dbo. This is a little tedious, but not difficult: > > http://www.sqlteam.com/item.asp?ItemID=1283 > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220224 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: wierd database error
> I have a site that is running at CrystalTech using SQL Server > 2000, and everything is running fine on the live site: > > http://www.nellco.org > > I've been making some serious improvements to the site, and have > uploaded the entire (improved) site to a test server also at > CrystalTech. I've created the DSN, etc on the test server. > But I keep getting this weird error: > > Error Executing Database Query. > [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name > 'TD_NEWS_News'. > > Like I said, the site is running fine locally here and the site is > running fine on their live server, but not on my test server. I've > Googled this error, but I'm not finding what could be causing this > problem. Has anyone seen it and point me to the reason it might be > happening? One common cause of this sort of problem is object ownership. When you log into a database server, and you then create objects within a database, you will be the owner of those objects. If your user account happens to be dbo within a specific database, the ownership prefix will be "dbo", but you won't have to worry about specifying that within your object names when querying. If your account isn't dbo within that database, the ownership prefix will be something other than dbo, and you'll have to explicitly specify that object owner when referencing the object by name. There are two ways to solve this. One is to explicitly use the ownership prefix in your code. The other is to change the owner of your database objects to dbo. This is a little tedious, but not difficult: http://www.sqlteam.com/item.asp?ItemID=1283 Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220221 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: wierd database error
Well, not sure about that. Not even sure how to check this on a shared server. We don't usually use CT, so I'm not familiar at all with their servers and such. I'm going to do some investigating and see where that takes me. Thanks Michael T. Tangorre wrote: >>From: Ray Champagne [mailto:[EMAIL PROTECTED] >>Running it against the live DB - there are no changes to the >>DB code in my "new" version, so there is not really any >>worries of altering the DB. >> That's why I'm confused. There have been no changes to the >>DB, and that table *does* exist. The only thing I can think >>of is that the DB is getting accessed from a different >>account than the live site, but I've set the DSN just fine >>using the control panel at CT, so in my mind it shouldn't >>matter, right? > > > Are both the CF Servers you are running your test and production code on the > same? Same CF Version? Same DB drivers? JDBC drivers? > > Mike > > > > > ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220216 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: wierd database error
> From: Ray Champagne [mailto:[EMAIL PROTECTED] > Running it against the live DB - there are no changes to the > DB code in my "new" version, so there is not really any > worries of altering the DB. > That's why I'm confused. There have been no changes to the > DB, and that table *does* exist. The only thing I can think > of is that the DB is getting accessed from a different > account than the live site, but I've set the DSN just fine > using the control panel at CT, so in my mind it shouldn't > matter, right? Are both the CF Servers you are running your test and production code on the same? Same CF Version? Same DB drivers? JDBC drivers? Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220215 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: wierd database error
Running it against the live DB - there are no changes to the DB code in my "new" version, so there is not really any worries of altering the DB. That's why I'm confused. There have been no changes to the DB, and that table *does* exist. The only thing I can think of is that the DB is getting accessed from a different account than the live site, but I've set the DSN just fine using the control panel at CT, so in my mind it shouldn't matter, right? Michael T. Tangorre wrote: >>From: Ray Champagne [mailto:[EMAIL PROTECTED] >>I have a site that is running at CrystalTech using SQL Server >>2000, and everything is running fine on the live site: >>http://www.nellco.org >>I've been making some serious improvements to the site, and >>have uploaded the entire (improved) site to a test server >>also at CrystalTech. I've created the DSN, etc on the test >>server. But I keep getting this weird error: >> >> Error Executing Database Query. >>[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object >>name 'TD_NEWS_News'. > > > Sounds like you are referring to an invalid object (table perhaps)? Do you > have a test DB too or are you running test code against a production DB? > > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220213 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: wierd database error
> From: Ray Champagne [mailto:[EMAIL PROTECTED] > I have a site that is running at CrystalTech using SQL Server > 2000, and everything is running fine on the live site: > http://www.nellco.org > I've been making some serious improvements to the site, and > have uploaded the entire (improved) site to a test server > also at CrystalTech. I've created the DSN, etc on the test > server. But I keep getting this weird error: > > Error Executing Database Query. > [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object > name 'TD_NEWS_News'. Sounds like you are referring to an invalid object (table perhaps)? Do you have a test DB too or are you running test code against a production DB? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220212 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
wierd database error
I have a site that is running at CrystalTech using SQL Server 2000, and everything is running fine on the live site: http://www.nellco.org I've been making some serious improvements to the site, and have uploaded the entire (improved) site to a test server also at CrystalTech. I've created the DSN, etc on the test server. But I keep getting this weird error: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'TD_NEWS_News'. Like I said, the site is running fine locally here and the site is running fine on their live server, but not on my test server. I've Googled this error, but I'm not finding what could be causing this problem. Has anyone seen it and point me to the reason it might be happening? The address where this can be seen: http://216.197.108.108/NELLCO/index.cfm -- = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220211 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
