Check for Existing ODBC Connection

[hjohnson]

Is there a way that I can programatically check for the Existence of an ODBC Connection and whether or not that connection exsist in a DBC.

Thanks in advance.

HJ

 

[rgbean]

HJ,
You can use DBGETPROP() to check for the "connection" in a DBC, but I'm not quite sure what you mean by the first part of the question.

Rick

 

[hjohnson]

Rick,

What I was refering to was if the ODBC Datasource has been setup in Windows.

Thanks for your help

HJ

 

[rgbean]

HJ,
Ah! The Solution Samples code has something you may want to check out.

DO ( _samples+"\solution\solution.app")

Should work in VFP 6.0 -> 8.0, assuming you installed the sample code.
Go to the Windows API section, and try the
"Read ODBC Registry values" code.

Rick

 

[hjohnson]

Awesome- Thanks

HJ