ä¸é¢ä»¥mySqlæ°æ®åºä¸ºä¾ï¼ç®åä»ç»ä¸ä¸ODBCæ°æ®æºçé
ç½®æ¹æ³ã
1ãå¨ç½ä¸ä¸è½½ä¸ä¸ªæ¯MYSQLæ°æ®åºçODBC驱å¨ç¨åºï¼mysql-connector-odbc-5.1.7-win32.msi以é»è®¤é项å®è£
该æ件ã
2ãæå¼âæ§å¶é¢æ¿ââââ管çå·¥å
·ââââæ°æ®æºï¼ODBCï¼â
3ãæå¼æ°æ®æºï¼ODBCï¼,å¨ç¨æ·DSNé项å¡ä¸ç¹å»âæ·»å âæé®ï¼å¼¹åºâå建æ°æ°æ®æºâçªå£ã
4ãéä¸âMYSQL ODBC 3.51 Driverâï¼ç¹å»âå®æâæé®ã
5ãå¼¹åºæ°çªå£ï¼å¨loginé项å¡ä¸å¡«åæ°æ®æºä¿¡æ¯ã
Data Source Name æ°æ®åå称ï¼
Discription æè¿°ï¼éå¡«ï¼ï¼
Server æ°æ®æºè®¡ç®æºçIPï¼
User æ°æ®åºç¨æ·åï¼
Password æ°æ®åºå¯ç ï¼
DataBase æ°æ®æºæè¦è¿æ¥çæ°æ®åºï¼
6ãé
ç½®å®åï¼ç¹å»âtestâæé®ï¼å¦ææ示è¿æ¥æåï¼å³é
ç½®æåã
7ãç¹å»âOKâè¿åç¨æ·DSNé项å¡ï¼å¢å ä¸æ¡è®°å½ï¼åä¸ºä½ æé
ç½®çæ°æ®æºå称ã
8.æå¼sql
serverä¼ä¸ç®¡çå¨ï¼æ°å»ºä¸æ°æ®åºèªå·±å½åï¼æåå为MySqlãéæ©è¯¥æ°æ®åºï¼åå»å³é®éæ©ææä»»å¡\导å
¥æ°æ®ã
9.éæ©SQL Server Import and Export Wizardï¼æ°æ®æºéæ©.Net FrameworkData
Provider for Odbc,ï¼driveså¡«å为ï¼MySQL ODBC 5.1
Driverï¼DSNå¡«å为ï¼MysqlDNS.
温馨提示:答案为网友推荐,仅供参考