SQL/Cold Fusion Error 1

[tsp1lrk]

Hi,

I'm receiving this error and am not sure what to do; the table DOES exist... Here is my error:

Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = S0002 (Base table not found)


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



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


Any ideas???
This is driving me crazy!!

Lisa

 

[CFDude]

Can you pull up information from other tables using the same connection? I've run into this when I inadvertantly set the default database to something else, like the Master table in the ODBC connection.

 

[tsp1lrk]

I haven't tried another table yet, but what would cause this type of error? Something in the Cold Fusion administrator? What kind of setting should I look for to see if I'm set up correctly?

Thanks so much!
Lisa

 

[CFDude]

When you setup an ODBC connection to a SQL server, you have a default Database to point it to. By default, it points to the "master" table. In CFAdmin, the table is in the LoginInfo section of the ODBC information. (I'm guessin you are running CF 5)

I prefer to use the ODBC manager in administrative tools if you have access to it to change the table.

Tim P.

 

[tsp1lrk]

You are AWESOME! That was it! We're not allowed to go in and change stuff but I have rights to the server, and I looked and sure enough, it was BLANK!! They never set me up right; I put in my database name and BAM, it worked! Thank you so much... it's sad that we can't depend on our own departments to fix problems, that would have taken DAYS for someone to fix... Thanks SO MUCH...

Lisa