Strange ODBC problem (link server) 
Author Message
 Strange ODBC problem (link server)


I made a Linked Server to an ODBC data source.  When I query against it, I
got errors related to Deleted rows...

When I use OpenRowSet to query against it, I got records back, but most of
the rows are blanks...

When I use DTS to copy the table over, it copies fine.

When I use Access 97/2000 to link to them via ODBC, I can see the record

I can see the potential problem to the the OLE DB Provider for ODBC.  Both
Linked server and OpenRowset method access tables via this provider, but the
others DTS and Access use straight ODBC...

My question, can I use straight ODBC with Linked Server or OpenRowset...



Fri, 04 Apr 2003 03:00:00 GMT
 [ 1 post ] 

 Relevant Pages 

1. A strange linked server security problem

2. Strange problems accessing SQL Server using @DbCommand([ODBC]) from Lotus Notes

3. Strange ODBC errors using DAO to access linked tables in Access .MDB

4. strange row locks on Access2000 table linked via ODBC

5. linked server problem using ODBC

6. Problem linking a ODBC server

7. Problem with SQL 2000 linked server - ODBC StarSQL 4

8. ODBC for Informix Linked Server problem

9. Problem creating a Linked Server to Oracle using ODBC

10. Linked Server using ODBC problem

11. ODBC for Informix Linked Server problem

12. Problems with Linked Server and ODBC

Powered by phpBB® Forum Software