PDA

View Full Version : Getting details of an ODBC connection...



NewsArchive
09-06-2005, 10:40 AM
I have a situation where during install I need to get the details
(server,login, etc.) of an EXISTING ODBC connection.

Suggestions? I'm only seeing things related to creating / deleting....

--
Paul MacFarlane
American Riviera Software Corp

NewsArchive
09-06-2005, 10:40 AM
Paul,

Perhaps you can write a DLL and use the SQLGetConnectAttr Windows API
(please note that only some attributes are available to this function) or
SQLInfo (results may vary based on the version number of the connected
server).

For example, using SQL_SERVER_NAME in SQLInfo would return the connection's
server name.

HTH,
Friedrich

--
Friedrich Linder
CEO, Lindersoft
www.lindersoft.com
1.954.252.3910

"point. click. ship" - that's SetupBuilder 5

NewsArchive
09-06-2005, 10:41 AM
Thanks Friedrich....

I was figuring that might be the way - but I wanted to make sure I wasn't
missing anything.....

NewsArchive
09-06-2005, 10:41 AM
BTW, if you have any suggestions or features you would like to see in future
SB5 versions, just send an email to support (at) lindersoft (dot) com.

--
Friedrich Linder
CEO, Lindersoft
www.lindersoft.com
1.954.252.3910

"point. click. ship" - that's SetupBuilder 5