How to test an ADO connection?

Thread View: borland.public.cppbuilder.database.ado

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Mike Wed, 14 Mar 2001 15:57

#5695

Author: Mike
Date: Wed, 14 Mar 2001 15:57

10 lines
1225 bytes

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

RE: How to test an ADO connection?

#5696

Author: Jaime Alvarez
Date: Wed, 14 Mar 2001 21:53

38 lines
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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads