CÓïÑÔÓëSQL SERVERÊý¾Ý¿â

1.ʹÓÃCÓïÑÔÀ´²Ù×÷SQL SERVERÊý¾Ý¿â,²ÉÓÃODBC¿ª·ÅʽÊý¾Ý¿âÁ¬½Ó½øÐÐÊý¾ÝµÄÌí¼Ó,ÐÞ¸Ä,ɾ³ý,²éѯµÈ²Ù×÷¡£
step1:Æô¶¯SQLSERVER·þÎñ,ÀýÈç:HNHJ,¿ªÊ¼²Ëµ¥ ->ÔËÐÐ ->net start mssqlserver
step2:´ò¿ªÆóÒµ¹ÜÀíÆ÷,½¨Á¢Êý¾Ý¿âtest,ÔÚtest¿âÖн¨Á¢test±í(a varchar(200),b varchar(200))
step3:½¨Á¢ÏµÍ³DSN,¿ªÊ¼²Ëµ¥ ->ÔËÐÐ ->odbcad32,
  Ìí¼Ó->SQL SERVER
Ãû³Æ£ºcsql,·þÎñÆ÷£ºHNHJ
ʹÓÃÓû§Ê¹ÓõǼIDºÍÃÜÂëµÄSQLSERVERÑéÖ¤,µÇ¼ID:sa,ÃÜÂë:
  ¸ü¸ÄĬÈϵÄÊý¾Ý¿âΪ:test
...
²âÊÔÊý¾ÝÔ´£¬²âÊԳɹ¦£¬¼´DNSÌí¼Ó³É¹¦¡£ 2.cppÎļþÍêÕû´úÂë #include
#include
#include
#include
#include
#include
#include
SQLHENV henv = SQL_NULL_HENV;
SQLHDBC hdbc1 = SQL_NULL_HDBC;
SQLHSTMT hstmt1 = SQL_NULL_HSTMT;
/*
cppÎļþ¹¦ÄÜ˵Ã÷£º
1.Êý¾Ý¿â²Ù×÷ÖеÄÌí¼Ó£¬Ð޸ģ¬É¾³ý£¬Ö÷ÒªÌåÏÖÔÚSQLÓï¾äÉÏ
2.²ÉÓÃÖ±½ÓÖ´Ðз½Ê½ºÍ²ÎÊýÔ¤±àÒëÖ´Ðз½Ê½Á½ÖÖ
*/
int main(){
RETCODE retcode;
UCHAR szDSN[SQL_MAX_DSN_LENGTH+1] = "csql",
szUID[MAXNAME] = "sa",
szAuthStr[MAXNAME] = "";
//SQLÓï¾ä
//Ö±½ÓSQLÓï¾ä
UCHAR sql[37] = "insert into test values('aaa','100')";
//Ô¤±àÒëSQLÓï¾ä
UCHAR pre_sql[29] = "insert into test values(?,?)";
//1.Á¬½ÓÊý¾ÝÔ´
//1.»·¾³¾ä±ú
retcode = SQLAllocHandle (SQL_HANDLE_ENV, NULL, &henv);
retcode = SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION,
(SQLPOINTER)SQL_OV_ODBC3,
SQL_IS_INTEGER);
//2.Á¬½Ó¾ä±ú
retcode = SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc1);
retcode = SQLConnect(hdbc1, szDSN, 4, szUID, 2, szAuthStr, 0);
//ÅжÏÁ¬½ÓÊÇ·ñ³É¹¦
if ( (retcode != SQL_SUCCESS) && (retcode != SQL_SUCCESS_WITH_INFO) ) {
printf("Á¬½Óʧ°Ü!\n");
} else {
//2.´´½¨²¢Ö´ÐÐÒ»Ìõ»ò¶àÌõSQLÓï¾ä
/*
1.·ÖÅäÒ»¸öÓï¾ä¾ä±ú(statement handle)
2.´´½¨SQLÓï¾ä
3.Ö´ÐÐÓï¾ä
4.Ïú»ÙÓï¾ä
*/
retcode = SQLAllocHandle(SQL_HANDLE_STMT, hdbc1, &hstmt1);