¸ßÊִͽ̡£aspºÍmysqlÁ¬½ÓµÄÎÊÌ⣡
ÎÒдµÄÓï¾äÈçÏ£º
<table border="2"> <tr> <td>
<%
Dim sConnection, Conn , objRS
'SERVERΪÊý¾Ý¿âÖ÷»úÃû£¨±¾µØÖ÷»úÓÃlocalhost,Ô¶³ÌÓÃIPµØÖ·£©£»DATABASEΪÊý¾Ý¿âÃû£»UIDΪÓû§Ãû£»PASSWORDΪÃÜÂë
sConnection = "DRIVER={mysql odbc 3.51 driver}; SERVER=58.64.162.184; DATABASE=my10080; my;PASSWORD=sz123; OPTION=3"
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open(sConnection)
'ÒÔÏÂSQLÓï¾äΪʾÀýÓï¾ä£¬Çë¸ù¾Ýʵ¼ÊÇé¿öÐÞ¸Ä
Set objRS = Conn.Execute("SELECT jieshao,tupian from wangzhanzhi where id=1")
While Not objRS.EOF 'while...wendÑ»·£¬ÓÃÓÚ¶ÁÈ¡ËùÓеÄÐÅÏ¢
Response.Write objRS.Fields("jieshao") & ", " & objRS.Fields("tupian") & " <br>"
objRS.MoveNext '¼Ç¼¼¯Ö¸ÕëÏÂÒÆ
Wend
%>
</td> </tr> </table>
³öµÄ´íÎóÈçÏ£º
Microsoft OLE DB Provider for ODBC Drivers ´íÎó '80004005'
[Microsoft][ODBC Çý¶¯³ÌÐò¹ÜÀíÆ÷] δ·¢ÏÖÊý¾ÝÔ´Ãû³Æ²¢ÇÒ
Ïà¹ØÎÊ´ð£º
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÓÐÒ»¸öÀà
class adc
{
dim a,b,c
}
ÈçºÎÔÚÁíÍâÒ»¸öÀàÖÐÈ¡µÃÀà³ÉÔ±¼°³ÉÔ±¸öÊý
class getmenber
{
dim menbers()
function getmenbers(resclass)
'resΪһδ֪Àà
'getmenber ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£
mysqlÃüÁîÐÐģʽÏÂ: ......
ASP.NETÈçºÎÓÃÒ»¸ö°´Å¥ÊµÏÖÑ¡ÔñÎļþ¼Ð·¾¶µ½Îı¾¿òÖУ¿£¨×¢ÒâÊÇÎļþ¼Ð·¾¶£¬²»ÊÇÎļþ·¾¶£©
http://blog.csdn.net/xianfajushi/archive/2008/10/18/3094474.aspx
Õâ²»ÊÇÎÒÒªµÄЧ¹û£¬ÎÒÒªÓõÄÊÇÀàËÆÓÚÎļþÉÏ´«¿ÉÒ ......