char szCONNECT[] = "Driver={SQL Server};Server=.\\NOMDUSERVEUR;Database=BNTESTS;" "Trusted_Connection=yes;Uid=BruNews;Pwd=TonMotDePasse"; char szSQL[] = "SELECT fldA FROM BLKA"; char szappname[] = "blkAdd"; SQLHANDLE henv 0, hconn 0; int bnConnectDB() { if(SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &henv) & 0xFFFE) return 0; if(SQLSetEnvAttr(henv,SQL_ATTR_ODBC_VERSION,(SQLPOINTER) 3, SQL_IS_INTEGER) & 0xFFFE) goto sqlFREEENV; if(SQLAllocHandle(SQL_HANDLE_DBC, henv, &hconn) & 0xFFFE) goto sqlFREEENV; if(SQLDriverConnect(hconn, 0, szCONNECT, SQL_NTS, 0, 0, 0, SQL_DRIVER_NOPROMPT) & 0xFFFE) goto sqlFREEHDBC; return 1; sqlFREEHDBC: SQLFreeHandle(SQL_HANDLE_DBC, hconn); sqlFREEENV: SQLFreeHandle(SQL_HANDLE_ENV, henv); return 0; } void bnDisconnectDB() { SQLDisconnect(hconn); SQLFreeHandle(SQL_HANDLE_DBC, hconn); SQLFreeHandle(SQL_HANDLE_ENV, henv); }
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionif(retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO) retcode=SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt); else { printf("Erreur sur l'instruction SQLAllocHandle !\n"); cout<<"ret :"<<retcode<<"\n"; } // Execution de la requete if(retcode SQL_SUCCESS || retcode SQL_SUCCESS_WITH_INFO) retcode=SQLExecDirect(hstmt, (SQLCHAR*)requete, SQL_NTS); else { printf("Erreur sur l'instruction SQLExecDirect !\n"); cout<<"ret :"<<retcode<<"\n"; }