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
