Prev: rounded borders
Next: DBServer error
From: Mirco Kaminski on 16 Sep 2009 02:39
Hello NG,

How can I check if a SQL Server exists and have access?
(VPN tunnel)
The method oAdoConn:ConnectionTimeout does not produce satisfy results.
If the connection is not open, the program hangs at oAdoConn: Open ().
---------
oAdoConn:ConnectionTimeout := 5
oAdoConn:Open("Provider=SQLOLEDB;Data Source="+cServer+";",cUser,cPW,-1)
IF oAdoConn:State > 0
---------

Thanks for any advice
Mirco
VO 2.7b


From: Willie Moore on 16 Sep 2009 09:42
Micro,

Do you have a begin sequence set up around your opening statements. VO2ADO
uses the regular VO Error system to report back issues. Also, You can check
if oConn != null after you open it up to make sure that the connection is
good.

Regards,
Willie

"Mirco Kaminski" <kami-mail(a)gmx.net> wrote in message
news:h8q16d$mm0$00$1(a)news.t-online.com...
> Hello NG,
>
> How can I check if a SQL Server exists and have access?
> (VPN tunnel)
> The method oAdoConn:ConnectionTimeout does not produce satisfy results.
> If the connection is not open, the program hangs at oAdoConn: Open ().
> ---------
> oAdoConn:ConnectionTimeout := 5
> oAdoConn:Open("Provider=SQLOLEDB;Data Source="+cServer+";",cUser,cPW,-1)
> IF oAdoConn:State > 0
> ---------
>
> Thanks for any advice
> Mirco
> VO 2.7b
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus
> signature database 4429 (20090916) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
>
>
>

__________ Information from ESET NOD32 Antivirus, version of virus signature database 4429 (20090916) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com



From: Mirco Kaminski on 17 Sep 2009 01:17
Hi Willy,

thats correct.
But, I get no error and the open()-Method don't use the
oAdoConn:ConnectionTimeout?
The time when open() comes back is more as 2 Minutes.

Mirco


"Willie Moore" <williem(a)wmconsulting.com> schrieb im Newsbeitrag
news:h8qpvn$rec$1(a)aioe.org...
Micro,

Do you have a begin sequence set up around your opening statements. VO2ADO
uses the regular VO Error system to report back issues. Also, You can check
if oConn != null after you open it up to make sure that the connection is
good.

Regards,
Willie

"Mirco Kaminski" <kami-mail(a)gmx.net> wrote in message
news:h8q16d$mm0$00$1(a)news.t-online.com...
> Hello NG,
>
> How can I check if a SQL Server exists and have access?
> (VPN tunnel)
> The method oAdoConn:ConnectionTimeout does not produce satisfy results.
> If the connection is not open, the program hangs at oAdoConn: Open ().
> ---------
> oAdoConn:ConnectionTimeout := 5
> oAdoConn:Open("Provider=SQLOLEDB;Data Source="+cServer+";",cUser,cPW,-1)
> IF oAdoConn:State > 0
> ---------
>
> Thanks for any advice
> Mirco
> VO 2.7b
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus
> signature database 4429 (20090916) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
>
>
>

__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4429 (20090916) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com




From: Geoff Schaller on 5 Oct 2009 03:15
Mirco.

It is notoriously difficult to set a connection time-out such that most
applications just suffer the problem quietly. In fact it is quite
dangerous to even attempt to reduce it to something like 5 seconds
because double this is normal and routine.

But equally, we rarely see anything longer than 30 seconds in the
average network (which is reasonable) except for the fact you are using
VPN and this could make the whole thing very slow at best.

But one way out is to open the connection asynchronously or open it in a
separate thread. I'd go for asynch connections because at least your app
will not hang... but you will still need some loop or timer to check for
the eventual status before the user tries to use it.

Geoff



"Mirco Kaminski" <kami-mail(a)gmx.net> wrote in message
news:h8q16d$mm0$00$1(a)news.t-online.com:

> Hello NG,
>
> How can I check if a SQL Server exists and have access?
> (VPN tunnel)
> The method oAdoConn:ConnectionTimeout does not produce satisfy results.
> If the connection is not open, the program hangs at oAdoConn: Open ().
> ---------
> oAdoConn:ConnectionTimeout := 5
> oAdoConn:Open("Provider=SQLOLEDB;Data Source="+cServer+";",cUser,cPW,-1)
> IF oAdoConn:State > 0
> ---------
>
> Thanks for any advice
> Mirco
> VO 2.7b

 | 
Pages: 1
Prev: rounded borders
Next: DBServer error