Article View: borland.public.cppbuilder.database.ado
Article #5696RE: How to test an ADO connection?
From: Jaime Alvarez
Date: Wed, 14 Mar 2001 21:53
Date: Wed, 14 Mar 2001 21:53
38 lines
2083 bytes
2083 bytes
Hi Mike, Replace the connection string by file connection, create into project directory one file of type Microsoft Data Link (UDL) and configure your access in this file. This file contain one button of Test Connection ... You can use the file attach and configure your connection (rename if is necesary) Regards Jaime Alvarez Mike <mjk111@ameritech.net> escribi๏ฟฝ en el mensaje de noticias 3aaf95ab$1_2@dnews... > How can I programmatically test a TADOQuery connection in a way that will > not cause my app to hang while testing? > > If I use TADOQuery->Open(), I have to wait for the server to time out. What > I'm looking for is a quick check of the connection, the same as the 'Test > Connection' button the the Connection String setup dialog. > > TIA, > > Mike > > begin 666 NuevoMicrosoft Data Link.UDL M__Y;`&\`; !E`&0`8@!=``T`"@`[`" `10!V`&4`<@!Y`'0`: !I`&X`9P`@ M`&$`9@!T`&4`<@`@`'0`: !I`',`( !L`&D`;@!E`" `:0!S`" `80!N`" ` M3P!,`$4`( !$`$(`( !I`&X`:0!T`',`= !R`&D`;@!G``T`"@!0`%(`3P!6 ?`$D`1 !%`%(`/0!M`',`9 !A`',`<0!L`#L`#0`*```` ` end
Technical Details
Message-ID:
<3aafe79c$1_2@dnews>Path:
arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!sn-xit-01!supernews.com!newshub2.rdc1.sfba.home.com!news.home.com!newsfeed.direct.ca!look.ca!hub.org!hub.org!PeerFeed.KWeb.on.ca!bornews.borland.com!dnews!200.39.36.169References:
<3aaf95ab$1_2@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 10698b,2adbbb2efcc2c953 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2001-03-14 13:54:08 PST Reply-To: "Jaime Alvarez" <jalvarez@wjreddin.com> From: "Jaime Alvarez" <jalvarez@wjreddin.com> Newsgroups: borland.public.cppbuilder.database.ado References: <3aaf95ab$1_2@dnews> Subject: RE: How to test an ADO connection? Date: Wed, 14 Mar 2001 15:53:04 -0600 Lines: 39 Organization: Consultores en Efectividad Gerencial S.A. de C.V. X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 NNTP-Posting-Host: 200.39.36.169 Message-ID: <3aafe79c$1_2@dnews> X-Trace: 14 Mar 2001 13:50:20 -0800, 200.39.36.169 Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!sn-xit-01!supernews.com!newshub2.rdc1.sfba.home.com!news.home.com!newsfeed.direct.ca!look.ca!hub.org!hub.org!PeerFeed.KWeb.on.ca!bornews.borland.com!dnews!200.39.36.169