asked on

oraOLEDB.Oracle driver problem

I am not sure if this is the best place to ask this question but i'll try it here first. The following code is ASP/ADO and the backend is Oracle 8i.
I am getting a strange error with the following code.

sSQL = "SELECT * FROM PROJECT_VW WHERE PROJECT_ID='2121'"
set dbcn = Server.CreateObject("adodb.connection")
set rs = server.CreateObject("adodb.recordset")
dbcn.open "Provider=ORAOLEDB.ORACLE; Data Source=xxx; User ID=xxx;Password=xxx; DistribTX=0;"
set rs = dbcn.execute(sSQL)

The error is as follows:
OraOLEDB error '80040e14'
ORA-02041: client database did not begin a transaction

The error occurs on the last line of the code posted. After reading Oracle's explanation of the error i don't think it applies as this is a simple select. I've read something about IIS's database connection pooling being a prob and maybe a iisreset being a solution. I hope someone might offer some insight into this problem.

Thanks
Christian

UsamaMunir

Would u please tell me what the parameter "DistribTX"
for?

ORACLEtune

hi,

Check your environment for the Oracle OLEDB Provider:

------
Windows 95, Windows 98, Windows NT 4.0, Windows 2000
Oracle8i Client version 8.1.6
MDAC 2.1, 2.5
OLE DB SDK 2.1
Oracle OLEDB Provider 8.1.6

If MTS is used:
Oracle Services for Microsoft Transaction Server(8.1.5.0.1 or later)

Eric

Cyclonik

ASKER

ORACLEtune,
the Platform is Win2k, MDAC 2.5
I am waiting on a reply from our systems group on the particulars of the other items you mentioned.

ASKER CERTIFIED SOLUTION

p_yaroslav

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Daniel Stanley

disable MTS support in the odbc driver config.

- daniel

Cyclonik

ASKER

This is using Oracle Provider for oledb not ODBC and a DSN unless one affects the other. I have set DistribTx=0 in the connection string which should turn resolve the problem but isn't.

Christian

ORACLEtune

- reboot a Windows machine, works wonders.

Mindphaser

Please update and finalize this old, open question. Please:

1) Award points ... if you need Moderator assistance to split points, comment here with details please or advise us in Community Support with a zero point question and this question link.
2) Ask us to delete it if it has no value to you or others
3) Ask for a refund so that we can move it to our PAQ at zero points if it did not help you but may help others.

EXPERT INPUT WITH CLOSING RECOMMENDATIONS IS APPRECIATED IF ASKER DOES NOT RESPOND.

Thanks,

** Mindphaser - Community Support Moderator **

tristan256

I had this exact same problem. My vb.net web did not like using a synonym of a table over a public database link. The query would run fine in SQLPlus, but not from my app. Although it didn't help Cyclonik, I added "DistribTx=0" to the connection string, and it worked like magic.

Just my 2c.