0 Replies Latest reply on Oct 17, 2011 10:23 AM by 678796

    OraOLEDB.Oracle provider create connections (sessions).

      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