its default.
Just an idea.
--Ben
Dave Francis wrote:
> In CF5.0, SQL 2k
>
> 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]
