Sounds like you've tried a lot. What about the datasource name -- did that get recreated exactly the same? What about the dbtype attribute in CFQUERY -- any conflict there? -----Original Message----- From: Michael Kear [mailto:[EMAIL PROTECTED]] Sent: Friday, December 01, 2000 2:31 AM To: CF-Talk Subject: SQL Setup Problem (I think!) Sometimes I hate PCs!! I had to rebuild my system and now I seem to have broken the connection between my SQL7 desktop version and my development ColdFusion Server 4.5.1. When I run templates that I used many times before I had to rebuild, and I know once worked fine, now I get an error message that I'm calling an invalid object [tablename]. I know the SQLServer7 database has the tables in question, and when I cut and paste the query out of the template and use it the SQL Query analyser, it works fine. The passwords work ok - I've checked them. The OLEBD entry in the ColdFusion Administrator shows verifies ok, and CF happily runs queries on access databases ok. Any ideas where else I should look to fix this? Here's the actual error message I get: [ERROR MESSAGE] ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.songs'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (6:1) to (6:96). Date/Time: 12/01/00 19:13:32 Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 95; DigExt; HD 500) Remote Address: 127.0.0.1 HTTP Referer: http://127.0.0.1/music2/index.cfm [END ERROR MESSAGE] Cheers, Mike Kear Windsor, NSW, Australia AFP Web Development ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
