Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 622
  • Last Modified:

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?
0
anthonyc
Asked:
anthonyc
  • 2
  • 2
  • 2
1 Solution
 
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
 
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
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


Best regards
Bin Huwairib
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now