Problems with SQL via Interdev on Remote Servers

Problems with SQL via Interdev on Remote Servers

Post by Gil_Fryer/Intalco/Prim.. » Sat, 03 Feb 2001 00:58:26

I have a situation with an Interdev application where I'm using the execute
method of the connection object and assigning the results to a recordset.
The SQL Statement is taking place on one Oracle Server (server1) and the
Tables reside on another Oracle server (Server2).  The Server2 DataBase
Link  on Server1 is valid and I can execute the SQL statement via SQl*Plus
on Server1, but through the interdev application I get the following errror
message.  Also, I can execute the SQL Statement via the Interdev
application if I go directly to Server2 but for many reasons, I want/need
to process the SQL Statement via Server1.  If anyone can help out I'd love
to hear your thoughts, as I'm  new to the Oracle Scene.

     set cnSmartTime = Server.CreateObject("ADODB.Connection")
     set rsHrlyVacation = server.CreateObject("ADODB.Recordset")

     Response.Write strSQLCommand
     cnSmartTime.Provider = "OraOLEDB.Oracle"
     cnSmartTime.ConnectionString = "PLSQLRSet=1;User ID=help;Data

     set rsHrlyVacation = cnSmartTime.Execute(strSQLCommand)

Here is the error being report back from my ASP Page:

Error Type:
OraOLEDB (0x80040E14)
ORA-02041: client database did not begin a transaction
/HrlyVacBonus/Hrly_Vac_Bonus.asp, line 48

Posted from []
via Mailgate.ORG Server - http://www.Mailgate.ORG