r***@gmail.com
2006-09-18 11:49:30 UTC
Hey All,
I'm writing a program in c-like language (VTS) which accesses an ODBC
database with SQL commands. In order to use the SQL commands you must
connect to the database using a ConnectODBC() command in the VTS
language. The connect command requires the DSN name (not the path of
database) in order to connect. It's a real pain to go into
administrative tools each time to get the right name.
I was wondering if there was a way to bring up a list of the ODBC data
sources on the system (like in the windows Microsoft ODBC Data Source
Administrator), like in a DLL file or by a SQL command.
I'm writing a program in c-like language (VTS) which accesses an ODBC
database with SQL commands. In order to use the SQL commands you must
connect to the database using a ConnectODBC() command in the VTS
language. The connect command requires the DSN name (not the path of
database) in order to connect. It's a real pain to go into
administrative tools each time to get the right name.
I was wondering if there was a way to bring up a list of the ODBC data
sources on the system (like in the windows Microsoft ODBC Data Source
Administrator), like in a DLL file or by a SQL command.