It sounds like the user for that DSN doesn't have that DB assigned as
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:
>
> SELECT * FROM ds
In CF5.0, SQL 2k
For some reason, tables in one of my databases require a qualified name to work, ie.
this works fine:
SELECT * FROM dsnabc.dbo.tblxxx
this fails:
SELECT * FROM tblxxx
with:
ODBC Error Code S0002 (Base table not found)
2 matches
Mail list logo
