帮我看看这段连接SQL Server的代码有没问题
MiT 2003-01-17 02:37:11 SQLHENV henv ; // 环境句柄
SQLHDBC hdbc ; // 连接句柄
RETCODE retcode;
short int cbOut ;
char str[1024] ;
strcpy(str,"DRIVER={SQL Server};SERVER=(local);UID=test;PWD=test;DATABASE=MyDB");
retcode = SQLAllocHandle(SQL_HANDLE_ENV,NULL,&henv);
if(retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO)
{
retcode = SQLSetEnvAttr(henv,SQL_ATTR_ODBC_VERSION,(void*)SQL_OV_ODBC3,0);
if(retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO)
{
retcode = SQLAllocHandle(SQL_HANDLE_DBC,henv,&hdbc);
if(retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO)
{
retcode = SQLSetConnectAttr(hdbc,SQL_LOGIN_TIMEOUT,(void*)5,0) ;
if(retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO)
{
retcode = SQLDriverConnect(hdbc,
NULL,
str,
128,
NULL,
0,
&cbOut,
SQL_DRIVER_COMPLETE);
if(retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO)
{
//......
}
}
}
}
}