> 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'.
The most common cause for this problem, in my experience, is the failure to
enter the database name (not the database server name) into the appropriate
field when configuring the datasource. By default, with SQL Server, if you
do that, you'll usually get the master database.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
