How can I display a list of User DSN's in my program? I want to mimic the list you get under 'ODBC Data Sources' on the control panel. Is there an MFC object for this? Do I have to look in the registry? Thanks for any help.
Printable View
How can I display a list of User DSN's in my program? I want to mimic the list you get under 'ODBC Data Sources' on the control panel. Is there an MFC object for this? Do I have to look in the registry? Thanks for any help.
Use the ODBC API like this:
HENV hEnv;
UCHAR tmpDSN[256];
SWORD tmpDSNLen = 255;
SWORD ResultLen;
UCHAR tmpDriver[256];
SWORD tmpDriverLen = 255;
SWORD ResultDescLen;
RETCODE ReturnCode = SQL_SUCCESS;
ReturnCode = ::SQLAllocEnv(&hEnv);
if (SQL_SUCCESS == ReturnCode)
{
ReturnCode = ::SQLDataSources(hEnv, SQL_FETCH_FIRST, tmpDSN, tmpDSNLen, &ResultLen, tmpDriver, tmpDriverLen, &ResultDescLen);
while (SQL_SUCCESS == ReturnCode)
{
ReturnCode = ::SQLDataSources(hEnv, SQL_FETCH_NEXT, tmpDSN, tmpDSNLen, &ResultLen, tmpDriver, tmpDriverLen, &ResultDescLen);
}
}
::SQLFreeEnv(hEnv);
This will return all the DSNs you'll have to do something about listing only User DSNs.