ÔÚÒ»ÕÅaccess±íÖÐǶÌײéѯ
strSQLCmd.Format(_T("select * from (select * from talk_info where %s ='%s') where %s ='%s'"),
strVar,strValue,strVar2,strValue2);
ÇëÎÊÕâÓï¾äÓÐÎÊÌâÂð
ûÓÐÎÊÌâ¡£
½¨ÒéÄãͨ¹ýµ÷ÊÔ°ÑÕâ¸ö ("select * from (select * from talk_info where %s ='%s') where %s ='%s'"),strVar,strValue,strVar2,strValue2)
Êä³ö¿´Ò»Ï½á¹ûÊÇʲô£¿ ¹À¼ÆÄãµÄ±äÁ¿ÓÐÎÊÌâ¡£
strSQLCmdÄÚÈÝÊÇʲô
CString strSQLCmd;
ÊDz»ÊDZäÁ¿µÄÖµ´ú½øÈ¥ÊÇÕâÖÐÐÎʽ°¡£ºstrSQLCmd.Format(_T("select * from (select * from talk_info where strVar ='strValue') where strVar2 ='strValue2'")£»
Ïà¹ØÎÊ´ð£º
ÈçÌáʾ£ºÕÒ²»µ½Îļþ 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\Usre.mdb'¡£
´úÂ룺conn.ConnectionString = "Provider=Microsoft.Jet.oledb.4.0;Data Source=" + Server.MapPa ......
ÎÒÃÇÓÃasp+accessдһ¸öÓ¦ÓóÌÐò£¬Ï£ÍûÌá¸ßÊý¾Ý¿âµÄ°²È«ÐÔ£¬ËùÒÔ¶ÔaccessÊý¾Ý¿â½øÐÐÁËÓû§¼¶°²È«ÉèÖ㨼´ÆôÓÃÁ˹¤×÷×éȨÏÞ£©¡£ÕâÑùÒ»À´£¬µ¼ÖÂÔÀ´µÄÁ¬½Ó³ÌÐòÎÞЧÁË¡£ÏÂÃæÊÇÔÀ´µÄδÉèÖù¤×÷×éȨÏÞµÄÁ¬½Ó´úÂ룺
......
¸÷λÅóÓÑ£¬AccessÓëSqlserver2005Á´½Óºó£¬ÔÚaccessÖпÉÒÔ·ÃÎÊsqlserverÖеÄÊý¾Ý£¬µ«Asp·ÃÎÊaccessÖеÄÊý¾Ýʱ£¬ÌáʾMicrosoft JET Database Engine (0x80004005)
ODBC--Á¬½Óµ½ 'test' ʧ°Ü¡£
Ìù³ö´úÂ ......
±¾È˳õ´Î½Ó´¥£¡±È½ÏÄ£ºý£¡Ï£Íû´ó¼Ò¿ÉÒ԰ѶÔMicrosoft Office AccessµÄ±í²Ù×÷³£ÓÃÃüÁî ¸æÖ®£¡
»¹ÓÐÎÒÏëʵÏÖ°à×é¡¢ÈÕ¡¢Ô¡¢Ä걨Microsoft Office AccessÀïµÄ±íµ¥Ôõô´¦Àí£¿
ÊÇÀûÓò»Í¬µÄ±í·Ö±ð¼Ç¼Сʱ°à×éÈ ......