[SOLVED] Reading available ODBC data source names?

EukeSnud

Is there a possibility to receive all the available odbc data source names, maybe in a QStringList? I mean these sources that are managed within Windows' ODBC-Datasource-Administration...

loladiro

I'm not aware of that kind of API within Qt. However you could use the native ODBC API functions to achieve that.

andre

On windows, you can just grab them from the registry, if I remember correctly...

EukeSnud

Tried it with the ODBC API this way:

@ SQLHENV henv;
SQLRETURN retcode;

SQLWCHAR *dbAliasBuf = (SQLWCHAR * )malloc(255);
SQLWCHAR dbCommentBuf = (SQLWCHAR)malloc(255);
SQLSMALLINT *aliasLen = (SQLSMALLINT *)malloc(255);
SQLSMALLINT *commentLen = (SQLSMALLINT *)malloc(255);

retcode = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &henv);
if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO) {
retcode = SQLDataSources(henv, SQL_FETCH_FIRST,
dbAliasBuf, SQL_MAX_DSN_LENGTH + 1,
aliasLen, dbCommentBuf,
255, commentLen);
if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO) {
LPCWSTR ad = dbAliasBuf;
}
}@

but unfortunately SQLDataSources returns -1.

EukeSnud

Solved it myself now, the following Code reads the avaiable odbc data sources and stores them in a QComboBox:

@ // Read available ODBC-Datasources
QComboBox *cbDsn = new QComboBox();
SQLHENV henv;
SQLRETURN retcode;
SQLWCHAR *dbAliasBuf = (SQLWCHAR * )malloc(SQL_MAX_DSN_LENGTH + 1);
SQLWCHAR dbCommentBuf = (SQLWCHAR)malloc(255);
SQLSMALLINT aliasLen;
SQLSMALLINT commentLen;
char ad1 = (char)malloc(SQL_MAX_DSN_LENGTH+1);
size_t pReturnValue;

retcode = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &henv);
if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO) {
SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION, (void *) SQL_OV_ODBC3, 0);
retcode = SQLDataSources(henv, SQL_FETCH_FIRST,
dbAliasBuf, SQL_MAX_DSN_LENGTH + 1,
&aliasLen, dbCommentBuf,
255, &commentLen);
while (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO) {
wcstombs_s(&pReturnValue,ad1,SQL_MAX_DSN_LENGTH+1,(LPCWSTR) dbAliasBuf,_TRUNCATE);
cbDsn->addItem(tr(ad1));
retcode=SQLDataSources(henv, SQL_FETCH_NEXT,
dbAliasBuf, SQL_MAX_DSN_LENGTH + 1,
&aliasLen, dbCommentBuf,
255, &commentLen);
}
if ( retcode == SQL_ERROR ) {
SQLWCHAR *SQLState = (SQLWCHAR * )malloc(6);
SQLINTEGER NativeError;
SQLWCHAR *MessageText = (SQLWCHAR *)malloc(255);
SQLSMALLINT TextLength;
retcode = SQLGetDiagRec(SQL_HANDLE_ENV, henv, 1, SQLState, &NativeError, MessageText, 255, &TextLength);
}
}@

Thread can be closed...

andre

You might be better off to separate the reading of the source names, and the putting them into a QComboBox. Better for code-reusability.

Note that the code above will not work: at line 2 you call your QComboBox cbdsn, while at line 21 it has become cbDsn. What's more, I don't think your string will be translatable, so I doubt the tr() on line 21 will be doing anything useful.

EukeSnud

I know, i added line 2 manually to make sure what cbDsn is...just corrected this.