#include <WinSock2.h>
#include <Windows.h>
#include <tchar.h>
#include <mysql.h>
#include <sql.h>
#include <sqlext.h>
#include <sqltypes.h>
#include <iostream>
using namespace std;
int _tmain(int argc, _TCHAR* argv[])
{
SQLHENV sql_hEvn = 0;
SQLHDBC sql_hDBC = 0;
SQLHSTMT sql_hStmt = 0;
SQLWCHAR szDNS[1024] = {0};
SQLSMALLINT nSize = 0;
SQLRETURN sqlRet =
SQLAllocHandle(SQL_HANDLE_ENV,
SQL_NULL_HANDLE,
&sql_hEvn);
sqlRet =
SQLSetEnvAttr(sql_hEvn,
SQL_ATTR_ODBC_VERSION,
(void*)SQL_OV_ODBC3,
0);
sqlRet =
SQLAllocHandle(SQL_HANDLE_DBC,
sql_hEvn,
&sql_hDBC);
// if 0 - use SQLDriverConnect
// if 1 - use SQLConnect
#if 1
sqlRet =
SQLConnect(sql_hDBC,
(SQLWCHAR*)"wzdftpd",
14,//SQL_NTS,
(SQLWCHAR*)"root",
8,//SQL_NTS,
(SQLWCHAR*)"root",
8//SQL_NTS
);
#else
sqlRet =
SQLDriverConnect(sql_hDBC,
0,
(SQLWCHAR*)"DSN=wzdftpd;UID=root;PWD=root;",
SQL_NTS,
szDNS,
1024,
&nSize,
SQL_DRIVER_COMPLETE);
#endif
if (