sql server odbc: accessing to an oracle 10 linked server -- sql server odbc

accessing to an oracle 10 linked server

CÃ©dric Prin-Derre
3/15/2005 7:23:03 AM

sql server odbc:

Hello,

i try to make some select queries using a linked oracle 10 server but for a
few tables, only the first row is returned...

i haved used "Microsoft OLE provider for OCBC driver" when declaring my
linked server and my odbc link is using the lastest Oracle odbc driver
(10.1.3.1).

Using another odbc driver (microsoft odbc for oracle) instead of oracle one
make it works great on query analyser but when using it on my programs (who
are connecting to SQLSERVER 2000 using odbc SQLSERVER), linked request fail
returning me "Impossible to start other transactions for this session".

Any clue?

Re: accessing to an oracle 10 linked server

Sue Hoegemeier
3/15/2005 9:32:42 PM

Not sure but you'd definitely want to try using the OLE DB
provider instead. You add extra overhead when using the OLE
DB provider for ODBC. The OLE DB providers generally provide
more functionality as well.

-Sue

On Tue, 15 Mar 2005 07:23:03 -0800, Cédric Prin-Derre
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server odbc group.