Database to: XXXXXXX" is the name of your database, not master
(default). To change it, simply open the ODBC data sources and this
setting is on the 3rd screen of the settings, click the checkbox beside
this line, then use the drop down menu to change the default database.
Christian
-----Original Message-----
From: Cathy and Dave [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 04, 2004 1:11 PM
To: SQL
Subject: Qualified? table names
For some reason, tables in one of my SQL 2k databases require a
qualified name to work, ie.
this works fine (using ColdFusion 5.0):
<cfquery name="q1" dsn="dsnabc">
SELECT * FROM dsnabc.dbo.tblxxx
</cfquery>
this fails:
<cfquery name="q1" dsn="dsnabc">
SELECT * FROM tblxxx
</cfquery>
with:
ODBC Error Code S0002 (Base table not found)
...Invalid object name 'tblxxx'
What's killing me is the table doesn't show up in a:
SELECT table_name FROM information_schema.tables
Is there any way to make this table show up here. And what's
"different" about the way this db/table was created?
TIA
Dave
________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
