#include <iostream>
#include <windows.h>
#include "sql.h"
#include "sqlext.h"
#include "sqltypes.h"
#include "sqlucode.h"
#include "odbcss.h"
#include "tchar.h"
using namespace std;void main()
{
SQLHENV henv;
SQLRETURN rev;//,ret
SQLHDBC hdbc;
SQLHSTMT hstmt; cout<<"使用ODBC API函数访问数据库学习\n";
rev=SQLAllocHandle(SQL_HANDLE_ENV,SQL_NULL_HANDLE,&henv);
if(rev==SQL_SUCCESS_WITH_INFO || rev==SQL_SUCCESS)
{
cout<<"分配环境成功\n";
}
else
{
cout<<"分配环境失败\n";
return;
}
rev=SQLSetEnvAttr(henv,SQL_ATTR_ODBC_VERSION,(void *)SQL_OV_ODBC3,0);
if(rev==SQL_SUCCESS || rev==SQL_SUCCESS_WITH_INFO)
{
rev=SQLAllocHandle(SQL_HANDLE_DBC,henv,&hdbc);
if(rev==SQL_SUCCESS_WITH_INFO || rev==SQL_SUCCESS)
{
cout<<"分配连接句柄成功\n";
}
else
{
cout<<"分配连接句柄失败\n";
SQLFreeHandle(SQL_HANDLE_ENV, henv);
return;
}
}
UCHAR szDSN[15] = "test";
UCHAR userID[6] = "sa";
UCHAR passWORD[10] = "64236795"; rev=SQLConnect(hdbc,(SQLWCHAR *)(szDSN),SQL_NTS,(SQLWCHAR *)(userID),SQL_NTS,(SQLWCHAR *)(passWORD),SQL_NTS);
if(rev==SQL_SUCCESS_WITH_INFO || rev==SQL_SUCCESS)
{
cout<<"数据库连接成功\n"; }
else
{
cout<<"数据库连接失败\n";//system("pause");
SQLFreeHandle(SQL_HANDLE_DBC, hdbc);
SQLFreeHandle(SQL_HANDLE_ENV, henv);
system("pause");
return;
}
SQLFreeHandle(SQL_HANDLE_STMT, hstmt);
SQLDisconnect(hdbc);
SQLFreeHandle(SQL_HANDLE_DBC, hdbc);
SQLFreeHandle(SQL_HANDLE_ENV, henv);
system("pause");
return;
}
求大牛指导!!!!!!!!
#include <windows.h>
#include "sql.h"
#include "sqlext.h"
#include "sqltypes.h"
#include "sqlucode.h"
#include "odbcss.h"
#include "tchar.h"
using namespace std;void main()
{
SQLHENV henv;
SQLRETURN rev;//,ret
SQLHDBC hdbc;
SQLHSTMT hstmt; cout<<"使用ODBC API函数访问数据库学习\n";
rev=SQLAllocHandle(SQL_HANDLE_ENV,SQL_NULL_HANDLE,&henv);
if(rev==SQL_SUCCESS_WITH_INFO || rev==SQL_SUCCESS)
{
cout<<"分配环境成功\n";
}
else
{
cout<<"分配环境失败\n";
return;
}
rev=SQLSetEnvAttr(henv,SQL_ATTR_ODBC_VERSION,(void *)SQL_OV_ODBC3,0);
if(rev==SQL_SUCCESS || rev==SQL_SUCCESS_WITH_INFO)
{
rev=SQLAllocHandle(SQL_HANDLE_DBC,henv,&hdbc);
if(rev==SQL_SUCCESS_WITH_INFO || rev==SQL_SUCCESS)
{
cout<<"分配连接句柄成功\n";
}
else
{
cout<<"分配连接句柄失败\n";
SQLFreeHandle(SQL_HANDLE_ENV, henv);
return;
}
}
UCHAR szDSN[15] = "test";
UCHAR userID[6] = "sa";
UCHAR passWORD[10] = "64236795"; rev=SQLConnect(hdbc,(SQLWCHAR *)(szDSN),SQL_NTS,(SQLWCHAR *)(userID),SQL_NTS,(SQLWCHAR *)(passWORD),SQL_NTS);
if(rev==SQL_SUCCESS_WITH_INFO || rev==SQL_SUCCESS)
{
cout<<"数据库连接成功\n"; }
else
{
cout<<"数据库连接失败\n";//system("pause");
SQLFreeHandle(SQL_HANDLE_DBC, hdbc);
SQLFreeHandle(SQL_HANDLE_ENV, henv);
system("pause");
return;
}
SQLFreeHandle(SQL_HANDLE_STMT, hstmt);
SQLDisconnect(hdbc);
SQLFreeHandle(SQL_HANDLE_DBC, hdbc);
SQLFreeHandle(SQL_HANDLE_ENV, henv);
system("pause");
return;
}
求大牛指导!!!!!!!!
rev=SQLConnect(hdbc,(SQLWCHAR *)(szDSN),SQL_NTS,(SQLWCHAR *)(userID),SQL_NTS,(SQLWCHAR *)(passWORD),SQL_NTS);
if(rev==SQL_SUCCESS_WITH_INFO || rev==SQL_SUCCESS)
{
cout<<"数据库连接成功\n";
}
这条SQLConnect执行不成功