Find out if DSN connection exists before running a report?

[huckfinn19]

Hi, I'm writing a small C++ MFC app that is gonna be used to generate reports. I'd like to be able to find out if my MySQL DSN connection is already set up on the computer running my app...

Is there a way to do this programmatically ?

Thanks

Simon

 

[chelseatech]

Yes - I've got the VB code to do this. I found it on Tek-Tips in the Visual Basic Forum.

It is a programming question rather than a Cr question, so ask it in one of the other forums.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[craigber]

If you are using the RDC (which you should be..if not, you should seriously look into it), you can use the TestConnectivity method of the DatabaseTable object.

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

Author, CrysDev: A Developer's Guide to Integrating Crystal Reports"