Find DSN SQL connection?

[huckfinn19]

Hi, I am writing a small c++ MFC app and I just need a function that could tell me if my SQL DSN connection have been created on this computer... Is there an easy way to do that?

Thanks

Simon

 

[ClaireHCM]

EXEC [master].[dbo].[xp_enumdsn]

 

[JamesLean]

That extended proc returns a list of DSNs set up on the server not the client machine.

I have not come across a SQL function that will do what you want. You may be better looking for a C++ solution.

--James

 

[SonOfEmidec1100]

How about reading the registry

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\DSNname

And/Or

HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\DSNname

 

[huckfinn19]

Thanks, that would have probably worked fine, but I found a sample code at

http://www.codeguru.com/mfc_database/DSNCollection.shtml

that was doing exactly what I needed... There is a class in that sample that uses SQL commands to gather the list of User or System DSN...

Thanks All...

Simon