The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum for Programming
 Forum for Origin C
 Flaky database connection

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
peter.cook Posted - 10/18/2005 : 10:31:44 AM
Origin Version (Select Help-->About Origin): 7.5 SR5
Operating System: Win2000

Hi all,

Any advice would be helpful...appreciating it may not not be an Origin specific issue (I think I have seen this with Excel too).

Connecting to a database via 
 ocrs = CreateObject("ADODB.Recordset")


can be a bit tempermental partcularly, I think, when working over a slower connection.

The code is correct but sometimes it connects and sometimes it doesn't. Using the same SQL statement with another software eg TOAD always works ie the connection is more reliable here.

Any ideas / suggestions?

Thanks,

Cheers,

pete

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000