Qualified? table names

[Cathy and Dave]

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]

---