c++连接数据库
#include <iostream>
#include "windows.h"
#include "sqlext.h"
using namespace std;
int main(){
SQLHENV henv;
SQLHDBC hdbc;
SQLRETURN retcode;
SQLTCHAR ConnStrOut[256];
SQLTCHAR ConnStr[256] = L"DSN=DNS-MMLRESOLVE;UID=sa;PWD=850414";
SQLSMALLINT ConnStrOutLen;
SQLAllocHandle(SQL_HANDLE_ENV,SQL_NULL_HANDLE,&henv);
SQLSetEnvAttr(henv,SQL_ATTR_ODBC_VERSION,(void*)SQL_OV_ODBC3,0);
SQLAllocHandle(SQL_HANDLE_DBC,henv,&hdbc);
retcode = SQLDriverConnect(hdbc,NULL,ConnStr,SQL_NTS,ConnStrOut, sizeof(ConnStrOut),&ConnStrOutLen,SQL_DRIVER_NOPROMPT);
if(retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO){
cout << "ok" << endl;
cout << ConnStrOutLen << endl;
cout << ConnStrOut << endl;
}
getchar();
return 0;
}
注意:
const char to SQLCHAR
SQLCHAR* query = L"SELECT tblIP.[IPAddress], tblIP.[IPStatus], tblIP.[IPType] FROM tblIP ORDER BY tblIP.[IPAddress] ASC;";
原文链接: https://www.cnblogs.com/hongjiumu/archive/2013/02/27/2935722.html
欢迎关注
微信关注下方公众号,第一时间获取干货硬货;公众号内回复【pdf】免费获取数百本计算机经典书籍
原创文章受到原创版权保护。转载请注明出处:https://www.ccppcoding.com/archives/78962
非原创文章文中已经注明原地址,如有侵权,联系删除
关注公众号【高性能架构探索】,第一时间获取最新文章
转载文章受原作者版权保护。转载请注明原作者出处!