3 Replies Latest reply: Jul 15, 2010 1:02 AM by 785203 RSS

    OraMTS Error 1002 - obtaining/releasing connection

    462413
      Hi All,

      we have a problem with our COM object that connects to
      Oracle via ORAMTS.dll.
      It is a COM object created from PowerBuilder 10. It gives following error when it tries to connect:
      OraMTS Error 1002 - obtaining/releasing connection.

      We use Oracle 9.2.0.4.0 Oracle Services for Microsoft
      Transaction Server running on Windows 2000, SP 4.
      Can anybody help?
      Thank you in advance.
      Slavo
        • 1. Ora MTS
          463918
          Well We have the same Error But only in Oracle 9i ( i have the solution for 8i )

          And i like that u try this solution :

          1- When u intall Oracle u should Select "Oracle Windows interface 9.2.0.1"

          2 - U should add this value in windows register

          [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI]
          "OracleXaLib"="oraclient9.dll"
          "OracleSqlLib"="ORASQL9.DLL"
          "OracleOciLib"="oci.dll"

          this solution works perfectely when i excute the application in the server of database
          • 2. Re: Ora MTS
            529288
            Hi user460915 ,
            Could you give me your Oracle 8i solution to me, I have encountered the same problem.
            Thanks a lot...
            • 3. Re: Ora MTS
              785203
              Hi All,

              we have a problem with our COM object that connects to
              Oracle via ORAMTS.dll too.
              It is a COM object created from PowerBuilder 8. It gives following error when it tries to connect:
              OraMTS Error 1002 - obtaining/releasing connection.

              We use Oracle 11.2 Oracle Services for Microsoft
              Transaction Server running on Windows 2003, SP 4.

              i add this value in windows register
              [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI]
              "OracleXaLib"="oraclient11.dll"
              "OracleSqlLib"="ORASQL11.DLL"
              "OracleOciLib"="oci.dll"

              but It still gives following error when it tries to connect:
              OraMTS Error 1002 - obtaining/releasing connection

              who can help me?tell me why