Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ODBC Microsoft accessµÇ¼ʧ°Ü

н¨µ¥Îĵµ³ÌÐòÑ¡ÔñODBCÖеÄÊý¾ÝԴʱ×ÜÊǵ¯³öÒ»¸öµÇ¼´°¿ÚÒªÊÚȨ¡£¡£¡£»¹ÒªÃÜÂë¡£¡£¡£
      ÆäËûµÄµ÷ÓÃODBCÖеÄÊý¾ÝÔ´ÊǾͲ»ÐèÒªÕâ¸ö£¬¿ÉÒÔÔËÐС£
  ŪÁ˺ó¤Ê±¼äÁË¡£¡£¡£
ûÓö¼û¹ý£¬¿ÉÒÔÖ±½ÓÉèÖõģ¡
¶¥Ò»Ï£¡


Ïà¹ØÎÊ´ð£º

asp·ÃÎÊAccessÁ´½Ó±í

¸÷λÅóÓÑ£¬AccessÓëSqlserver2005Á´½Óºó£¬ÔÚaccessÖпÉÒÔ·ÃÎÊsqlserverÖеÄÊý¾Ý£¬µ«Asp·ÃÎÊaccessÖеÄÊý¾Ýʱ£¬ÌáʾMicrosoft JET Database Engine (0x80004005)
ODBC--Á¬½Óµ½ 'test' ʧ°Ü¡£

Ìù³ö´úÂ ......

ASP.net¿ÉÒÔÓÃACCESSÒ²¿ÉÒÔÓÃSQLSERVERÔõôʵÏÖ£¿

ÏÖÔÚ×öµÄÒ»¸ö¹«Ë¾ÏîĿҪÇóÒªÓÐÁ½¸ö°æ±¾ Ò»¸öÊÇÓÃAccessµÄÊý¾Ý¿â  ÁíÒ»¸öÓÃsql server µÄÊý¾Ý¿â

ÇëÎÊÓÐ×ö¹ýÏà¹Ø¹¦ÄܵĸßÊÖ°ïæָ½Ì ÈçºÎʵÏÖ£¿

ÓõÄÊÇʲô˼·£¿
²Î¿¼petshopÀïÃæµÄ¼Ü¹¹¡£¡£¡£
......

access Êý¾Ý¿â SQLÓï¾äÔõôÑùËæ»úÑ¡ÔñÊý¾Ý£¿£¿

³ÌÐòʱASP+access

sql="select top 2 id,username from comp    order by rnd(id)  "

ÉÏÃæÓï¾äˢкó¶¼ÊÇÒ»¸öÖµ ÕâÑù»¹ÓÐËæ»úµÄÒâÒåÂð

ACCESSÓÐË¢ÐÂËæ»úÑ¡ÔñµÄSQLÓ ......

ÔÚÒ»ÕÅaccess±íÖÐǶÌײéѯ

strSQLCmd.Format(_T("select * from (select * from talk_info where %s ='%s') where %s ='%s'"),
strVar,strValue,strVar2,strValue2);
ÇëÎÊÕâÓï¾äÓÐÎÊÌâÂð
ûÓÐÎÊÌâ¡£
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ