We have transactions running with one database on windows 2000 in an ASP page using "@transaction=".

The problem occurs if we attempt to create a transaction with a second database on the same server. We get an error similar to this:

Description : [Oracle][ODBC]MTS support not available, could not load ORAMTS.DLL
Category : Microsoft OLE DB Provider for ODBC Drivers
ASPError : -2147168246
53258 (Error - vbObjectError)
0x8004D00A (Error in Hex)

This is the piece of code executed (starting connection):

set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open somedsn, someuser, somepasword *****<----

Note that the above code seems to work for whichever database gets hit first.

Here's the info I've found related to it:

http://support.microsoft.com/support...sandoracle.asp
http://support.microsoft.com/support.../Q191/1/68.ASP
http://support.microsoft.com/support.../Q259/3/82.asp

To the best of my knowledge the windows 2000 box is setup correctly following the top link above. We're running Oracle8i Enterprise Edition Release 8.1.6.0.0 .

If @transaction isn't used on the ASP page then everything works using COM+ with transaction=required setup for the components. Both DB's seem to use transactions fine.
Also here's one more link with related info after the "Common Questions" (very bottom). It's basically some online doc from oracle (probably at technet also):

http://www-wnt.gsi.de/oragsidoc/doc_...29/trouble.htm

We're looking to call Microsoft on this one, and maybe put a ticket in with Oracle (not sure on our support contract).

thanks for any and all help!

-Jeff