ODBC Microsoft accessµÇ¼ʧ°Ü
н¨µ¥Îĵµ³ÌÐòÑ¡ÔñODBCÖеÄÊý¾ÝԴʱ×ÜÊǵ¯³öÒ»¸öµÇ¼´°¿ÚÒªÊÚȨ¡£¡£¡£»¹ÒªÃÜÂë¡£¡£¡£
ÆäËûµÄµ÷ÓÃODBCÖеÄÊý¾ÝÔ´ÊǾͲ»ÐèÒªÕâ¸ö£¬¿ÉÒÔÔËÐС£
ŪÁ˺ó¤Ê±¼äÁË¡£¡£¡£
ûÓö¼û¹ý£¬¿ÉÒÔÖ±½ÓÉèÖõģ¡
¶¥Ò»Ï£¡
Ïà¹ØÎÊ´ð£º
ÎÒÏëÔÚaspÖУ¬ÊµÏÖ°Ñ£¬±í1,±í2£¬±í3£¬Öеö×ֶΣ¬²éѯ³öÀ´£¬¾ÍÊÇÈý¸ö±íÁªºÏ²éѯ£¨ÎÒÓõÄʱºòÁ½¸ö±íÁªºÏ²éѯûÓÐÎÊÌ⣬µ«ÊǾÍÊDz»ÄÜÈý¸ö±íÁªºÏ²éѯ£©£¬
ÆäÖУ¬±í2µÄ£¬mainid,×ֶκͱí1µÄid×Ö¶ÎÏà¹Ø£¬±í2µÄid×Ö¶ ......
¸÷λÅóÓÑ£¬AccessÓëSqlserver2005Á´½Óºó£¬ÔÚaccessÖпÉÒÔ·ÃÎÊsqlserverÖеÄÊý¾Ý£¬µ«Asp·ÃÎÊaccessÖеÄÊý¾Ýʱ£¬ÌáʾMicrosoft JET Database Engine (0x80004005)
ODBC--Á¬½Óµ½ 'test' ʧ°Ü¡£
Ìù³ö´úÂ ......
IsSqlDataBase = 0 'Ö÷Êý¾Ý¿âÀàÐÍ(1=SQL£¬0=AC)
'===========================================================================
SqlDatabaseName = "ads365" 'Ö÷Êý¾Ý¿âÃû
S ......
SELECT Count(*) from In_fo WHERE Reader_Time between #" + time1 + "# AND #" + time2 + "# and id=" + userid + ";
ÉÏÃæÊÇÎÒдµÄsqlÓï¾ä Reader_TimeÊÇʱ¼äÀàÐÍ idΪÊý×Ö ......
<?php
include("adodb/adodb.inc.php");
$db = &NewADOConnection("access");
$access = realpath("Data.mdb");
$dsn = "Provider=Microsoft.J ......