MTS, ADO, and Oracle

Results 1 to 2 of 2

Thread: MTS, ADO, and Oracle

  1. #1
    Join Date
    Dec 1969

    Default MTS, ADO, and Oracle

    We have run into some problems in trying to use MTS to manage our DB connections on our ASP pages. We use the following VBScript code to establish our DB connection: <BR><BR>Set objConn = Server.CreateObject("ADODB.Connection") <BR>objconn.Mode = adModeRead <BR>objConn.Open "Provider=MSDAORA.1;" &_ <BR>"Data Source=(databasename);" &_ <BR>"User ID=(userid);" &_ <BR>"Password=(password);" <BR><BR>The code executes fine until we add the following line to the page which causes MTS to handle resource management: <BR><BR>&#060;%@ Transaction = "Required" %&#062; <BR><BR>When that line of code is added, the page returns an error code of 8000ffff with the full text description being "Catastrohic Error". <BR><BR>We are running IIS 4.0 with SP5 installed and have upgraded to MDAC 2.1 SP2. Anyone have any clues? <BR><BR>Thanks in advance!

  2. #2
    Shailaza Guest

    Default Same problem..what is the solution

    i am also facing the same problem..could you please let me know how you solved that problem?<BR><BR>thanks<BR>shailaza

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts