Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 842
  • Last Modified:

Oracle, MTS and COM using VB 6.0

We are trying to talk with oracle 8i database through an MTS component that we have built using VB6.  We are using the Oracle ODBC driver for oracle (ver 8.1.5) provided with oracle 8.1.5.

we are getting the error message:

Microsoft OLE DB Provider for ODBC Drivers error '8004d00a'

[Oracle][ODBC]Failed to enlist global transaction with DTC


We have followed the instructions provided by oracle 8i manuals which gives a detail of talking to MTS.
Still we are getting the above error.

Any ideas?

What do I need to do to get transactions to work?  It works fine if I set the COM component as non-transactional, but that doesn't help since we need it to be transactional.  I've heard that a few patches exist for Oracle but I have not found any on their website.
0
soj_1
Asked:
soj_1
1 Solution
 
cjwikCommented:
look in the booksonline for sql server, it has some hints about how to use ms dtc with oracle, it is ms dtc and not mts that is your problem, mts is using ms dtc.

cj
0
 
rogerkjCommented:
I am currently working on a project where we had the same problem. We contacted Oracle and Microsoft and found out that MTS and Oracle 8i does not work well togheter. The result were that we had to downgrade our database to Oracle 8.0.5 which solved all our problems.
0
 
soj_1Author Commented:
Another workaround that I have figured out was that if you upgrade your Oracle 8i client to version 8.1.6, it will support MTS as well.  The database we are using is still 8.1.5 and we have no issues now.

Thanks for your input.
-Alex
0
 
RayLeongCommented:
Hi,

I had some problem with oracle client8i and mts. I had upgraded the orcale object for ole to 8.1.6 and the manager for MTS has started successfully. However i still couldn't rollback a transaction successfully. Might be a problem with MS DTC. Any suggestions? I had placed my question on experts-exchange on 26 May, titled "Oracle and MTS". I really appreciate if anyone could point out my mistake. Thank You.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now