>
> 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'
My guess is that either the database name isn't specified in the datasource,
or that the login specified in the datasource isn't the table owner or isn't
acting within the dbo role for that database.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
