Shulou(Shulou.com)06/01 Report--

Before reading this article, please read and understand the compilation and deployment of unixODBC/freetds. In addition, some of the data used in the following code comes from the article.

If you need to verify the part of the code, you can revise only part of the content (data source, user name, password, insert statement, etc.).

1. Test the source code

* # include # include SQLHDBC handlestmt; SQLHENV handleenv; SQLHDBC handlehdbc; bool ConnectDB () {long nRetState= 0; nRetState=SQLAllocHandle (SQLHANDLEENV,SQLNULLHANDLE,&handleenv); if ((nRetState! = SQLSUCCESS) & & (nRetState! = SQLSUCCESSWITHINFO)) return false; nRetState=SQLSetEnvAttr (handleenv, SQLATTRODBCVERSION, (void) SQLOVODBC3, 0) If ((nRetState! = SQLSUCCESS) & & (nRetState! = SQLSUCCESSWITHINFO)) return false; nRetState = SQLAllocHandle (SQLHANDLEDBC, handleenv, & handlehdbc); if ((nRetState! = SQLSUCCESS) & & (nRetState! = SQLSUCCESSWITHINFO) return false; SQLSetConnectAttr (handlehdbc, SQLLOGINTIMEOUT, (SQLPOINTER) 5,0) NRetState = SQLConnect (handlehdbc, (SQLCHAR) "odbc", SQLNTS, / / data source (SQLCHAR) "sa", SQLNTS / / user name (SQLCHAR) "root", SQLNTS) / / password if ((nRetState! = SQLSUCCESS) & & (nRetState! = SQLSUCCESSWITHINFO) return false; printf ("DB Connected!\ n"); return true;} bool InsertDB (SQLCHAR szSqlCmd) {long nRetState= 0; nRetState=SQLAllocHandle (SQLHANDLESTMT, handlehdbc, & handlestmt); if ((nRetState! = SQLSUCCESS) & & (nRetState! = SQLSUCCESSWITHINFO) return false NRetState=SQLExecDirect (handlestmt,szSqlCmd,SQLNTS); if ((nRetState! = SQLSUCCESS) & & (nRetState! = SQLSUCCESSWITHINFO) return false; printf ("InsertDB Success\ n"); return true;} bool CloseDB () {SQLFreeHandle (SQLHANDLESTMT,handlestmt); SQLDisconnect (handlehdbc); SQLFreeHandle (SQLHANDLEDBC,handlehdbc); SQLFreeHandle (SQLHANDLEENV, handleenv) Printf ("Excute Finished!\ n"); return true;} int main (int argc,char argv []) {char pSQLCommond = "insert into ReportServer.dbo.userTmp (ID) values (99)"; SQLCHAR pSQLCommondExe = (SQLCHAR) pSQLCommond; if (ConnectDB ()) {InsertDB (pSQLCommondExe); CloseDB ();} return (0);}

*

2, cross compilation

Note: cross-compilation allows links to odbc dynamic libraries.

3, deployment

Copy the compiled file to any location in the powerpc device, use chmod 755 * to add execution permissions to the compiled file, and link the odbc library to / usr/lib.

4, test and verify

The following execution result is received, which indicates that the database operation is successful. Note: it should be executed under the User user.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.