ÓÃ.netÁ´½Ómysqlʱ±¨´í?????? - .NET¼¼Êõ / C#
ÓÃ.net,ÔÚÁ¬½ÓmysqlÊDZ¨´í£º unable to connect to any of the specified mysql hosts. connectionString="server=ip;userid=*;password=*;database=*"
¶¥¡£¡£¡£ MYSQL ¹Ù·½ ÏÂÔØÒ»¸öÖмä¼þ. <add name="ConStr" connectionString="server=192.169.1.115;database=miapsoft;uid=root;pwd=123456;charset=utf8" providerName="MySql.Data.MySqlClient"/> ÕâÊÇÎÒÒÔǰÓùýµÄ. charset=utf8 ÓÃÀ´ÅªÖÐÎÄÂÒÂëÎÊÌâ. dingÒýÓà MYSQL ¹Ù·½ ÏÂÔØÒ»¸öÖмä¼þ. ÕÒµ½¡°Select a Mirror to Start Downloading - mysql-connector-net-6.2.3-src.zip¡±Õâ¸öûÓÐÏֳɵÄdllÎļþ£¬ÎÒ±àÒëʱ³ö´í£¬ÄãÓÐÏֳɵÄ6.2.3°æµÄMysql.Data.dllÂ𣿣¿ ûÓÐ °²×°ºÃÄǸö¾Í¿ÉÒÔÁË. c# Á¬MysqlÐèÒª×Ô¼ºÐ´»òÊÇϸöÖмä¼þ ÓкÎÄÑ,ÏÈÏÂÔØÒ»¸öMySQLDriverCS.dll app.config: <add name="mysql" connectionString="Data Source=mydb;Password=111111;User ID=root;Location=192.168.1.1" /> C# code: using MySQLDriverCS; string MySQLStr = ConfigurationManager.ConnectionStrings["mysql"].ConnectionString; MySQLConnection MySQLConn = new MySQLConnection(xxxxxxxxxxxxxxxxxxx); MySQLConn.Open(); MySQLCommand MyCmd = new MySQLCommand(@"select * from table",MySQLConn); MyCmd.ExecuteNonQuery();
Ïà¹ØÎÊ´ð£º
ÏÈÉÏ´íÎó ÎÞ·¨Áª½ÓÊý¾Ý¿â java.sql.SQLException: Before start of result set at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910) at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml <Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
ÄÚÈÝÈçÌâ¡£¡£ÔÚC#Àï¸ÄÈçºÎÐ´ÄØ£¿ ±¾À´Ë¼Â·ÊÇÏȱȶԽڵãÃû³Æ£¬ÈçÊǵϰ¾Í±£´æÒªÉ¾³ý½ÚµãµÄϱê·ÅÔÚÊý×éÀȻºóÑ»·É¾³ý£¬µ«·¢ÏÖ¡£¡£µ±ÎÒɾ³ýµÚÒ»¸öºó£¬ËùÓнڵãϱêÊýÁ¿¶¼·¢Éú¸Ä±ä¡£¡£ ¾Í²»ÄÜÔÙ°´ÕÕ֮ǰ¼Í¼µÄ½Úµã ......
Ŀǰ¹«Ë¾ÔÚ×öÆäËû¹«Ë¾µÄC/SÈí¼þµÄ´úÀí£¬ÏÖÔÚÏë·ÂÕÕËûµÄ²úÆ·×Ô¼º×ö£¬Ö»Êǹ¦ÄÜ·ÂÕÕ¶øÒÑ£¬²»Çå³þËûÃÇÊÇÓÃʲô¼¼Êõ¿ª·¢µÄ£¬ÎÒÃÇÓÃwinform¿ª·¢ÁËÏàËÆµÄ¹¦ÄÜ£¬ËûÃǵÄÔ´´úÂëÎÒÃÇûÓУ¬Òò´ËÔÚÔ´´úÂëÉÏûÓзÂÕյĿÉÄÜÐÔ£¬ÎÒÃÇ ......