PostgreSQL

Alexis_Colon_Lugo · February 19, 2014, 3:22am

hi is any way to detect if the connect time out for a remote DataBase.

Tim_Hare · February 19, 2014, 4:12am

Check the Error and ErrorMessage fields.

Alexis_Colon_Lugo · February 19, 2014, 4:24am

ok
thanks
Tim

Alexis_Colon_Lugo · February 19, 2014, 4:59am

hi tim

my problem is i need to cancel the Remoter connection if freeze for about 1 or 2 second is any way to cancel the connection if no response.

Tim_Hare · February 19, 2014, 5:05am

Not that I know of. You could try connecting a regular TCPSocket first to test for network connectivity.

Alexis_Colon_Lugo · February 19, 2014, 5:20am

i am using this If System.Network.LookupIPAddress(sIP) <> “” Then
but some time works and some time no works

thanks

Tim_Hare · February 19, 2014, 5:40am

All that does is query the DNS server. It doesn’t tell you whether the host is available or not.

Alexis_Colon_Lugo · February 19, 2014, 10:44am

ok

thanks