For some reason, tables in one of my databases require a qualified name to work, ie.
this works fine:
<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 was created?
TIA
Dave
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]