> 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
