Linux Unix下ODBC的安装、配置与编程_5

《Linux Unix下ODBC的安装、配置与编程_5》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、这里附上例程供大家参考学习：/*odbc.ctestingunixODBC*/#include#include#include#include#includeSQLHENVV_OD_Env;//HandleODBCenvironmentlongV_OD_erg;//resultoffunctionsSQLHDBCV_OD_hdbc;//HandleconnectioncharV_OD_stat[10];//StatusSQLSQLINTEGERV_OD

2、_err,V_OD_rowanz,V_OD_id;SQLSMALLINTV_OD_mlen,V_OD_colanz;charV_OD_msg[200],V_OD_buffer[200];intmain(intargc,char*argv[]){//1.allocateEnvironmenthandleandregisterversionV_OD_erg=SQLAllocHandle(SQL_HANDLE_ENV,SQL_NULL_HANDLE,&V_OD_Env);if((V_OD_erg!=SQL_SUCCESS)&&(V_OD_erg!=SQL_SUCCESS_WITH_

3、INFO)){printf("ErrorAllocHandle");exit(0);}V_OD_erg=SQLSetEnvAttr(V_OD_Env,SQL_ATTR_ODBC_VERSION,(void*)SQL_OV_ODBC3,0);if((V_OD_erg!=SQL_SUCCESS)&&(V_OD_erg!=SQL_SUCCESS_WITH_INFO)){printf("ErrorSetEnv");SQLFreeHandle(SQL_HANDLE_ENV,V_OD_Env);exit(0);}//2.allocateconnectionhandle,setti

4、meoutV_OD_erg=SQLAllocHandle(SQL_HANDLE_DBC,V_OD_Env,&V_OD_hdbc);if((V_OD_erg!=SQL_SUCCESS)&&(V_OD_erg!=SQL_SUCCESS_WITH_INFO)){printf("ErrorAllocHDB%d",V_OD_erg);SQLFreeHandle(SQL_HANDLE_ENV,V_OD_Env);exit(0);}SQLSetConnectAttr(V_OD_hdbc,SQL_LOGIN_TIMEOUT,(SQLPOINTER*)5,0);//3.Connecttot

5、hedatasource"web"V_OD_erg=SQLConnect(V_OD_hdbc,(SQLCHAR*)"Test",SQL_NTS,(SQLCHAR*)"root",SQL_NTS,(SQLCHAR*)"",SQL_NTS);if((V_OD_erg!=SQL_SUCCESS)&&(V_OD_erg!=SQL_SUCCESS_WITH_INFO)){printf("ErrorSQLConnect%d",V_OD_erg);SQLGetDiagRec(SQL_HANDLE_DBC,V_OD_hdbc,1,V_OD_stat,&V_OD_err,V_OD_msg,

6、100,&V_OD_mlen);printf("%s(%d)",V_OD_msg,V_OD_err);SQLFreeHandle(SQL_HANDLE_ENV,V_OD_Env);exit(0);}printf("Connected!");V_OD_erg=SQLAllocHandle(SQL_HANDLE_STMT,V_OD_hdbc,&V_OD_hstmt);if((V_OD_erg!=SQL_SUCCESS)&&(V_OD_erg!=SQL_SUCCESS_WITH_INFO)){printf("FehlerimAllocStatement%d",V_OD_

7、erg);SQLGetDiagRec(SQL_HANDLE_DBC,V_OD_hdbc,1,V_OD_stat,&V_OD_err,V_OD_msg,100,&V_OD_mlen);printf("%s(%d)",V_OD_msg,V_OD_err);SQLFreeHandle(SQL_HANDLE_ENV,V_OD_Env);exit(0);}SQLBindCol(V_OD_hstmt,1,SQL_C_CHAR,&V_OD_buffer,150,&V_OD_err);SQLBindCol(V_OD