ODBC Error Code = S0002 (Base table not found)

[Glen T]

I just deployed my first CF application. The ISP has set up the DSN. But now,
when I run the application, I get the following error:

ODBC Error Code = S0002 (Base table not found)

This error occurs when I try to access either of the two tables in the DB. It
looks like the datasource is pointing to the wrong DB (not mine). Or maybe the
DB file is corrupted? What else could this be?

[NicTunney]

What are they pointing the DSN to? Did you create the tables inside the db?

[zoeski80]

Try doing a query to get all the objects in the database to check what tables
are in the database that the datasource is pointing to. The attached query
should work for an MS SQL Server database

Could also be that your user account for the database hasn't got permission
for those tables.

HTH

<CFQUERY NAME="getAllTables" DATASOURCE="??">
SELECT *
FROM SysObjects
WHERE Type = 'u'
ORDER BY Name
</CFQUERY>

<CFDUMP VAR="#getAllTables#">

[Glen T]

At this moment, the ISP is claiming that the DB that I uploaded to the server
has a table named "users" in it. However, the table is named "tbl_users" on my
machine.

I'll try the listing code and see what I get.

[Glen T]

Thanks, zoeski80, that did the trick. Using your dump, we are able to figure
out that the dsn was actually pointing to another database of the same name in
a folder of the same located above web root - left over from the pevious admin.
So it was pointing to the wrong DB. Thanks a bunch!