Help! - Base table not found (SQL server) 1

[scootaboy]

Hi all, can anyone help me?

When trying to reference the tables in a SQL db I get the following error:

ODBC Error Code = S0002 (Base table not found)

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'adminuser'.

The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:54).

The table is definately there, the names in my code and the db match up and in Coldfusion administrator the datasource is verified (meaning it can see the db).

So why this error? I don't get it with any other db's on the same server and the SQL queries I have used to test it are the most simple you can use.

Any help/advice/pointers would be much appreciated.

Cheers

 

[scootaboy]

Found the problem......didn't set up right in cf administrator.....yes I am feeling stupid.......

 

[bocman]

Please contact me, I'm having the same problem and don't know what is wrong with the setup in cf admin

 

[tsp1lrk]

Me too! What was the problem in CF administrator??? Thanks...
Lisa