by 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
Source=d20;PASSWORD=help123;"
cnSmartTime.Open
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 na-msw1.alcoa.com [192.135.120.50]
via Mailgate.ORG Server - http://www.Mailgate.ORG