获取ODBC数据源

最新推荐文章于 2025-05-20 11:57:34 发布

yaowang107

最新推荐文章于 2025-05-20 11:57:34 发布

阅读量128

点赞数

文章标签：前端数据库

本文链接：https://blog.youkuaiyun.com/yaowang107/article/details/131953827

版权

该代码段展示了在ODBC中分配环境句柄，设置环境属性为ODBC3版本，获取用户数据源并处理可能的错误的过程。通过SQLDataSources函数列出可用的数据源，并将它们添加到列表中。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SQLHENV henv;
SQLRETURN rtcode;
rtcode = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &henv);
if(rtcode != SQL_SUCCESS)
{
	SQLTCHAR Sqlstate[6];
	SQLINTEGER NativeError;
	SQLTCHAR ErrMsg[SQL_MAX_MESSAGE_LENGTH];
	int i=1;
	while(SQLGetDiagRec(SQL_HANDLE_ENV, henv, i, Sqlstate, &NativeError, ErrMsg, sizeof(ErrMsg), NULL) != SQL_NO_DATA)
	TRACE("Diag:%d,SQLSTATE:%s,NativeError:%d, ErrMsg:%s\n", i++, Sqlstate, NativeError, ErrMsg);
}	

rtcode = SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION, (void*)SQL_OV_ODBC3, 0);
if(rtcode != SQL_SUCCESS)
{
	SQLTCHAR Sqlstate[6];
	SQLINTEGER NativeError;
	SQLTCHAR ErrMsg[SQL_MAX_MESSAGE_LENGTH];
	int i=1;
	while(SQLGetDiagRec(SQL_HANDLE_ENV, henv, i, Sqlstate, &NativeError, ErrMsg, sizeof(ErrMsg), NULL) != SQL_NO_DATA)
	TRACE("Diag:%d,SQLSTATE:%s,NativeError:%d, ErrMsg:%s\n", i++, Sqlstate, NativeError, ErrMsg);
}	

SQLTCHAR ServerName[MAX_LENTH] = {0}, Description[MAX_LENTH] = {0};

SQLSMALLINT ServerNameLength, DescNameLength;
/*rtcode = SQLDataSources(henv, SQL_FETCH_FIRST_SYSTEM, ServerName, MAX_LENTH, &ServerNameLength, Description, MAX_LENTH, &DescNameLength);*/
rtcode = SQLDataSources(henv, SQL_FETCH_FIRST_USER, ServerName, MAX_LENTH, &ServerNameLength, Description, MAX_LENTH, &DescNameLength);
if(rtcode != SQL_SUCCESS)
{
	SQLTCHAR Sqlstate[6];
	SQLINTEGER NativeError;
	SQLTCHAR ErrMsg[SQL_MAX_MESSAGE_LENGTH];
	int i=1;
	while(SQLGetDiagRec(SQL_HANDLE_ENV, henv, i, Sqlstate, &NativeError, ErrMsg, sizeof(ErrMsg), NULL) != SQL_NO_DATA)
	TRACE("Diag:%d,SQLSTATE:%s,NativeError:%d, ErrMsg:%s\n", i++, Sqlstate, NativeError, ErrMsg);
}

if(rtcode == SQL_NO_DATA)
{
	TRACE("NO Data Source!");
}
else
{
	m_ctlUserList.AddString((LPCTSTR)((LPCWSTR)ServerName));
    do 
	{
		rtcode = SQLDataSources(henv, SQL_FETCH_NEXT, ServerName, MAX_LENTH, &ServerNameLength, Description, MAX_LENTH, &DescNameLength);
		if(rtcode != SQL_NO_DATA) 
		m_ctlUserList.AddString((LPCTSTR)((LPCWSTR)ServerName));	
		if(rtcode != SQL_SUCCESS)
		{
			SQLTCHAR Sqlstate[6];
			SQLINTEGER NativeError;
			SQLTCHAR ErrMsg[SQL_MAX_MESSAGE_LENGTH];
			int i=1;
			while(SQLGetDiagRec(SQL_HANDLE_ENV, henv, i, Sqlstate, &NativeError, ErrMsg, sizeof(ErrMsg), NULL) != SQL_NO_DATA)
			TRACE("Diag:%d,SQLSTATE:%s,NativeError:%d, ErrMsg:%s\n", i++, Sqlstate, NativeError, ErrMsg);
		}
	}while(rtcode != SQL_NO_DATA);
}
rtcode = SQLFreeHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE);
if(rtcode != SQL_SUCCESS)
{
	SQLTCHAR Sqlstate[6];
	SQLINTEGER NativeError;
	SQLTCHAR ErrMsg[SQL_MAX_MESSAGE_LENGTH];
	int i=1;
	while(SQLGetDiagRec(SQL_HANDLE_ENV, henv, i, Sqlstate, &NativeError, ErrMsg, sizeof(ErrMsg), NULL) != SQL_NO_DATA)
	TRACE("Diag:%d,SQLSTATE:%s,NativeError:%d, ErrMsg:%s\n", i++, Sqlstate, NativeError, ErrMsg);
}