1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48
|
#include <windows.h>
#include <sql.h>
#include <sqlext.h>
#include <sqltypes.h>
#include <stdio.h>
int main () {
// Déclaration des variables SQL
SQLRETURN retcode;
SQLHENV henv;
SQLHDBC hdbc;
SQLHSTMT hstmt;
char* param_con = "DRIVER={SQL SERVER}; Address=10.0.0.200:1433; Trusted_Connection=No; UID=mon_UID; PWD=mon_PWD;";
// setting environnement handle
retcode=SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &henv);
// Setting ODBC Driver version
if(retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO)
retcode=SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION, (void*)SQL_OV_ODBC3,0);
else printf("Erreur sur l'instruction SQLAllocHandle !\n");
// setting connection handle
if(retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO)
retcode=SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc);
else printf("Erreur sur l'instruction SQLSetEnvAttr !\n");
// Connection to database
if(retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO)
retcode = SQLDriverConnect(hdbc, NULL, (SQLWCHAR*) param_con, SQL_NTS, NULL, SQL_NTS, NULL, SQL_DRIVER_COMPLETE);
else printf("Erreur sur l'instruction SQLAllocHandle !\n");
if(retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO)
retcode=SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt);
else printf("Erreur sur l'instruction SQLConnect !\n");
// Déconnexion
//SQLFreeStmt(hstmt, SQL_DROP);
SQLDisconnect(hdbc);
SQLFreeConnect(hdbc);
// Pause
system("PAUSE");
return 0;
} |
Partager