• Welcome to SQLitening Support Forum.
 

Client waits 60 seconds if server is invalid and returns success code

Started by mikedoty, September 18, 2007, 02:49:56 AM

Previous topic - Next topic

mikedoty

If the client connects to an invalid server it will wait 60 seconds and return errCode=0.
EndSession will also do the same thing.  Be sure to wait for EndSession before terminating.
Ran across a similar thing when testing Tsunami with TTDS and they allowed changing the
TIMEOUT so the client can put access code in a loop. 
Of course we need to know that it connected to a valid database.


'Pseudo code
FOR Attempts = 1 to 10
     errCode = sql3_connect(hSession, sSQL )     
     IF errCode = 0  THEN EXIT FOR
     SLEEP 250
NEXT

I have  DDT client test code if anyone is interested.



Fredrick Ughimi

Hello Mike,

>> I have  DDT client test code if anyone is interested.

I would be glad to have them. Thanks in advance.

Best regards,
Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet

mikedoty

Sent sqlddt.bas to your support email address.
It makes the connection string for you by filling in the fields and auto-saves on exit.

Fredrick Ughimi

Hello Mike,

Thank you.

I just check. Hmm... there was nothing like that.

Please, kindly resend it. I don't know what happened.

Best regards,
Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet

mikedoty

Resent.  Did you get it?
In the upper corner of each forum did you click on notify so you know when people respond?
Also notified you on your yahoo account.  Note, clicking on your url link (on this site) doesn't work because
planetsquires/support prefixes it for some reason.
Also noticed you have a third email address at contact at meganetcomputers.net (sent a message there, too)
It came back undeliverable.
Just found another email for you at hotmail.   What is your email address?

Fredrick Ughimi

Hello Mike,

>>Resent.  Did you get it?

Thank you. Got it at last when you used fughimi@yahoo.com. Thank you.

>>In the upper corner of each forum did you click on notify so you know when people respond?

Some times I do that. Not in this case.

>>Note, clicking on your url link (on this site) doesn't work because
planetsquires/support prefixes it for some reason.

Just fixed it. Thank you for bringing it to my notice.

>>Also noticed you have a third email address at contact at meganetcomputers.net (sent a message there, too)
It came back undeliverable.

Its now deprecated. I have removed it. I thought I did that sometime ago.

>>Just found another email for you at hotmail.

Openned that to be able to chat with my cousins using hotmail in the US before the collaboration b/w Yahoo and Microsoft.

>>What is your email address?

I prefer you use support@ughimisoft.com or fughimi@yahoo.com.

Thank you for the file and your observations.

Best regards,













Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet