This discussion is archived
0 Replies Latest reply: Oct 17, 2011 3:23 AM by 678796 RSS

OraOLEDB.Oracle provider create connections (sessions).

678796 Newbie
Currently Being Moderated
Hi all,
     I have Link server between oracle and MSSQL with following versions,
Oracle – 10G
MSSQL – SQL Server 2008 R2
Link server provider=N'OraOLEDB.Oracle'
After created link server then without actually doing any queries or anything oracle side create 100 or 120 connections (sessions) from this SQL server to oracle server. Any idea on this?

Tharindu Dhaneenja


  • Correct Answers - 10 points
  • Helpful Answers - 5 points