February 23, 2004 at 12:27 am
Hi ,
I have a scenario where I need to configure a linked server on SQL 2000 Ent. Edition which connects to a Oracle 8.1.7 database. The linked server will be used in distributed transactions as well.
I have done Linked Server Setup, and it is working correctly.
I am worried about few things in this.
1. Will each call to Linked server result in a new connection to oracle ? Or There is some settings which wll make Linked server use connection pooling
2. Has anyone come across any other specific issues in distributed transaction with oracle ?
Any information in this regard will be usefull for me.
February 23, 2004 at 1:21 am
just to Add ,
Does any linked server setup with any other type of data source support connection pooling? (even when using SQL server 2000 server as a linked server data source)
If Yes, How does it control distributed transactions ?
February 24, 2004 at 8:30 am
hi -- not sure if the linked server will support distributed transactions from the SQL side. I recently tried it with SQL7 to oracle and got some message about it not being supported. that probaly didn't help, but I'd like to know your results if you get a solution.
Curtis Smith
SQL Server DBA
Well in worked in Theory ...
February 25, 2004 at 5:22 am
After a lot of Search on Internet & BOL
I found a single line in BOL under topic "External Data and Transact-SQL"
Which says that "Stored procedures are supported only against SQL Server data sources"
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply