MTS & Oracle function propertly 1

[stufi]

Hi, if some have problem with MTS & Oracle, maybe I can help ...
I am tried solve this and now I have it

My enviroment:
******************************************************
Application 3-tier structure
NT Server (NT SP 6a)
MTS 2.0
Oracle 8.1.6.0 Client for Win
Oracle Server 8.1.5.0 (Sun Solaris 2.6)
(optionally I have under Oracle 8.1.6.0 under Win 2000)
********************************************************

 

[ChrisRockit]

Stuffi,

ChrisRockit again, Don't know how to reply to you directly or if this service email's you but I have the same enviorment as you, and would love to know how you fixed your problem, I am getting the same error, Microsoft is know help.
Thanks,
Chris

 

[Guest_imported]

This is a very confusing area.

If you have a config that works pleas share it.

Thanks

 

[ChrisRockit]

Jack,

There is an article on the oracle web site:

http://www.acs.ilstu.edu/docs/Oracle/nt.816/a73029/toc.htm

There are basically two ways to get transactions going with MTS and oracle. Microsoft's way is with XA transactions, Oracle's way is with Oracle Manager Mts Services. This option can be installed when installing the Oracle Client software (in my case 8.1.6). From all I have read the Oracle way seems to be better (I never could get XA transactions going). Follow the above instructions off the Oracle site, if it still does not work (such as in my case) re-install Nt Option pack, and NT Service Pack 6a. Once I re-installed these two items, the transactions finally worked. Have'nt tried with Win2000.

My Configuration:
Oracle 8.1.6 (Install MTS Services)
Nt Server 4.0
Service Pack 6a

Good Luck! (I know it works with NT 4.0, so keep trying, it's fustrating, took me over a week to get transactions going after reading limited articles on Oracle and MS Sites.)

 

[Guest_imported]

Hi,

We have been facing an intriguing problem with MTS and Oracle8. We have some VB
components hosted on MTS. These components interact with Oracle 8.1. We invoke
these components from asp pages. Now, when we invoke a component from an asp
page, the component gets invoked, it inserts a record in Oracle table, and
returns success status. When we try to check the newly inserted record in Oracle
using SQL Plus, the record is not there. If we wait for 2 to 3 minutes, the
record suddenly appears! This is happening in some programs, not in all. But we
have not been able to figure out why this delay is occuring for the record to get
COMMITTED with Oracle.

We are using Microsoft ODBC for Oracle ver 2.573.6526.00. The Oracle client ver
is 8.1.6.

Can any one suggest as to why this is happening?

Regards,
Rajeev

 

[AkshayB]

This problem can be resolved using the documentation available at microsoft.com(Question no.193893) and in MSDN, we solved the same kind of problem using that document.
its title is "Using Oracle with Microsoft Transaction Server and COM+"

 

[Kanmani]

Hi,
I am also having the problem of oracle & MTS.
can any one help to solve this.
my set up is
MTS 2.0
Oracle 8i ver8.1.5
regards,
Kamani.

 

[Guest_imported]

Hi,
If you want MTS(Windows NT) or COM+(Windows 2000) to work with Oracle 8.1.x . In the MTS/COM+ System you should make the following 3 entries in the registry and RESTART the system.
*********************************************************
Oracle 8.1.x
============
Windows NT or 9x
----------------
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Transaction Server\Local Computer\My Computer]
"OracleXaLib"="oraclient8.dll"
"OracleSqlLib"="orasql8.dll"
"OracleOciLib"="oci.dll"

Windows2000
-----------
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI]
"OracleXaLib"="oraclient8.dll"
"OracleSqlLib"="orasql8.dll"
"OracleOciLib"="oci.dll"
*********************************************************

No need to Install Oracle MTS Services. You could access Oracle from VB/VC++/... code using Microsoft ODBC for Oracle (msorcl32.dll). Preferably Install MDAC 2.6 or 2.7 on MTS/COM+ machine.

Regards,
Jai Ganesh R.

 

[Guest_imported]

Hi,
If you want MTS(Windows NT) or COM+(Windows 2000) to work with Oracle 8.1.x . In the MTS/COM+ System you should make the following 3 entries in the registry and RESTART the system.
*********************************************************
Oracle 8.1.x
============
Windows NT or 9x
----------------
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Transaction Server\Local Computer\My Computer]
"OracleXaLib"="oraclient8.dll"
"OracleSqlLib"="orasql8.dll"
"OracleOciLib"="oci.dll"

Windows2000
-----------
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI]
"OracleXaLib"="oraclient8.dll"
"OracleSqlLib"="orasql8.dll"
"OracleOciLib"="oci.dll"
*********************************************************

No need to Install Oracle MTS Services. You could access Oracle from VB/VC++/... code using Microsoft ODBC for Oracle (msorcl32.dll). Preferably Install MDAC 2.6 or 2.7 on MTS/COM+ machine.

Regards,
Jai Ganesh R.

 

[Prashantk43]

Hi,

I am new to work on mts i have some knowledge to work on nt now i want to know is how to work in win2000 where should i save my mts file/component and also i need to config the mts on 2000 server so pls tell me the steps of config.

thanks
regards
prashant