Sql server error

[Guest_imported]

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\

http://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

 

[Cagliostro]

put use nameOfYourDatabase in the first line John Fill

ivfmd@mail.md