×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

MTS & Oracle function propertly

MTS & Oracle function propertly

MTS & Oracle function propertly

(OP)
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)
********************************************************

RE: MTS & Oracle function propertly

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

RE: MTS & Oracle function propertly

This is a very confusing area.

If you have a config that works pleas share it.

Thanks

RE: MTS & Oracle function propertly

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.)

RE: MTS & Oracle function propertly

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

RE: MTS & Oracle function propertly

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+"

RE: MTS & Oracle function propertly

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.

RE: MTS & Oracle function propertly

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.

RE: MTS & Oracle function propertly

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.

RE: MTS & Oracle function propertly

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close