I have converted a access database to sql server 7.0 my tables have not
changed but everytime i try and access any page that has a database call i
recieve the following error
ODBC Error Code = S0002 (Base table not found)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'report2s'.
SQL = "SELECT picture, lastupdated, id FROM report2s WHERE ((id)=4 Or (id)=5
Or (id)=6)"
Data Source = "xxxxxx"
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (3:1) to (3:55) in the template file
e:\inetpub\wwwroot\evisions\index.cfm.
Date/Time: 08/06/01 00:04:38
Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
Remote Address: 127.0.0.1
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
