Groups | Blog | Home
all groups > sql server odbc > june 2007 >

sql server odbc : Suppressing ODBC pop up error



6/16/2007 4:05:21 AM
Hi there,

I have a client-server application that periodically connects to an
Access database on a network. My netowrk sometimes goes down and there
is an ODBC failure to connect. This results in an ODBC error pop up
window. I am interested in suppressing this pop up, catching the
exception and simply saying "network is down" or something like that.

Is this possible? How is this done? My application is VB 6.

Thanks!
Andrew Rossmann
6/16/2007 10:10:15 AM
[This followup was posted to microsoft.public.win2000.general and a copy
was sent to the cited author.]

In article <1181966721.555233.133070@j4g2000prf.googlegroups.com>,
janefield2002@yahoo.com says...
[quoted text, click to view]

In the areas where you connect, use ON ERROR GOTO xxxx, or put the
connection routines inside a Try...Except section.

--
If there is a no_junk in my address, please REMOVE it before replying!
All junk mail senders will be prosecuted to the fullest extent of the
law!!
Dave Patrick
6/16/2007 7:39:21 PM
Yes, test for connection and act accordingly inside your vb6 app.

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

[quoted text, click to view]
AddThis Social Bookmark Button