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?
LVL 6
anthonycAsked:
Who is Participating?
 
bin_huwairibConnect With a Mentor Commented:
anthonyc,

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

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


Best regards
Bin Huwairib
0
 
clifABBCommented:
If I read your question correctly, are you opening a second workspace (hence a second connection) for the second recordset?
If so, don't.
0
 
clifABBCommented:
The above was posted as a comment.  If it solves your problem, let me know and I'll resubmit it as an answer.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
anthonycAuthor Commented:
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
0
 
bin_huwairibCommented:
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
0
 
anthonycAuthor Commented:
resubmit that as an answer, it seemed to work.

Anthony
0
All Courses

From novice to tech pro — start learning today.