0 Replies Latest reply: Jul 4, 2012 7:44 AM by 947417 RSS

    ms sql server linked server with OraOLEDB.Oracle provider session handling

    947417
      Hi everyone!!

      Here's my situation:
      I have a MS SQL Server 2008 R2 with a linked server to Oracle via OraOLEDB.Oracle provider.

      I use a .net application to open a connection to my sql-server, execute a select that collects data through the linked-server-connection from the oracle database and after that I close to connection to the sql.
      It does work so far,
      but when I start my application, exit it proberly and start it again it seems that i get the same session as before (which is for some reasons very bad).

      Is that the right/normal behavior?
      Is there any way to avoid that?!
      How does the OraOLEDB.Oracle provider handle the sessions if used in/as a linked server?

      thanks and greetings,

      exoc

      Edited by: 944414 on Jul 4, 2012 5:43 AM