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
