asked on

ODBC Direct, Oracle, with Oracle's ODBC Driver

All,

I am attempting to use ODBC Direct to hit the oracle database. Everything works correctly for the first recordset opened, and then when I attempt to open another recordset (whether or not the first one is closed), the program hangs. The ODBC Direct calls are correct (I open a workspace and then a connection). It doesn't matter if I call the queries ASYCH or not, it still hangs..

Any suggestions?

clifABB

If I read your question correctly, are you opening a second workspace (hence a second connection) for the second recordset?
If so, don't.

clifABB

The above was posted as a comment. If it solves your problem, let me know and I'll resubmit it as an answer.

anthonyc

ASKER

No...... That's not what I am doing. I am opening 1 workspace, 1 Connection, many recordsets.

I tried substituting Intersolv's driver, no luck. I wrote a little test program using ODBC Direct on 1 form, RDO ont he other. RDO works perfectly, ODBC direct hangs

bin_huwairib

anthonyc,

Try to set QueryTimeout property to zero after you open the conneciton.

Example
=======
Set Cn = Ws.OpenConnection("", dbDriverNoPrompt, False, strConn)
Cn.QueryTimeout = 0

Bin Huwairib

anthonyc

ASKER

resubmit that as an answer, it seemed to work.

Anthony

ASKER CERTIFIED SOLUTION

bin_huwairib

membership

This solution is only available to members.

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

Start Free Trial