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
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum for Programming
 Forum for Origin C
 Flaky database connection		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

peter.cook

UK
356 Posts
Posted - 10/18/2005 :  10:31:44 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
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
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000