I have created a linked server to my SS 2000 using the OLEDB provider for
ODBC. I am using a DSN that uses an ODBC driver to access an old DB system.
I can see the tables in the remote system from the EM under the Linked
Server that I am refering to but I don't know How to query that DB.
Note: I have already tryed :
and it does NOT work, there are no such thing as catalogs or owner in that
DB and the answer I get is:
" invalid schema or catalog specified for provider 'MSDASQL' "
by the way in the BOL there are samples on how to deal with the other OLEDB
providers but NOT for the one that uses ODBC