ããåºäºODBCçåºç¨ç¨åºå¯¹æ°æ®åºçæä½ä¸ä¾èµä»»ä½DBMSï¼ä¸ç´æ¥ä¸DBMSæ交éï¼ææçæ°æ®åºæä½ç±å¯¹åºçDBMSçODBC驱å¨ç¨åºå®æãæ以说mysqlé
ç½®ODBCæ°æ®æºä¹å¾éè¦ã
å·¥å
·/åæ
ããäºå
é
ç½®ç¸åºçç¯å¢
ããmysqlï¼mysqlå®è£
ç¨åºï¼
ããmysql-connector-odbc-3.51.20-win32.exeï¼mysqlæ°æ®æºdobcå®è£
ç¨åºï¼
ããæ¥éª¤/æ¹æ³
ããæå¼æ°æ®æºï¼å¼å§->设置->æ§å¶é¢æ¿->æ¾å°æ°æ®æº
ããæå¼æ°æ®æºï¼ODBCï¼,å¨ç¨æ·DSNé项å¡ä¸ç¹å»âæ·»å âæé®ï¼å¼¹åºâå建æ°æ°æ®æºâçªå£ã
ããéä¸âMYSQL ODBC 5.1 Driverâï¼ç¹å»âå®æâæé®ã
ããå¼¹åºæ°çªå£ï¼å¨loginé项å¡ä¸å¡«åæ°æ®æºä¿¡æ¯ã
Data Source Name æ°æ®åå称ï¼
Discription æè¿°ï¼éå¡«ï¼ï¼
Server æ°æ®æºè®¡ç®æºçIPï¼
User æ°æ®åºç¨æ·åï¼
Password æ°æ®åºå¯ç ï¼
DataBase æ°æ®æºæè¦è¿æ¥çæ°æ®åºï¼
ããé
ç½®å®åï¼ç¹å»âtestâæé®ï¼ å¦æåºç°å¦ä¸æ示ï¼å³é
ç½®æåã
ããç¹å»âOKâè¿åç¨æ·DSNé项å¡ï¼å¢å ä¸æ¡è®°å½ï¼åä¸ºä½ æé
ç½®çæ°æ®æºå称ã
ãã注æäºé¡¹
ããå¨è¿æ¥çæ¶åè¦ç¡®å®å»ºæç¸åºçæ°æ®åºï¼è¡¨ï¼ï¼å¦æ没æä¼æ示è¿æ¥å¤±è´¥ã
温馨提示:答案为网友推荐,仅供参考