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
