Chapter聽26.聽 Connectors - MySQL 5.1参考手册中文版

濡傛灉閬囧埌涓嶮yODBC鏈夊叧鐨勫洶闅炬垨闂�棰橈紝棣栧厛搴斾娇鐢�ODBC绠＄悊鍣ㄥ拰MyODBC鐢熸垚涓�浠芥棩蹇楁枃浠�锛堣�锋眰鏉ヨ嚜ODBC ADMIN鐨勬棩蹇楁椂鑾峰緱鐨勬棩蹇楁枃浠讹級銆�鍏充簬瀹屾垚璇ユ�ラ�ょ殑鏂瑰紡锛岃�峰弬瑙�26.1.9.7鑺傦紝鈥滆幏鍙朞DBC璺熻釜鏂囦欢鈥�銆�

妫�鏌�MyODBC璺熻釜鏂囦欢锛屾壘鍑哄彲鑳藉嚭閿欑殑鍦版柟銆傞�氳繃鍦�myodbc.log鏂囦欢涓�鎼滅储瀛楃�︿覆鈥�>mysql_real_query鈥�锛屽彲纭�瀹氬凡鎵ц�岀殑璇�鍙ャ��

姝ゅ�栵紝浣犺繕搴斿皾璇曚粠mysql瀹㈡埛绔�绋嬪簭鎴�admndemo鎵ц�岃��鍙�銆傝繖鏍凤紝灏辫兘甯�鍔╀綘纭�瀹氶敊璇�鐨勫嚭澶勶紝MyODBC鎴朚ySQL銆�

濡傛灉浣犲彂鐜颁簡涓嶆�ｇ‘鐨勪簨椤癸紝璇峰皢鐩稿叧琛岋紙鏈�澶�40琛岋級鍙戦�佺粰MyODBC閭�浠跺垪琛ㄣ�傝�峰弬瑙�1.7.1.1鑺傦紝鈥淢ySQL閭�浠跺垪琛ㄢ��銆傝�峰嬁鍙戦�佹暣涓狹yODBC鎴朞DBC鏃ュ織鏂囦欢锛�

濡傛灉浣犳棤娉曟壘鍑洪敊璇�涔嬫墍鍦�锛屾渶鍚庣殑閫夋嫨鏄�锛屼互tar鎴杬ip鏍煎紡鍒涘缓鍖呭惈MyODBC璺熻釜鏂囦欢銆丱DBC鏃ュ織鏂囦欢鍜孯EADME鏂囦欢锛堥槓鏄庨棶棰橈級鐨勬。妗堛�備綘鍙�浠ュ皢璇ユ。妗堟枃浠跺彂閫佽嚦ftp://ftp.mysql.com/pub/mysql/upload/銆傚彧鏈変綅浜嶮ySQL AB鐨勬垜浠�鎵嶈兘璁块棶浣犱笂浼犵殑鏂囦欢锛岃�屼笖鎴戜滑浼氬崄鍒嗚皑鎱庡湴瀵瑰緟杩欑被鏁版嵁銆�

濡傛灉浣犲垱寤轰簡浠嶅嚭鐜伴棶棰樼殑绋嬪簭锛岃�峰皢璇ョ▼搴忎篃鍖呭惈鍦ㄦ。妗堟枃浠朵腑銆�

濡傛灉绋嬪簭鑳藉�熶笌鏌愪簺鍏朵粬SQL鏈嶅姟鍣ㄤ竴璧峰伐浣滐紝妗ｆ�堜腑杩樺簲鍖呭惈鍦ㄨ繖绫诲叾浠朣QL鏈嶅姟鍣ㄤ笅宸ヤ綔鐨凮DBC鏃ュ織鏂囦欢銆�

璇疯�颁綇锛屼綘鎻愪緵缁欐垜浠�鐨勪俊鎭�瓒婂�氾紝鎴戜滑鏇存�ｉ棶棰樼殑鏈轰細灏辫秺澶с��

寮�鏀惧紡鏁版嵁搴撹繛鎺ユ�э紙ODBC锛夋槸骞挎硾鎺ュ彈鐨勭敤浜庢暟鎹�搴撹�块棶鐨勫簲鐢ㄧ▼搴忕紪绋嬫帴鍙ｏ紙API锛夈�傚畠鍩轰簬閽堝�规暟鎹�搴揂PI鐨凜LI锛堣皟鐢ㄥ眰鎺ュ彛锛夎�勮寖锛堟潵鑷猉/Open鍜孖SO/IEC锛夛紝骞堕噰鐢ㄤ簡缁撴瀯鍖栨煡璇㈣��瑷�锛圫QL锛変綔涓哄叾鏁版嵁搴撹�块棶璇�瑷�銆�

鍦�26.1.16鑺傦紝鈥淢yODBC API寮曠敤鈥�涓�锛屾�傝�佷粙缁嶄簡MyODBC鏀�鎸佺殑ODBC鍔熻兘銆傚叧浜嶰DBC鐨勬洿澶氫俊鎭�锛岃�峰弬闃�http://www.microsoft.com/data/銆�

瑕佹兂浣跨敤RPM鍒嗗彂鐗堝湪Linux骞冲彴涓婂畨瑁呮垨鍗囩骇MyODBC锛屽彲绠�鍗曞湴涓嬭浇鏈�鏂癕yODBC鐨凴PM鍒嗗彂鐗堬紝骞舵寜鐓т笅闈�浠嬬粛鐨勬柟寮忔搷浣溿�備娇鐢�su root鎴愪负鏍圭敤鎴凤紝鐒跺悗瀹夎�匯PM鏂囦欢銆�

濡傛灉鏄�棣栨�″畨瑁咃細

shell> su root

shell> rpm -ivh MyODBC-3.51.01.i386-1.rpm

濡傛灉椹卞姩绋嬪簭宸插瓨鍦�锛屽彲鎸夌収涓嬭堪鏂瑰紡鍗囩骇瀹冿細

shell> su root

shell> rpm -Uvh MyODBC-3.51.01.i386-1.rpm

濡傛灉瀛樺湪鍏充簬MySQL瀹㈡埛绔�搴�libmysqlclient鐨勪换浣曚緷瀛橀敊璇�锛屽彲浣跨敤鈥�-nodeps鈥�閫夐」绠�鍗曞湴蹇界暐瀹冿紝鐒跺悗纭�淇滿ySQL瀹㈡埛绔�鍏变韩搴撲綅浜庤矾寰勪腑鎴栭�氳繃LD_LIBRARY_PATH杩涜�屼簡璁剧疆銆�

杩欐牱锛屽氨浼氬皢椹卞姩绋嬪簭搴撳拰鐩稿叧鏂囦欢鍒嗗埆瀹夎�呭埌/usr/local/lib鍜�/usr/share/doc/MyODBC鐩�褰曚笅銆傝�疯浆鑷�26.1.9.3鑺傦紝鈥滃湪Unix骞冲彴涓婇厤缃甅yODBC DSN鈥�銆�

瑕佹兂鍗歌浇椹卞姩绋嬪簭锛岃�烽�栧厛鎴愪负鏍圭敤鎴凤紝鐒跺悗鎵ц��rpm鍛戒护锛�

shell> su root

shell> rpm -e MyODBC

瑕佹兂浠巘arball鍒嗗彂鐗堬紙.tar.gz鏂囦欢锛夊畨瑁呴┍鍔ㄧ▼搴忥紝璇蜂笅杞介拡瀵逛綘鎵�浣跨敤鎿嶄綔绯荤粺鐨勬渶鏂扮増椹卞姩绋嬪簭锛岀劧鍚庢寜鐓т笅杩版�ラ�ゆ搷浣滐細

shell> su root

shell> gunzip MyODBC-3.51.01-i686-pc-linux.tar.gz

shell> tar xvf MyODBC-3.51.01-i686-pc-linux.tar

shell> cd MyODBC-3.51.01-i686-pc-linux

璇烽槄璇�INSTALL-BINARY鏂囦欢涓�鐨勫畨瑁呰�存槑锛屽苟鎵ц�屼笅杩板懡浠わ細

shell> cp libmyodbc* /usr/local/lib

shell> cp odbc.ini /usr/local/etc

shell> export ODBCINI=/usr/local/etc/odbc.ini

鐒跺悗锛岃�疯烦鑷�26.1.9.3鑺傦紝鈥滃湪Unix骞冲彴涓婇厤缃甅yODBC DSN鈥�涓篗yODBC閰嶇疆DSN銆傛洿澶氫俊鎭�锛岃�峰弬瑙佷笌鍙戝竷鐗堜竴璧锋彁渚涚殑INSTALL-BINARY鏂囦欢銆�

--enable-thread-safe

--disable-thread-safe

LIBS="-lpthread" ./configure ..

鍙�浠ヤ娇鐢ㄤ笅杩伴�夐」鍚�鐢ㄦ垨绂佹�㈠叡浜�鍜岄潤鎬侀�夐」锛�

--enable-shared[=yes/no]
--disable-shared
--enable-static[=yes/no]
--disable-static

shell> make

鍦ㄥぇ澶氭暟骞冲彴涓婏紝榛樿�ゆ儏鍐典笅锛孧ySQL涓嶄細鍒涘缓鎴栨敮鎸佲��.so鈥�锛堝叡浜�锛夊�㈡埛绔�搴擄紝杩欐槸鍥犱负锛屽垱寤哄叡浜�搴撳湪杩囧幓閫犳垚杩囧緢澶氶棶棰樸��

鍦ㄨ繖绉嶆儏鍐典笅锛屼綘鍙�浠ヤ笅杞組ySQL鍒嗗彂鐗堬紝骞朵娇鐢ㄤ互涓嬮�夐」杩涜�岄厤缃�锛�

--without-server --enable-shared

瑕佹兂鍒涘缓鍏变韩椹卞姩绋嬪簭搴擄紝蹇呴』涓衡��configure鈥濇寚瀹氣��--enable-shared鈥�閫夐」銆�榛樿�ゆ儏鍐典笅锛屸��configure鈥濅笉鍚�鐢ㄨ�ラ�夐」銆�

濡傛灉浣跨敤鈥�--disable-shared鈥濋�夐」杩涜�屼簡閰嶇疆鎿嶄綔锛屽彲浣跨敤涓嬭堪鍛戒护锛屼粠闈欐�佸簱鍒涘缓鈥�.so鈥濇枃浠躲��

shell> cd MyODBC-3.51.01
shell> make
shell> cd driver
shell> CC=/usr/bin/gcc \
     $CC -bundle -flat_namespace -undefined error \
         -o .libs/libmyodbc3-3.51.01.so \
         catalog.o connect.o cursor.o dll.o error.o execute.o \
         handle.o info.o misc.o myodbc3.o options.o prepare.o \
         results.o transact.o utility.o \
         -L/usr/local/mysql/lib/mysql/ \
         -L/usr/local/iodbc/lib/ \
         -lz -lc -lmysqlclient -liodbcinst

濡傛灉浣犳�ｅ湪浣跨敤unixODBC鑰屼笉鏄痠ODBC锛屽姟蹇呭皢鈥�-liodbcinst鈥�鏇存敼涓�鈥�-lodbcinst鈥�锛屽苟鐩稿簲鍦伴厤缃�搴撹矾寰勩��

杩欐牱锛屽氨鍒涘缓浜�libmyodbc3-3.51.01.so鏂囦欢锛屽苟灏嗗叾鏀惧湪鈥�.libs鈥�鐩�褰曚笅銆�灏嗚�ユ枃浠舵嫹璐濆埌MyODBC搴撶洰褰曚笅锛�/usr/local/lib锛屾垨浣跨敤鈥�--prefix鈥�鎻愪緵鐨勫畨瑁呯洰褰曚笅鐨�鈥�lib鈥�鐩�褰曪級銆�

shell> cd .libs

shell> cp libmyodbc3-3.51.01.so /usr/local/lib

shell> cd /usr/local/lib

shell> ln -s libmyodbc3-3.51.01.so libmyodbc3.so

瑕佹兂鍒涘缓绾跨▼瀹夊叏椹卞姩绋嬪簭搴擄細

shell> CC=/usr/bin/gcc \
     $CC -bundle -flat_namespace -undefined error
      -o .libs/libmyodbc3_r-3.51.01.so
      catalog.o connect.o cursor.o dll.o error.o execute.o
      handle.o info.o misc.o myodbc3.o options.o prepare.o
      results.o transact.o utility.o
      -L/usr/local/mysql/lib/mysql/
      -L/usr/local/iodbc/lib/
      -lz -lc -lmysqlclient_r -liodbcinst

shell> CC="cc" \

     CFLAGS="+z" \

     LDFLAGS="-Wl,+b:-Wl,+s" \

     ./configure --prefix=/usr/local

           --with-unixodbc=/usr/local

           --with-mysql-path=/usr/local/mysql/lib/mysql

           --enable-shared

           --enable-thread-safe

shell> CC="gcc" \

     LDFLAGS="-Wl,+b:-Wl,+s" \

     ./configure --prefix=/usr/local

           --with-unixodbc=/usr/local

           --with-mysql-path=/usr/local/mysql

           --enable-shared

           --enable-thread-safe

瑕佹兂鍦ˋIX鐜�澧冧笅鍒涘缓椹卞姩绋嬪簭锛屽彲浣跨敤涓嬭堪configure绀轰緥锛�

shell> ./configure --prefix=/usr/local

           --with-unixodbc=/usr/local

           --with-mysql-path=/usr/local/mysql

           --disable-shared

           --enable-thread-safe

瑕佹兂鍦╓indows骞冲彴涓婃坊鍔犲拰閰嶇疆鏂扮殑MyODBC鏁版嵁婧愶紝璇蜂娇鐢�ODBC鏁版嵁婧愮�＄悊鍣ㄣ�侽DBC绠＄悊鍣ㄨ兘澶熸洿鏂版暟鎹�婧愯繛鎺ヤ俊鎭�銆�娣诲姞浜嗘暟鎹�婧愭椂锛�ODBC绠＄悊鍣ㄨ兘澶熸洿鏂版敞鍐屼俊鎭�銆�

瑕佹兂浠庢帶鍒堕潰鏉挎墦寮�ODBC绠＄悊鍣�锛�

1.    鐐瑰嚮鈥滃紑濮嬧�濓紝灏嗘寚閽堟寚鍚戔�滆�剧疆鈥濓紝鐒跺悗鐐瑰嚮鈥滄帶鍒堕潰鏉库�濄��

2.    鍦ㄨ繍琛孧icrosoft Windows 2000鎴栨洿鏂扮増鏈�鐨勮�＄畻鏈轰笂锛屽弻鍑烩�滅�＄悊宸ュ叿鈥濓紝鐒跺悗鍙屽嚮鈥滄暟鎹�婧愨�濓紙ODBC锛夈�傚湪杩愯�屾棫鐗堟湰Windows鐨勮�＄畻鏈轰笂锛屽弻鍑�32浣峅DBC鎴�ODBC銆�

鎵撳紑ODBC鏁版嵁婧愮�＄悊鍣ㄥ�硅瘽妗嗭紝濡備笅鍥炬墍绀猴細

鐐瑰嚮鈥滃府鍔┾�濅互浜嗚ВODBC鏁版嵁婧愮�＄悊鍣ㄥ�硅瘽妗嗗悇閫夐」鍗＄殑璇︾粏淇℃伅銆�

瑕佹兂鍦╓indows骞冲彴涓婃坊鍔犳暟鎹�婧愶細

1.    鎵撳紑ODBC鏁版嵁婧愮�＄悊鍣ㄣ��

2.    鍦∣DBC鏁版嵁婧愮�＄悊鍣ㄥ�硅瘽妗嗕腑锛岀偣鍑烩�滄坊鍔犫�濄�傛墦寮�鈥滃垱寤烘柊鏁版嵁婧愨�濆�硅瘽妗嗐��

3.    閫夋嫨MySQL ODBC 3.51椹卞姩绋嬪簭锛岀劧鍚庣偣鍑�鈥�瀹屾垚鈥�銆�鎵撳紑鈥�MySQL ODBC 3.51椹卞姩绋嬪簭-DSN閰嶇疆鈥�瀵硅瘽妗嗭紝濡備笅鍥炬墍绀猴細

4.    鍦ㄢ�滄暟鎹�婧愬悕鈥濇�嗕腑锛岃緭鍏ユ墦绠楄�块棶鐨勬暟鎹�婧愮殑鍚嶇О銆傚畠鍙�浠ユ槸浣犻�夋嫨鐨勪换浣曟湁鏁堝悕绉般��

5.    鍦ㄢ�滄弿杩扳�濇�嗕腑锛岃緭鍏�DSn鎵�闇�鐨勬弿杩颁俊鎭�銆�

6.    鍦ㄢ�滀富鏈衡�濇垨鈥滄湇鍔″櫒鍚嶁�濓紙鎴朓P锛夋�嗕腑锛岃緭鍏ュ噯澶囪�块棶鐨凪ySQL鏈嶅姟鍣ㄤ富鏈虹殑鍚嶇О銆傞粯璁ゆ儏鍐典笅涓�localhost锛堟湰鍦颁富鏈猴級銆�

7.    鍦ㄢ�滄暟鎹�搴撳悕鈥濇�嗕腑锛岃緭鍏ュ噯澶囩敤浣滈粯璁ゆ暟鎹�搴撶殑MySQL鏁版嵁搴撳悕绉般��

8.    鍦ㄢ�滅敤鎴封�濇�嗕腑锛岃緭鍏ヤ綘鐨凪ySQL鐢ㄦ埛鍚嶏紙鏁版嵁搴撶敤鎴稩D锛夈��

9.    鍦ㄢ�滃瘑鐮佲�濇�嗕腑杈撳叆瀵嗙爜銆�

10.鍦ㄢ�滅��鍙ｂ�濇�嗕腑锛屽�傛灉绔�鍙ｄ笉鏄�榛樿�ょ��鍙ｏ紝杈撳叆绔�鍙ｅ彿銆�

11.鍦ㄢ�淪QL鍛戒护鈥濇�嗕腑锛屽彲杈撳叆寤虹珛杩炴帴鍚庤嚜鍔ㄦ墽琛岀殑SQL璇�鍙ャ��

鏈�鍚庯紝瀵硅瘽妗嗕笌涓嬪浘鏄剧ず鐨勭被浼硷細

鐐瑰嚮鈥淥K鈥濇坊鍔犺�ユ暟鎹�婧愩��

娉ㄩ噴锛� 鐐瑰嚮鈥淥K鈥濆悗锛屽皢鎵撳紑鈥滄暟鎹�婧愨�濆�硅瘽妗嗭紝ODBC绠＄悊鍣ㄥ皢鏇存柊娉ㄥ唽淇℃伅銆傝繛鎺ュ埌璇ユ暟鎹�婧愭椂锛屼綘鎵�杈撳叆鐨勭敤鎴峰悕鍜岃繛鎺ュ瓧绗︿覆灏嗘垚涓鸿�ユ暟鎹�婧愮殑榛樿�よ繛鎺ュ�笺��

浣犱篃鍙�浠ヤ娇鐢ㄢ�滄祴璇曟暟鎹�婧愨�濇寜閽�锛屾祴璇曚綘鐨勮�剧疆鏄�鍚﹂�傚悎浜庤繛鎺ュ埌鏈嶅姟鍣ㄣ�傝�ョ壒鎬т粎瀵筂yODBC 3.51椹卞姩绋嬪簭鏈夋晥銆傛垚鍔熷畬鎴愭祴璇曞悗锛屽皢鏄剧ず涓嬭堪绐楀彛锛�

濡傛灉娴嬭瘯澶辫触锛屽皢鏄剧ず閿欒��娑堟伅銆�

DNS閰嶇疆瀵硅瘽妗嗕篃鏈変竴涓�鈥滈�夐」鈥濇寜閽�銆傚�傛灉閫夋嫨浜嗗畠锛屽皢鎵撳紑涓嬭堪閫夐」瀵硅瘽妗嗭紝鏄剧ず鎺у埗椹卞姩绋嬪簭鐨勮�屼负銆傚叧浜庤繖浜涢�夐」鐨勫惈涔夛紝璇峰弬瑙�26.1.9.4鑺傦紝鈥滆繛鎺ュ弬鏁扳��銆�

娉ㄩ噴锛� 鍦ㄢ�滈┍鍔ㄧ▼搴忚窡韪�鈥濋�夐」涓嬪垪鍑虹殑閫夐」宸茶��绂佹��锛堢伆鑹诧級锛岄櫎闈炰綘浣跨敤鐨勬槸椹卞姩DLL鐨勮皟璇曠増鏈�銆�

瑕佹兂鍦╓indows骞冲彴涓婃洿鏀规暟鎹�婧愶細

1.    鎵撳紑ODBC鏁版嵁婧愮�＄悊鍣ㄣ�傜偣鍑绘伆褰撶殑閫夐」鍗♀�淒SN鈥濄��

2.    閫夋嫨鎵撶畻鏇存敼鐨凪ySQL鏁版嵁婧愶紝鐒跺悗鐐瑰嚮鈥滈厤缃�鈥濄�傛墦寮�鈥�MySQL ODBC 3.51椹卞姩绋嬪簭-DSN閰嶇疆鈥�瀵硅瘽妗嗐��

3.    鏇存敼閫傜敤鐨勬暟鎹�婧愬瓧娈碉紝鐒跺悗鐐瑰嚮鈥淥K鈥濄��

鏇存敼瀹岃�ュ�硅瘽妗嗕腑鐨勪俊鎭�鍚庯紝ODBC绠＄悊鍣ㄥ皢鏇存柊娉ㄥ唽淇℃伅銆�

鍦�Unix骞冲彴涓婏紝鍙�浠ョ洿鎺ュ湪odbc.ini鏂囦欢涓�閰嶇疆DSN鏉＄洰銆�杩欓噷缁欏嚭浜�1涓�鍏稿瀷鐨�odbc.ini鏂囦欢锛屽湪璇ユ枃浠朵腑锛屽垎鍒�灏唌yodbc鍜宮yodbc3閰嶇疆涓�MyODBC 2.50鍜孧yODBC 3.51鐨凞SN鍚嶇О锛�

;

;  odbc.ini瀵筂yODBC鍜孧yODBC 3.51椹卞姩绋嬪簭鐨勯厤缃�

;

[ODBC Data Sources]
myodbc      = MyODBC 2.50 Driver DSN
myodbc3     = MyODBC 3.51 Driver DSN

[myodbc]
Driver       = /usr/local/lib/libmyodbc.so
Description  = MyODBC 2.50 Driver DSN
SERVER       = localhost
PORT         =
USER         = root
Password     =
Database     = test
OPTION       = 3
SOCKET       =

[myodbc3]
Driver       = /usr/local/lib/libmyodbc3.so
Description  = MyODBC 3.51 Driver DSN
SERVER       = localhost
PORT         =
USER         = root
Password     =
Database     = test
OPTION       = 3
SOCKET       =

[Default]
Driver       = /usr/local/lib/libmyodbc3.so
Description  = MyODBC 3.51 Driver DSN
SERVER       = localhost
PORT         =
USER         = root
Password     =
Database     = test
OPTION       = 3
SOCKET       =

鍏充簬鍙�鎻愪緵杩炴帴鍙傛暟鐨勬竻鍗曪紝璇峰弬瑙�26.1.9.4鑺傦紝鈥滆繛鎺ュ弬鏁扳��銆�

娉ㄩ噴锛� 濡傛灉浣犳�ｅ湪浣跨敤unixODBC锛屽彲浣跨敤涓嬭堪宸ュ叿璁剧疆DSN锛�

路         ODBCConfig GUI tool(HOWTO: ODBCConfig)

路         odbcinst

鍦ㄦ煇浜涙儏鍐典笅浣跨敤unixODBC锛屽彲鑳戒細鍑虹幇涓嬭堪閿欒��锛�

Data source name not found and no default driver specified锛堟暟鎹�婧愬悕涓嶅瓨鍦�锛屾湭鎸囧畾榛樿�ら┍鍔ㄧ▼搴忥級

濡傛灉鍑虹幇璇ユ儏鍐碉紝璇风‘璁�ODBCINI鍜�ODBCSYSINI鐜�澧冨彉閲忔寚鍚戞�ｇ‘鐨刼dbc.ini鏂囦欢銆備緥濡傦紝濡傛灉浣犵殑odbc.ini鏂囦欢浣嶄簬鐩�褰曗��/usr/local/etc鈥�涓嬶紝鍙�灏嗙幆澧冨彉閲忚�句负锛�

export ODBCINI=/usr/local/etc/odbc.ini

export ODBCSYSINI=/usr/local/etc

浣犲彲浠ュ湪ODBC.INI鏂囦欢鐨刐Data Source Name]锛堟暟鎹�婧愬悕锛夐儴鍒嗐�佹垨閫氳繃SQLDriverConnect() call鐨�InConnectionString鍙傞噺涓篗yODBC鎸囧畾涓嬭堪鍙傛暟銆�

閫夐」鍙傞噺鐢ㄤ簬閫氱煡MyODBC锛氬�㈡埛绔�涓嶆槸100% ODBC鍏煎�圭殑銆傚湪Windows骞冲彴涓嬶紝姝ｅ父鎯呭喌涓嬶紝搴旈�氳繃鍒囨崲杩炴帴灞忓箷涓婄殑澶嶉�夋�嗛�夋嫨閫夐」锛屼絾涔熻兘鍦ㄩ�夐」鍙傞噺涓�閫夋嫨瀹冧滑銆備笅杩伴�夐」鏄�鎸夌収瀹冧滑鍦∕yODBC杩炴帴灞忓箷涓婃樉绀虹殑椤哄簭鎺掑垪鐨勶細

瑕佹兂閫夋嫨澶氫釜閫夐」锛屽彲灏嗗畠浠�鐨勫�煎姞鍦ㄤ竴璧枫�備緥濡傦紝灏嗛�夐」璁剧疆涓�12锛�4锛�8锛夛紝灏辫兘鑾峰緱璋冭瘯鍔熻兘锛屼絾娌℃湁淇℃伅鍖呴檺鍒躲��

榛樿�ょ殑myodbc3.dll鏄�涓轰紭鍖栨�ц兘鑰岀紪璇戠殑銆�濡傛灉甯屾湜璋冭瘯MyODBC 3.51锛堜緥濡傦紝鍚�鐢ㄨ窡韪�鍔熻兘锛夛紝搴斾娇鐢�myodbc3d.dll銆傝�佹兂瀹夎�呰�ユ枃浠讹紝璇锋嫹璐�myodbc3d.dll锛屼娇涔嬭�嗙洊宸插畨瑁呯殑myodbc3.dll鏂囦欢銆�涓�鏃﹀畬鎴愪簡璋冭瘯鎿嶄綔锛屽姟蹇呮仮澶嶈嚦椹卞姩DLL鐨勫彂甯冪増鏈�锛岃繖鏄�鍥犱负璋冭瘯鐗堟湰鍙�鑳戒細瀵艰嚧鎬ц兘闂�棰樸�傛敞鎰忥紝鍦∕yODBC 3.51.07鑷�3.51.11涓�鏈�鍖呭惈myodbc3d.dll銆�濡傛灉浣犳�ｅ湪浣跨敤杩欎簺鐗堟湰涓�鐨勪竴涓�锛屽簲浠庝箣鍓嶇殑鐗堟湰锛堜緥濡�3.51.06锛夋嫹璐濊��DLL鏂囦欢銆�

瀵逛簬MyODBC 2.50锛岄噰鐢ㄤ簡myodbc.dll鍜宮yodbcd.dll鍙栬�屼唬涔嬨��

鍦ㄤ笅闈㈢殑琛ㄥ悇涓�锛岀粰鍑轰簡閽堝�瑰悇绉嶉厤缃�鐨勬帹鑽愰�夐」鍊硷細

鏄�銆傞�氳繃鎸囧畾DRIVER鍚嶇О瀛楁�碉紝鍙�浣跨敤SQLDriverConnect杩炴帴鍒癕ySQL鏈嶅姟鍣ㄣ�備笅闈㈢粰鍑轰簡浣跨敤DSN-Less杩炴帴鐨凪yODBC杩炴帴瀛楃�︿覆锛�

瀵逛簬MyODBC 2.50锛�

ConnectionString = "DRIVER={MySQL};\

                  SERVER=localhost;\

                  DATABASE=test;\

                  USER=venu;\

                  PASSWORD=venu;\

                  OPTION=3;"

瀵逛簬MyODBC 3.51锛�

ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};\

                  SERVER=localhost;\

                  DATABASE=test;\

                  USER=venu;\

                  PASSWORD=venu;\

                  OPTION=3;"

濡傛灉浣犱娇鐢ㄧ殑缂栫▼璇�瑷�浼氬皢鍚庤窡绌烘牸鐨勫弽鏂滄潬杞�鎹�涓虹┖鏍硷紝鏈�濂藉皢杩炴帴瀛楃�︿覆鎸囧畾涓哄崟涓�闀垮瓧绗︿覆锛屾垨浣跨敤涓嶄細鍦ㄥ叾涓�娣诲姞绌烘牸鐨勫�氫釜瀛楃�︿覆涓叉帴銆備緥濡傦細

ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};"

                  "SERVER=localhost;"

                  "DATABASE=test;"

                  "USER=venu;"

                  "PASSWORD=venu;"

                  "OPTION=3;"

鍏充簬鍙�鎻愪緵杩炴帴鍙傛暟鐨勬竻鍗曪紝璇峰弬瑙�26.1.9.4鑺傦紝鈥滆繛鎺ュ弬鏁扳��銆�

濡傛灉浣犳墦绠椾娇鐢�myuser鍜�mypassword浣滀负鐢ㄦ埛鍚嶅拰瀵嗙爜浠庣郴缁烞杩炴帴鍒扮郴缁烝锛屽彲鍙傝�冧笅闈㈢粰鍑虹殑绠�鍗曟�ラ�ゃ��

鍦ㄧ郴缁烝涓婏紝鎵ц�屼笅杩版�ラ�わ細

1.    鍚�鍔∕ySQL鏈嶅姟鍣ㄣ��

2.    浣跨敤GRANT寤虹珛鐢ㄦ埛鍚嶄负myuser鐨勮处鎴凤紝璇ヨ处鎴峰彲浣跨敤瀵嗙爜myuser浠庣郴缁烞寤虹珛杩炴帴銆�

3.             GRANT ALL ON *.* to 'myuser'@'B' IDENTIFIED BY 'mypassword';

4.    GRANT璇�鍙ヤ负鐢ㄦ埛myuser鎺堜簣浜嗕娇鐢ㄥ瘑鐮乵ypassword浠庣郴缁烞杩涜�岃繛鎺ョ殑鎵�鏈夋潈闄愩��瑕佹兂鎵ц�岃�ヨ��鍙ワ紝蹇呴』鍦ㄧ郴缁烝涓婃嫢鏈夋牴鐢ㄦ埛鏉冮檺锛屾垨鏄�鍏锋湁鎭板綋鏉冮檺鐨勫彟涓�鐢ㄦ埛銆傚叧浜嶮ySQL鏉冮檺鐨勬洿澶氫俊鎭�锛岃�峰弬瑙�5.8鑺傦紝鈥淢ySQL鐢ㄦ埛璐︽埛绠＄悊鈥�銆�

鍦ㄧ郴缁烞涓婏紝鎵ц�屼笅杩版�ラ�わ細

1.    浣跨敤涓嬭堪杩炴帴鍙傛暟閰嶇疆MyODBC DSN锛�

2.           DSN            = remote_test

3.           SERVER or HOST = A (or IP address of system A)

4.           DATABASE       = test (The default database or an appropriate one)

5.           USER           = myuser

6.           PASSWORD       = mypassword

鍏充簬寤虹珛DSN-less杩炴帴鐨勬洿澶氫俊鎭�锛岃�峰弬瑙�26.1.9.5鑺傦紝鈥滄病鏈夐�勫畾涔塂SN涓嬬殑杩炴帴鈥�銆�

7.    浣跨敤Ping鍛戒护鎴栧叾瀹冩柟寮忔��鏌ユ槸鍚﹁兘浠庣郴缁烞璁块棶绯荤粺A銆傚�傛灉鏃犳硶璁块棶绯荤粺A锛岃�锋��鏌ョ綉缁滄垨Internet杩炴帴锛屾垨涓庝綘鐨勭郴缁熺�＄悊鍛樿仈绯汇��

8.    灏濊瘯浣跨敤DSN=remote_test杩涜�岃繛鎺ャ�傚�傛灉澶辫触锛岃�疯窡韪�鏌ヨ��MyODBC鏃ュ織锛屽苟鏍规嵁鏃ュ織缁欏嚭鐨勯敊璇�淇℃伅閲囧彇杩涗竴姝ョ殑姝ラ�ゃ�傚�傛灉闇�瑕佽繘涓�姝ュ府鍔╋紝璇峰彂閫佽�︾粏鐨勭數瀛愰偖浠惰嚦myodbc@lists.mysql.com銆�

鍦ㄤ笅杩扮珯鐐癸紝浣犲彲浠ユ壘鍒板叧浜庡�備綍瀹屾垚璇ユ搷浣滅殑绠�鍗曠ず渚嬶細http://www.phphelp.com/tutorial/using-myodbc-to-connect-to-a-remote-database.html.

濡傛灉閬囧埌涓嶮yODBC鏈夊叧鐨勫洶闅炬垨闂�棰橈紝棣栧厛搴斾娇鐢�ODBC绠＄悊鍣ㄥ拰MyODBC鐢熸垚涓�浠芥棩蹇楁枃浠�锛堣�锋眰鏉ヨ嚜ODBC ADMIN鐨勬棩蹇楁椂鑾峰緱鐨勬棩蹇楁枃浠讹級銆�

瑕佹兂閫氳繃椹卞姩绠＄悊鍣ㄨ幏寰桹DBC璺熻釜鏂囦欢锛屽彲閲囧彇涓嬭堪姝ラ�わ細

路         鎵撳紑ODBC鏁版嵁婧愮�＄悊鍣�锛�

1.    鐐瑰嚮鈥滃紑濮嬧�濓紝灏嗘寚閽堟寚鍚戔�滆�剧疆鈥濓紝鐒跺悗鐐瑰嚮鈥滄帶鍒堕潰鏉库�濄��

2.    鍦ㄨ繍琛孧icrosoft Windows 2000銆乆P鎴�2003鐨勮�＄畻鏈轰笂锛屽弻鍑烩�滅�＄悊宸ュ叿鈥濓紝鐒跺悗鍙屽嚮鈥滄暟鎹�婧愨�濓紙ODBC锛夛紝濡備笅鍥炬墍绀恒��

鍦ㄨ繍琛屾棭鏈烳icrosoft Windows鐗堟湰鐨勮�＄畻鏈轰笂锛屽弻鍑烩�滄帶鍒堕潰鏉库�濅腑鐨�32浣�ODBC鎴朞DBC銆�

3.    鎵撳紑ODBC鏁版嵁婧愮�＄悊鍣ㄥ�硅瘽妗嗭紝濡備笅鍥炬墍绀猴細

4.    鐐瑰嚮鈥滃府鍔┾�濅互浜嗚ВODBC鏁版嵁婧愮�＄悊鍣ㄥ�硅瘽妗嗗悇閫夐」鍗＄殑璇︾粏淇℃伅銆�

路         鍚�鐢ㄨ窡韪�閫夐」 瀵逛簬Windows鍜孶nix骞冲彴锛岃�ユ�ラ�や笉鍚屻��

瑕佹兂鍦╓indows骞冲彴涓婂惎鐢ㄨ窡韪�閫夐」锛�

1.    閫氳繃鈥淥DBC鏁版嵁婧愮�＄悊鍣ㄢ�濆�硅瘽妗嗙殑鈥滆窡韪�鈥濋�夐」鍗★紝鍙�瀵硅窡韪狾DBC鍑芥暟鐨勬柟寮忚繘琛岄厤缃�銆�

2.    浠庘�滆窡韪�鈥濋�夐」鍗℃縺娲讳簡璺熻釜鍔熻兘鍚庯紝椹卞姩绠＄悊鍣ㄤ細瀵瑰悗缁�杩愯�岀殑鎵�鏈夊簲鐢ㄧ▼搴忕殑ODBC鍑芥暟璋冪敤杩涜�岃窡韪�銆�

3.    婵�娲昏窡韪�鍔熻兘鍓嶆墍杩愯�屽簲鐢ㄧ▼搴忕殑ODBC鍑芥暟璋冪敤涓嶄細琚�璁板綍銆侽DBC鍑芥暟璋冪敤灏嗚��璁板綍鍦ㄤ綘鎸囧畾鐨勬棩蹇楁枃浠朵腑銆�

4.    鐐瑰嚮鈥滅幇鍦ㄥ仠姝㈣窡韪�鈥濆悗锛岃窡韪�鍔熻兘灏嗗仠姝�銆傝�疯�颁綇锛屽惎鍔ㄨ窡韪�鍔熻兘鍚庯紝鏃ュ織鏂囦欢灏嗕笉鏂�澧炲ぇ锛岃�屼笖璺熻釜鍔熻兘浼氬奖鍝嶆墍鏈塐DBC搴旂敤绋嬪簭鐨勬�ц兘銆�

瑕佹兂鍦║nix骞冲彴涓婂惎鐢ㄨ窡韪�閫夐」锛�

5.    鍦║nix骞冲彴涓婏紝闇�瑕佸湪ODBC.INI鏂囦欢涓�鏄庣‘璁剧疆璺熻釜閫夐」銆�

浣跨敤TraceFile鍜宱dbc.ini涓�鐨凾race锛堣窡韪�锛夊弬鏁版墦寮�鎴栧叧闂�璺熻釜鍔熻兘锛屽�備笅鎵�绀猴細

TraceFile  = /tmp/odbc.trace

Trace      = 1

TraceFile鎸囨槑浜嗚窡韪�鏂囦欢鐨勫悕绉板拰瀹屾暣璺�寰勶紝灏�Trace锛堣窡韪�锛夎�句负ON鎴�OFF銆備篃鍙�浠ヤ娇鐢ㄢ��1鈥濇垨鈥淵es鈥濊〃绀篛N锛屼互鍙娾��0鈥濇垨鈥淣o鈥濊〃绀篛FF銆傚�傛灉姝ｅ湪浣跨敤unixODBC鐨�ODBCConfig锛岀劧鍚庨伒鐓�HOWTO-ODBCConfig涓�浠嬬粛鐨勫叧浜庤窡韪�unixODBC璋冪敤鐨勬寚绀鸿�存槑銆�

瑕佹兂鐢熸垚MyODBC鏃ュ織锛屽彲閲囧彇涓嬭堪姝ラ�わ細

6.    纭�淇濅綘鎵�浣跨敤鐨勬槸椹卞姩绋嬪簭璋冭瘯DLL锛堝�逛簬MyODBC 3.51锛屽畠鏄�myodbc3d.dll鑰屼笉鏄痬yodbc3.dll锛屽�逛簬MyODBC 2.50锛屽畠鏄�myodbcd.dll锛夈��

鏈�绠�鍗曠殑鏂规硶鏄�浠嶮yODBC 3.51鍒嗗彂鐗堟壘鍒�myodbc3d.dll锛堟垨myodbcd.dll锛夛紝骞剁敤鍏惰�嗙洊myodbc3.dll锛堟垨myodbc.dll锛夛紝璇ユ枃浠堕�氬父浣嶄簬C:\windows\system32鎴�C:\winnt\system32鐩�褰曚笅銆�娉ㄦ剰锛屽畬鎴愭祴璇曞悗锛屼綘鎴栬�稿笇鏈涙仮澶嶆棫鐨�myodbc.dll鏂囦欢锛岃繖鏄�鍥犱负瀹冩瘮myodbc3d.dll锛堟垨myodbcd.dll锛夊揩寰堝�氾紝鍥犳�わ紝璇蜂繚瀛樺師濮婦LL鐨勫�囦唤銆�

7.      鍦ㄢ�淢yODBC杩炴帴锛忛厤缃�鈥濆睆骞曚笂鍚�鐢ㄢ�滆窡韪�MyODBC鈥濋�夐」銆傛棩蹇楀皢琚�鍐欏叆鏂囦欢C:\myodbc.log銆傚綋浣犺繑鍥炰笂杩板睆骞曟椂锛屽�傛灉浣犺�剧疆鐨勮窡韪�閫夐」鏈�琚�璁颁綇锛岃〃鏄庝綘姝ｅ湪浣跨敤鐨勬槸myodbcd.dll椹卞姩锛堝弬瑙佸墠闈㈢殑浠嬬粛锛夈��鍦↙inux骞冲彴涓婏紝鎴栦綘浣跨敤鐨勬槸DSN-Less杩炴帴锛岄渶鍦ㄨ繛鎺ュ瓧绗︿覆涓�鎻愪緵鈥�OPTION=4鈥�銆�

8.    鍚�鍔ㄥ簲鐢ㄧ▼搴忥紝骞跺皾璇曠潃浣垮叾鍑虹幇闂�棰樸�傜劧鍚庢��鏌�MyODBC璺熻釜鏂囦欢锛屾壘鍑哄彲鑳藉嚭閿欑殑鍦版柟銆�

濡傛灉鍙戠幇鏌愪簺浜嬮」鍑洪敊锛岃�峰彂閫佺數瀛愰偖浠惰嚦myodbc@lists.mysql.com锛堟垨support@mysql.com锛屽�傛灉鏈変笌MySQL AB绛捐�㈢殑鏀�鎸佸悎鍚岋級锛岀畝瑕佹弿杩板嚭鐜扮殑闂�棰橈紝骞舵彁渚涗笅杩伴�濆�栦俊鎭�锛�

o        MyODBC鐗堟湰

o        ODBC椹卞姩绠＄悊鍣ㄧ殑绫诲瀷鍜岀増鏈�

o        MySQL鏈嶅姟鍣ㄧ殑鐗堟湰

o        椹卞姩绠＄悊鍣ㄧ殑ODBC璺熻釜

o        鏉ヨ嚜MyODBC椹卞姩鐨凪yODBC鏃ュ織鏂囦欢

o        绠�鍗曠殑鍙�澶嶅埗绀轰緥

璇疯�颁綇锛屼綘鎻愪緵缁欐垜浠�鐨勪俊鎭�瓒婂�氾紝鎴戜滑鏇存�ｉ棶棰樼殑鏈轰細灏辫秺澶с��

姝ゅ�栵紝鍦ㄦ彁渚涚己闄蜂俊鎭�鍓嶏紝璇锋��鏌�MyODBC閭�浠跺垪琛�锛�http://lists.mysql.com/锛夈��

浣跨敤涓嬭堪搴旂敤绋嬪簭娴嬭瘯浜哅yODBC锛�

濡傛灉浣犵煡閬撹兘澶熶笌MyODBC涓�璧峰伐浣滅殑鍏朵粬搴旂敤绋嬪簭锛岃�蜂互鐢靛瓙閭�浠剁殑鏂瑰紡鎸囨槑瀹冿細myodbc@lists.mysql.com銆�

澶у�氭暟绋嬪簭鍧囪兘涓嶮yODBC涓�璧峰伐浣滐紝瀵逛笂闈㈡墍鍒楃殑姣忎竴绋嬪簭锛屾垜浠�鑷�宸辫繘琛屼簡娴嬭瘯锛屾垨寰楀埌鐢ㄦ埛鐨勭‘璁ゃ�傚緢澶氫粙缁嶄腑鍧囩粰鍑轰簡浣犲彲鑳戒細閬囧埌闂�棰樼殑鎻忚堪銆�

路         绋嬪簭

娉ㄩ噴

路         Access

瑕佹兂浣緼ccess宸ヤ綔锛�

o        濡傛灉浣犳�ｅ湪浣跨敤Access 2000锛屽簲浠庝笅杩板湴鍧�鑾峰彇骞跺畨瑁呮渶鏂扮殑锛�2.6鐗堟垨鏇撮珮锛塎icrosoft MDAC锛�Microsoft鏁版嵁璁块棶缁勪欢锛夛紝http://www.microsoft.com/data/銆傚畠鏇存�ｄ簡Access鍦ㄥ皢鏁版嵁瀵煎嚭鑷矼ySQL鏃跺瓨鍦ㄧ殑涓�涓�缂洪櫡锛屾湭鎸囧畾琛ㄥ悕鍜屽垪鍚嶃�傚彟涓�绉嶈В鍐宠�ョ己闄风殑鏂规硶鏄�锛屽崌绾у埌MyODBC 2.50.33鍜孧ySQL 3.23.x, 瀹冧滑鍏卞悓鎻愪緵浜嗛伩鍏嶈�ラ棶棰樼殑涓�绉嶆柟寮忋��

姝ゅ�栵紝浣犺繕搴旇幏鍙栧苟搴旂敤Microsoft Jet 4.0 Service Pack 5 (SP5)锛屽彲鍦ㄤ笅杩板湴鍧�鎵惧埌瀹冿細http://support.microsoft.com/default.aspx?scid=kb;EN-US;q239114銆傚畠淇�姝ｄ簡鏌愪簺鎯呭喌涓嬪湪Access涓�鍒楄��鏍囨敞涓衡��#DELETED#鈥�鐨勯棶棰樸��

娉ㄩ噴锛� 濡傛灉浣犳�ｄ娇鐢∕ySQL 3.22锛屽繀椤诲畨瑁匨DAC琛ヤ竵锛屽苟浣跨敤MyODBC 2.50.32鎴�2.50.34鎴栨洿楂樼増鏈�浠ヨВ鍐宠�ラ棶棰樸��

o        瀵逛簬鎵�鏈夌増鏈�鐨凙ccess锛屽簲鍚�鐢ㄢ�淢yODBC杩斿洖鍖归厤琛屸�濋�夐」銆傚�逛簬Access 2.0锛岃繕搴旈�濆�栧惎鐢ㄢ��妯℃嫙ODBC 1.0鈥�閫夐」銆�

o        鍦ㄥ笇鏈涜兘澶熸洿鏂扮殑鎵�鏈夎〃涓�锛屽潎搴旀湁鏃堕棿鎴炽�備负浜嗚幏寰楁渶澶х殑鍙�绉绘�嶆�э紝鍦ㄥ垪澹版槑涓�涓嶈�佷娇鐢ㄩ暱搴﹁�勮寖銆備篃灏辨槸璇达紝搴斾娇鐢�TIMESTAMP锛岃�屼笉鏄疶IMESTAMP(n), n < 14銆�

o        鍦ㄨ〃涓�搴旀湁1涓�涓婚敭銆傚�備笉鐒讹紝鏂扮殑鎴栨洿鏂扮殑琛屽彲鑳戒細鏄剧ず涓衡��#DELETED#鈥濄��

o        浠呭簲浣跨敤DOUBLE娴�鐐瑰瓧娈点��涓庡崟绮惧害娴�鐐硅繘琛屾瘮杈冩椂锛孉ccess灏嗗け璐ャ�傚叾寰佸厗鏄�鏂扮殑鎴栨洿鏂扮殑琛屽彲鑳戒細鏄剧ず涓衡��#DELETED#鈥濓紝鎴栨棤娉曟壘鍒版垨鏇存柊琛屻��

o        濡傛灉浣犳�ｄ娇鐢∕yODBC鏉ラ摼鎺ュ埌鏈塀IGINT鍒楃殑琛�锛岀粨鏋滀細鏄剧ず涓衡��#DELETED鈥濄�傛帓闄ゅ畠鐨勮В鍐虫柟妗堟槸锛�

搂         鏈�1涓�浠�TIMESTAMP浣滀负鏁版嵁绫诲瀷鐨勮櫄鎷熷垪銆�

搂         鍦ㄢ�淥DBC DSN绠＄悊鍣ㄢ�濈殑杩炴帴瀵硅瘽妗嗕腑閫夋嫨鈥滃皢BIGINT鍒楁洿鏀逛负INT鈥濋�夐」銆�

搂         鍒犻櫎涓嶢ccess鐨勮〃閾炬帴锛屽苟閲嶆柊鍒涘缓瀹冦��

鏃ц�板綍浠嶅皢鏄剧ず涓衡��#DELETED#鈥濓紝浣嗘柊澧烇紡鏇存柊鐨勮�板綍浼氭伆褰撴樉绀恒��

o        娣诲姞浜員IMESTAMP鍒楀悗锛屽彟涓�浣嶇敤鎴锋洿鏀逛簡鏁版嵁锛屽�傛灉閿欒��渚濇棫鍑虹幇锛屼笅杩版妧宸ф垨璁告湁鎵�甯�鍔╋細

涓嶈�佷娇鐢ㄨ〃鏁版嵁琛ㄨ�嗗浘銆傚彇鑰屼唬涔嬬殑鏄�锛屼粠浣犲笇鏈涗娇鐢ㄧ殑琛ㄥ垱寤轰竴涓�琛ㄥ崟锛屽苟浣跨敤琛ㄥ崟鏁版嵁琛ㄨ�嗗浘銆傚簲灏�TIMESTAM鍒楃殑DefaultValue灞炴�ц�剧疆涓篘OW()銆傚湪瑙嗗浘涓�闅愯棌TIMESTAMP鍒楁垨璁告槸涓�濂戒富鎰忥紝杩欐牱灏变笉浼氫娇浣犵殑鐢ㄦ埛鎰熷埌杩锋儜銆�

o        鍦ㄦ煇浜涙儏鍐典笅锛孉ccess鍙�鑳戒細鐢熸垚MySQL鏃犳硶鐞嗚В鐨凷QL璇�鍙ャ�傚彲閫氳繃鍦ˋccess鑿滃崟涓�閫夋嫨鈥�Query|SQLSpecific|Pass-Through鈥濇潵鏇存�ｈ�ラ棶棰樸��

o        鍦∟T骞冲彴涓婏紝Access浼氬皢BLOB鍒楅�氭姤涓�OLE OBJECTS锛圤LE瀵硅薄锛夈��濡傛灉浣犳墦绠楃敤MEMO鍒楀彇鑰屼唬涔嬶紝搴斾娇鐢ˋLTER TABLE灏咮LOB鍒楁洿鏀逛负TEXT銆�

o        Access鏃犳硶鍦ㄤ换浣曟椂鍊欏潎鎭板綋澶勭悊DATE鍒椼��濡傛灉閬囧埌杩欑被闂�棰橈紝璇峰皢鍒楁洿鏀逛负DATETIME銆�

o        濡傛灉鍦ˋccess涓�瀛樺湪瀹氫箟涓�BYTE鐨勫垪锛�Access浼氳�嗗浘灏嗗叾瀵煎嚭涓�TINYINT鑰屼笉鏄疶INYINT UNSIGNED銆傚�傛灉鍒椾腑鐨勫�煎ぇ浜�127锛屽皢鍑虹幇闂�棰樸��

路         ADO

浣跨敤ADO API鍜孧yODBC杩涜�岀紪鐮佹椂锛岄渶瑕佹敞鎰忔煇浜涗笉琚玀ySQL鏈嶅姟鍣ㄦ敮鎸佺殑榛樿�ゅ睘鎬с�備緥濡傦紝瀵逛簬RecordCount灞炴�э紝濡傛灉灏咰ursorLocation灞炴�х敤浣渁dUseServer锛屽皢杩斿洖缁撴灉鈥�-1鈥�銆�瑕佹兂鑾峰緱姝ｇ‘鐨勫�硷紝闇�瑕佸皢璇ュ睘鎬ц�剧疆涓�adUseClient锛屽�備笅闈㈢粰鍑虹殑VB浠ｇ爜绀轰緥鎵�绀猴細

Dim myconn As New ADODB.Connection

Dim myrs As New Recordset

Dim mySQL As String

Dim myrows As Long

myconn.Open "DSN=MyODBCsample"

mySQL = "SELECT * from user"

myrs.Source = mySQL

Set myrs.ActiveConnection = myconn

myrs.CursorLocation = adUseClient

myrs.Open

myrows = myrs.RecordCount

myrs.Close

myconn.Close

鍙︿竴绉嶅�勭悊鏂瑰紡鏄�锛屽�圭被浼兼煡璇�浣跨敤SELECT COUNT(*)璇�鍙ヤ互鑾峰彇姝ｇ‘鐨勮�岃�℃暟銆�

路         涓诲姩鏈嶅姟鍣ㄩ〉锛圓SP锛�

搴旈�夋嫨鈥滆繑鍥炲尮閰嶈�屸�濋�夐」銆�

路         BDE搴旂敤绋嬪簭

瑕佹兂浣胯繖绫诲簲鐢ㄧ▼搴忓伐浣滐紝搴旈�夋嫨鈥滀笉浼樺寲鍒楀�藉害骞惰繑鍥炲尮閰嶈�屸�濋�夐」銆�

路         Borland Builder 4

寮�濮嬫煡璇㈡椂锛屽彲浣跨敤Active灞炴�ф垨Open鏂规硶銆�娉ㄦ剰锛�Active灏嗛�氳繃鑷�鍔ㄥ彂鍑�鈥�SELECT * FROM ...鈥�鏌ヨ�㈠紑濮嬨��濡傛灉琛ㄥ緢澶э紝杩欎笉鏄�浠�涔堝ソ浜嬨��

路         ColdFusion锛堝湪Unix骞冲彴涓婏級

涓嬭堪淇℃伅鍙栬嚜ColdFusion鏂囨。锛�

浣跨敤涓嬭堪淇℃伅鏉ラ厤缃�鐢ㄤ簬Linux鐨凜oldFusion鏈嶅姟鍣�锛屼互渚夸娇鐢ㄩ拡瀵筂ySQL鏁版嵁婧愮殑unixODBC椹卞姩鍜孧yODBC銆侫llaire宸茶瘉鏄庯紝MyODBC 2.50.26鑳藉�熶笌MySQL 3.22.27浠ュ強鐢ㄤ簬Linux鐨凜oldFusion涓�璧峰伐浣溿�傦紙浠讳綍杈冩柊鐨勭増鏈�涔熷簲鑳芥�ｇ‘宸ヤ綔锛夈�備綘鍙�浠ュ湪缃戠珯http://dev.mysql.com/downloads/connector/odbc/涓婁笅杞組yODBC銆�

閫氳繃ColdFusion 4.5.1鐗堬紝鍙�浠ヤ娇鐢ㄢ�淐oldFusion绠＄悊鍣ㄢ�濇潵娣诲姞MySQL鏁版嵁婧愩�備絾鏄�锛岄┍鍔ㄧ▼搴忔湭鍖呭惈鍦–oldFusion 4.5.1鐗堜腑銆傚湪MySQL椹卞姩绋嬪簭鍑虹幇鍦∣DBC鏁版嵁婧愪笅鎷夊垪琛ㄤ箣鍓嶏紝蹇呴』鍒涘缓MyODBC椹卞姩绋嬪簭锛屽苟灏嗗叾鎷疯礉鍒�/opt/coldfusion/lib/libmyodbc.so銆�

鍦–ontrib鐩�褰曚笅鍖呭惈绋嬪簭mydsn-xxx.zip锛屼娇鐢ㄥ畠锛屽�逛簬Coldfusion搴旂敤绋嬪簭锛屽彲鍒涘缓骞跺垹闄ょ敤浜嶮yODBC椹卞姩鐨凞SN娉ㄥ唽鏂囦欢銆�

路         DataJunction

搴斿�瑰叾杩涜�屾洿鏀癸紝浣夸箣杈撳嚭VARCHAR鑰屼笉鏄疎NUM锛屽洜涓哄叾瀵煎嚭ENUM鐨勬柟寮忎細閫犳垚MySQL闂�棰樸��

路         Excel

宸ヤ綔銆備竴浜涙彁绀猴細

o        濡傛灉閬囧埌鏃ユ湡鏂归潰鐨勯棶棰橈紝璇蜂娇鐢�CONCAT()鍑芥暟锛屽皢鍏堕�夋嫨涓哄瓧绗︿覆銆�渚嬪�傦細

o                     SELECT CONCAT(rise_time), CONCAT(set_time)

o                       FROM sunrise_sunset;

閲囩敤璇ユ柟寮忎互瀛楃�︿覆鎻愬彇鐨勫�煎簲鑳借�獷xcel97姝ｇ‘璇嗗埆涓烘椂闂村�笺��

鍦ㄦ湰渚嬩腑锛�CONCAT()鐨勭洰鐨勬槸璁㎡DBC璁や负鍒楁槸鈥�瀛楃�︿覆绫诲瀷鈥�銆�濡傛灉娌℃湁CONCAT()锛孫DBC浼氬皢鍒楄�嗕负鏃堕棿绫诲瀷锛孍xcel鏃犳硶鐞嗚В瀹冦��

娉ㄦ剰锛孍xcel瀛樺湪1涓�缂洪櫡锛岃繖鏄�鍥犱负瀹冧細鑷�鍔ㄥ皢瀛楃�︿覆杞�鎹�涓烘椂闂淬�傚�傛灉婧愭槸鏂囨湰鏂囦欢锛屼笉瀛樺湪闂�棰橈紝浣嗗綋婧愭槸閫氭姤鍚勫垪鍑嗙‘绫诲瀷鐨凮DBC杩炴帴鏃讹紝灏嗗嚭鐜伴棶棰樸��

路         Word

瑕佹兂灏嗘暟鎹�浠嶮ySQL鎻愬彇鍒癢ord/Excel鏂囨。锛岄渶瑕佷娇鐢∕yODBC椹卞姩绋嬪簭浠ュ強鈥淢icrosoft鏌ヨ�㈠府鍔┾�濇彃浠躲��

渚嬪�傦紝鐢ㄥ惈鏈変袱鍒楁枃鏈�鐨勮〃鍒涘缓1涓�鏁版嵁搴擄細

o        浣跨敤mysql瀹㈡埛绔�鍛戒护琛屽伐鍏锋彃鍏ヨ�屻��

o        浣跨敤ODBC绠＄悊鍣ㄥ垱寤�1涓狣SN鏂囦欢锛屼緥濡傦紝閽堝�瑰垰鍒涘缓鏁版嵁搴撶殑鈥渕y鈥濄��

o        鎵撳紑Word搴旂敤绋嬪簭銆�

o        鍒涘缓1涓�鏂扮殑绌虹櫧鏂囨。銆�

o        鍦ㄦ暟鎹�搴撳伐鍏锋爮涓婏紝鎸夆�滄彃鍏ユ暟鎹�搴撯�濇寜閽�銆�

o        鎸夆�滆幏鍙栨暟鎹�鈥濇寜閽�銆�

o        鍦ㄢ�滆幏鍙栨暟鎹�鈥濆睆骞曞彸渚э紝鎸夆��Ms Query鈥濇寜閽�銆�

o        鍦ㄢ��Ms Query鈥濅腑浣跨敤鈥�my DSN鈥濇枃浠跺垱寤�1涓�鏂版暟鎹�婧愩��

o        閫夋嫨鏂版煡璇�銆�

o        閫夋嫨鎵撶畻浣跨敤鐨勫垪銆�

o        濡傛灉鎰挎剰锛屽垱寤�1涓�杩囨护鍣ㄣ��

o        濡傛灉鎰挎剰锛屽垱寤�1涓�鍒嗙被銆�

o        閫夋嫨鈥滃皢鏁版嵁杩斿洖鍒�Microsoft Word鈥濄��

o        鐐瑰嚮鈥滃畬鎴愨�濄��

o        鐐瑰嚮鈥滄彃鍏ユ暟鎹�鈥濆苟閫夋嫨璁板綍銆�

o        鐐瑰嚮OK锛屽湪浣犵殑Word鏂囨。涓�灏嗙湅鍒版彃鍏ョ殑琛屻��

路         odbcadmin

ODBC鐨勬祴璇曠▼搴忋��

路         Delphi

蹇呴』浣跨敤BDE 3.2鐗堟垨鏇存柊鐨勭増鏈�銆傝繛鎺ュ埌MySQL鏃讹紝閫夋嫨鈥滀笉浼樺寲鍒楀�藉害鈥濋�夐」銆�

姝ゅ�栵紝杩欓噷缁欏嚭浜嗕竴浜涘彲鑳芥湁鐢ㄧ殑Delphi浠ｇ爜锛岃繖浜涗唬鐮佸彲璁剧疆涓篗yODBC璁剧疆ODBC鏉＄洰鍜孊DE鏉＄洰銆侭DE鏉＄洰瑕佹眰鐢ㄥ埌鈥淏DE鍒�鍚嶇紪杈戝櫒鈥濓紝瀹冧綅浜庨潬杩戜綘鐨勨�淒elphi Super Page鈥濅笂锛屽彲鑷�鐢辨嫋鍔ㄣ�傦紙涓嬭堪鍐呭�圭敱Bryan Brunton <bryan@flesherfab.com>鎻愪緵锛夛細

fReg:= TRegistry.Create;

fReg.OpenKey('\Software\ODBC\ODBC.INI\DocumentsFab', True);

fReg.WriteString('Database', 'Documents');

fReg.WriteString('Description', ' ');

fReg.WriteString('Driver', 'C:\WINNT\System32\myodbc.dll');

fReg.WriteString('Flag', '1');

fReg.WriteString('Password', '');

fReg.WriteString('Port', ' ');

fReg.WriteString('Server', 'xmark');

fReg.WriteString('User', 'winuser');

fReg.OpenKey('\Software\ODBC\ODBC.INI\ODBC Data Sources', True);

fReg.WriteString('DocumentsFab', 'MySQL');

fReg.CloseKey;

fReg.Free;

Memo1.Lines.Add('DATABASE NAME=');

Memo1.Lines.Add('USER NAME=');

Memo1.Lines.Add('ODBC DSN=DocumentsFab');

Memo1.Lines.Add('OPEN MODE=READ/WRITE');

Memo1.Lines.Add('BATCH COUNT=200');

Memo1.Lines.Add('LANGDRIVER=');

Memo1.Lines.Add('MAX ROWS=-1');

Memo1.Lines.Add('SCHEMA CACHE DIR=');

Memo1.Lines.Add('SCHEMA CACHE SIZE=8');

Memo1.Lines.Add('SCHEMA CACHE TIME=-1');

Memo1.Lines.Add('SQLPASSTHRU MODE=SHARED AUTOCOMMIT');

Memo1.Lines.Add('SQLQRYMODE=');

Memo1.Lines.Add('ENABLE SCHEMA CACHE=FALSE');

Memo1.Lines.Add('ENABLE BCD=FALSE');

Memo1.Lines.Add('ROWSET SIZE=20');

Memo1.Lines.Add('BLOBS TO CACHE=64');

Memo1.Lines.Add('BLOB SIZE=32');

AliasEditor.Add('DocumentsFab','MySQL',Memo1.Lines);

路         C++ Builder

鐢˙DE 3.0鐗堣繘琛屼簡娴嬭瘯銆傜洰鍓嶅凡鐭ョ殑鍞�涓�闂�棰樻槸锛屾洿鏀硅〃鏂规�堟椂锛屾煡璇㈠瓧娈典笉鏇存柊銆傜劧鑰岋紝BDE鐪嬩笂鍘讳笉浼氳瘑鍒�涓婚敭锛屽畠浠呮槸鍚嶄负PRIMARY鐨勭储寮曪紝灏界�¤繖璋堜笉涓婃槸闂�棰樸��

路         Vision

搴旈�夋嫨鈥滆繑鍥炲尮閰嶈�屸�濋�夐」銆�

路         Visual Basic

瑕佹兂鏇存柊琛�锛屽繀椤讳负琛ㄥ畾涔変富閿�銆�

甯︽湁ADO鐨刅isual Basic涓嶈兘澶勭悊澶ф暣鏁般�傝繖鎰忓懗鐫�鏌愪簺鏌ヨ��锛堝��SHOW PROCESSLIST绛夛級涓嶄細姝ｇ‘宸ヤ綔銆�鏇存�ｆ柟娉曟槸锛屽湪ODBC杩炴帴瀛楃�︿覆涓�浣跨敤OPTION=16384锛屾垨鍦�MyODBC杩炴帴灞忓箷涓婇�夋嫨鈥滃皢BIGINT鍒楁洿鏀逛负INT鈥濋�夐」銆傛垨璁革紝浣犱篃甯屾湜閫夋嫨鈥滆繑鍥炲尮閰嶈�屸�濋�夐」銆�

路         VisualInterDev

濡傛灉鍦ㄧ粨鏋滀腑鏈�BIGINT锛屽彲鑳戒細鍑虹幇閿欒��鈥�[Microsoft][ODBC Driver Manager]椹卞姩绋嬪簭涓嶆敮鎸佽�ュ弬鏁�鈥�銆傝��鍦�MyODBC杩炴帴灞忓箷涓婇�夋嫨鈥滃皢BIGINT鍒楁洿鏀逛负INT鈥濋�夐」銆�

路         Visual Objects

搴旈�夋嫨鈥滀笉浼樺寲鍒楀�藉害鈥濋�夐」銆�

路         MS Visio Enterprise 2000

閫氳繃MyODBC锛�2.50.37鎴栨洿楂樼増鏈�锛夛紝閫氳繃杩炴帴MS Vision Enterprise 2000鍜孧ySQL锛屽苟浣跨敤Visio鐨勯�嗗悜宸ョ▼甯堝姛鑳斤紝鎴戜滑寤虹珛浜嗘暟鎹�搴撴ā鍨嬶紝浣跨敤瀹冩潵妫�绱㈠叧浜嶥B鐨勪俊鎭�锛圴isio鏄剧ず浜嗘墍鏈夌殑鍒楀畾涔夈�佷富閿�銆佺储寮曠瓑锛夈�傛�ゅ�栵紝鎴戜滑杩橀�氳繃鎸囧畾Visio涓�鐨勬柊琛ㄨ繘琛屼簡娴嬭瘯锛屽苟閫氳繃MyODBC灏嗗叾瀵煎嚭鑷矼ySQL銆�

璇峰弬瑙�5.7.8鑺傦紝鈥滄嫆缁濊�块棶閿欒��鐨勫師鍥�鈥�銆�

瑕佹兂浣縈icrosoft Access鑳藉�熶笌MyODBC涓�璧峰伐浣滐紝鍦ㄤ綘鐨勫�㈡埛绔疨C涓婂繀椤诲畬鎴愪笅杩版搷浣溿��

1.    濡傛灉浣犳�ｅ湪浣跨敤Access 2000锛屽簲浠庝笅杩板湴鍧�鑾峰彇骞跺畨瑁呮渶鏂扮殑锛�2.6鐗堟垨鏇撮珮锛塎icrosoft MDAC锛�Microsoft鏁版嵁璁块棶缁勪欢锛夛紝http://www.microsoft.com/data/銆傚畠鏇存�ｄ簡Access鍦ㄥ皢鏁版嵁瀵煎嚭鑷矼ySQL鏃跺瓨鍦ㄧ殑涓�涓�缂洪櫡锛屾湭鎸囧畾琛ㄥ悕鍜屽垪鍚嶃�傚彟涓�绉嶈В鍐宠�ョ己闄风殑鏂规硶鏄�锛屽崌绾у埌MyODBC 2.50.33鍜孧ySQL 3.23.x, 瀹冧滑鍏卞悓鎻愪緵浜嗛伩鍏嶈�ラ棶棰樼殑涓�绉嶆柟寮忋��

姝ゅ�栵紝浣犺繕搴旇幏鍙栧苟搴旂敤Microsoft Jet 4.0 Service Pack 5 (SP5)锛屽彲鍦ㄤ笅杩板湴鍧�鎵惧埌瀹冿細http://support.microsoft.com/default.aspx?scid=kb;EN-US;q239114銆傚畠淇�姝ｄ簡鏌愪簺鎯呭喌涓嬪湪Access涓�鍒楄��鏍囨敞涓衡��#DELETED#鈥�鐨勯棶棰樸��

娉ㄩ噴锛� 濡傛灉浣犳�ｄ娇鐢∕ySQL 3.22锛屽繀椤诲畨瑁匨DAC琛ヤ竵锛屽苟浣跨敤MyODBC 2.50.32鎴�2.50.34鎴栨洿楂樼増鏈�浠ヨВ鍐宠�ラ棶棰樸��

2.    瀹夎�呮渶鏂扮増MySQL锛�http://dev.mysql.com/downloads/銆�

3.    瀹夎�呮渶鏂扮増MyODBC 3.51鎴�2.50锛�http://dev.mysql.com/downloads/connector/odbc/銆�

4.    瀵逛簬鎵�鏈夌増鏈�鐨凙ccess锛屽簲鍚�鐢ㄢ�淢yODBC杩斿洖鍖归厤琛屸�濋�夐」銆�

5.    閫氳繃MyODBC锛屽皢Access鐢ㄤ綔MySQL鏈嶅姟鍣ㄧ殑鍓嶇��绋嬪簭銆�

闄ら潪宸插畨瑁呬簡MyODBC锛屽惁鍒欎笉鑳藉皢琛ㄦ垨鏌ヨ�㈠�煎嚭鍒癕ySQL銆�

瑕佹兂灏嗚〃浠嶢ccess瀵煎叆MySQL锛岃�烽伒寰�涓嬭堪璇存槑锛�

1.    鎵撳紑Access鏁版嵁搴撴垨Access椤圭洰鏃讹紝鍑虹幇鈥滄暟鎹�搴撯�濈獥鍙ｃ�傚叾涓�鏄剧ず浜嗙敤浜庡垱寤烘柊鏁版嵁搴撳�硅薄鍜屾墦寮�宸叉湁瀵硅薄鐨勫揩鎹锋柟寮忋��

2.    鐐瑰嚮鎵撶畻瀵煎嚭鐨勮〃鍚嶆垨鏌ヨ�㈠悕锛岀劧鍚庡湪鈥滄枃浠垛�濊彍鍗曚腑閫夋嫨鈥滃�煎嚭鈥濄��

3.    鍦ㄢ�滃�煎嚭瀵硅薄绫诲瀷瀵硅薄鍚�鑷�鈥濆�硅瘽妗嗕腑锛屽湪鈥滃彟瀛樹负绫诲瀷鈥濇�嗕腑锛岄�夋嫨鈥�ODBC鏁版嵁搴�()鈥�锛屽�備笅鍥炬墍绀�锛�

4.    鍦ㄢ�滃�煎嚭鈥濆�硅瘽妗嗕腑锛岃緭鍏ユ枃浠跺悕锛堟垨浣跨敤寤鸿��鐨勬枃浠跺悕锛夛紝鐒跺悗閫夋嫨OK銆�

5.    鏄剧ず鈥滈�夋嫨鏁版嵁婧愨�濆�硅瘽妗嗭紝鍏朵腑鍒楀嚭浜嗕负璁＄畻鏈轰笂宸插畨瑁呯殑鍚凮DBC椹卞姩瀹氫箟鐨勬暟鎹�婧愩�傜偣鍑烩�滄枃浠舵暟鎹�婧愨�濇垨鈥滄満鍣ㄦ暟鎹�婧愨�濋�夐」鍗★紝鐒跺悗鍙屽嚮鎵撶畻瀵煎嚭鑷崇殑MyODBC鎴朚yODBC 3.51鏁版嵁婧愩�傚叧浜庝负MyODBC瀹氫箟鏂版暟鎹�婧愮殑鏂规硶锛岃�峰弬瑙�26.1.9.2鑺傦紝鈥滃湪Windows涓婇厤缃甅yODBC DSN鈥�銆�

Microsoft Access閫氳繃璇ユ暟鎹�婧愯繛鎺ヨ嚦MySQL鏈嶅姟鍣�锛屽苟瀵煎嚭鏂扮殑琛ㄥ拰锛忔垨鏁版嵁銆�

闄ら潪宸插畨瑁呬簡MyODBC锛屽惁鍒欎笉鑳藉皢琛ㄦ垨鏌ヨ�㈠�煎嚭鍒癕ySQL鏁版嵁搴撱��

瑕佹兂灏嗚〃浠嶮ySQL瀵煎叆鎴栭摼鎺ュ埌Access锛岃�烽噰鍙栦笅杩版�ラ�わ細

1.    鎵撳紑鏁版嵁搴擄紝鎴栧垏鎹㈠埌鈥滄暟鎹�搴撯�濈獥鍙ｄ互鎵撳紑鏁版嵁搴撱��

2.    瑕佹兂瀵煎叆琛�锛屽湪鈥滄枃浠垛�濊彍鍗曚笂锛屽皢榧犳爣鎸囬拡鎸囧悜鈥滆幏鍙栧�栭儴鏁版嵁鈥濓紝鐒跺悗鐐瑰嚮鈥滃�煎叆鈥濄�傝�佹兂閾炬帴琛�锛屽湪鈥滄枃浠垛�濊彍鍗曚笂锛屽皢榧犳爣鎸囬拡鎸囧悜鈥滆幏鍙栧�栭儴鏁版嵁鈥濓紝鐒跺悗鐐瑰嚮鈥滈摼鎺ヨ〃鈥濄��

3.    鍦ㄢ�滃�煎叆鈥濓紙鎴栤�滈摼鎺モ�濓級瀵硅瘽妗嗕腑锛屽湪鈥滄枃浠剁被鍨嬧�濇�嗕腑閫夋嫨鈥�ODBC Databases ()鈥濄�傚湪鈥滈�夋嫨鏁版嵁婧愨�濆�硅瘽妗嗕腑锛屽垪鍑轰簡瀹氫箟鐨勬暟鎹�婧愩�傛樉绀衡�滈�夋嫨鏁版嵁婧愨�濆�硅瘽妗嗭紝鍏朵腑鍒楀嚭浜嗕负瀹夎�呭湪璁＄畻鏈轰笂鐨勪换浣昈DBC椹卞姩瀹氫箟鐨勬暟鎹�婧愩�傜偣鍑烩�滄枃浠舵暟鎹�婧愨�濇垨鈥滄満鍣ㄦ暟鎹�婧愨�濋�夐」鍗★紝鐒跺悗鍙屽嚮鎵撶畻瀵煎嚭鑷崇殑MyODBC鎴朚yODBC 3.51鏁版嵁婧愩�傚叧浜庝负MyODBC鎴朚yODBC 3.51椹卞姩瀹氫箟鏂版暟鎹�婧愮殑鏂规硶锛岃�峰弬瑙�26.1.9.2鑺傦紝鈥滃湪Windows涓婇厤缃甅yODBC DSN鈥�銆�

4.    濡傛灉鎵�閫夌殑鏁版嵁婧愯�佹眰鐧诲綍锛岃�疯緭鍏ョ櫥褰旾D鍜屽瘑鐮侊紙鍙�鑳借繕闇�瑕侀�濆�栦俊鎭�锛夛紝鐒跺悗鐐瑰嚮OK銆�

5.    Microsoft Access閫氳繃ODBC鏁版嵁婧愯繛鎺ュ埌MySQL鏈嶅姟鍣�锛屽苟鏄剧ず鍙�瀵煎叆鎴栭摼鎺ョ殑琛ㄦ竻鍗曘��

6.    鐐瑰嚮甯屾湜瀵煎叆鎴栭摼鎺ョ殑姣忎釜琛�锛岀劧鍚庣偣鍑籓K銆傚�傛灉浣犳�ｅ湪閾炬帴1涓�琛�锛屼絾瀹冩病鏈夊敮涓�璇嗗埆鍚勬潯璁板綍鐨勭储寮曪紝Microsoft Access灏嗘樉绀洪摼鎺ヨ〃涓�鐨勫瓧娈靛垪琛ㄣ�傜偣鍑昏兘鍞�涓�鏍囪瘑鍚勮�板綍鐨勫瓧娈垫垨瀛楁�电粍鍚堬紝鐒跺悗鐐瑰嚮OK銆�

鏄�銆傚綋閾炬帴琛ㄧ殑缁撴瀯鎴栦綅缃�鍙戠敓鍙樺寲鏃讹紝鍙�閲囧彇涓嬭堪姝ラ�ゆ煡鐪嬫垨鍒锋柊閾炬帴銆傗�滈摼鎺ヨ〃绠＄悊鍣ㄢ�濆垪鍑轰簡褰撳墠閾炬帴鐨勬墍鏈夎〃鐨勮矾寰勩��

瑕佹兂鏌ョ湅鎴栧埛鏂伴摼鎺ワ細

1.    鎵撳紑鍖呭惈琛ㄩ摼鎺ョ殑鏁版嵁搴撱��

2.    鍦ㄢ�滃伐鍏封�濊彍鍗曚笂锛屾寚鍚戔�滃姞杞介」鈥濓紙鍦ˋccess 2000鎴栨洿鏂扮増鏈�涓�涓衡�滄暟鎹�搴撳疄鐢ㄥ伐鍏封�濓級锛岀劧鍚庣偣鍑烩�滈摼鎺ヨ〃绠＄悊鍣ㄢ�濄��

3.    閫変腑鎵撶畻鍒锋柊閾炬帴鐨勮〃鐨勫�嶉�夋�嗐��

4.    鐐瑰嚮OK锛屽埛鏂伴摼鎺ャ��

Microsoft Access灏嗙‘璁ゆ垚鍔熺殑鍒锋柊鎿嶄綔锛屾垨鑰咃紝濡傛灉鏈�鎵惧埌琛�锛屽皢鏄剧ず鈥滈�夋嫨<table name>鏂颁綅缃�鈥濆�硅瘽妗嗭紝鍦ㄨ�ュ�硅瘽妗嗕腑锛�鍙�鎸囧畾琛ㄧ殑鏂颁綅缃�銆傚�傛灉浣犳墍閫夋嫨鐨勬暟涓�琛ㄥ凡琚�绉昏嚦浣犳墍鎸囧畾鐨勬柊浣嶇疆锛岄摼鎺ヨ〃绠＄悊鍣ㄥ皢閽堝�规墍鏈夋墍閫夌殑琛ㄦ悳绱㈣�ヤ綅缃�锛屽苟涓�娆℃�у湴鏇存柊鎵�鏈夐摼鎺ャ��

瑕佹兂鏇存敼閾炬帴琛ㄩ泦鍚堢殑璺�寰勶細

1.    鎵撳紑鍖呭惈琛ㄩ摼鎺ョ殑鏁版嵁搴撱��

2.    鍦ㄢ�滃伐鍏封�濊彍鍗曚笂锛屾寚鍚戔�滃姞杞介」鈥濓紙鍦ˋccess 2000鎴栨洿鏂扮増鏈�涓�涓衡�滄暟鎹�搴撳疄鐢ㄥ伐鍏封�濓級锛岀劧鍚庣偣鍑烩�滈摼鎺ヨ〃绠＄悊鍣ㄢ�濄��

3.    閫変腑鈥滃�规柊浣嶇疆濮嬬粓鎻愮ず鈥濆�嶉�夋�嗐��

4.    閫変腑鎵撶畻鏇存敼閾炬帴鐨勮〃鐨勫�嶉�夋�嗭紝鐒跺悗鐐瑰嚮OK銆�

5.    鍦ㄢ�滈�夋嫨<table name>鏂颁綅缃�鈥濆�硅瘽妗嗕腑锛屾寚瀹氭柊浣嶇疆锛岀偣鍑烩�滄墦寮�鈥濓紝鐒跺悗鐐瑰嚮OK銆�

濡傛灉鍦ˋccess涓�鎻掑叆鎴栨洿鏂扮殑璁板綍鏄剧ず涓衡��#DELETED#鈥濓細

路         濡傛灉浣犳�ｅ湪浣跨敤Access 2000锛屽簲浠庝笅杩板湴鍧�鑾峰彇骞跺畨瑁呮渶鏂扮殑锛�2.6鐗堟垨鏇撮珮锛塎icrosoft MDAC锛�Microsoft鏁版嵁璁块棶缁勪欢锛夛紝http://www.microsoft.com/data/銆傚畠鏇存�ｄ簡Access鍦ㄥ皢鏁版嵁瀵煎嚭鑷矼ySQL鏃跺瓨鍦ㄧ殑涓�涓�缂洪櫡锛屾湭鎸囧畾琛ㄥ悕鍜屽垪鍚嶃�傚彟涓�绉嶈В鍐宠�ョ己闄风殑鏂规硶鏄�锛屽崌绾у埌MyODBC 2.50.33鍜孧ySQL 3.23.x, 瀹冧滑鍏卞悓鎻愪緵浜嗛伩鍏嶈�ラ棶棰樼殑涓�绉嶆柟寮忋��

姝ゅ�栵紝浣犺繕搴旇幏鍙栧苟搴旂敤Microsoft Jet 4.0 Service Pack 5 (SP5)锛屽彲鍦ㄤ笅杩板湴鍧�鎵惧埌瀹冿細http://support.microsoft.com/default.aspx?scid=kb;EN-US;q239114銆傚畠淇�姝ｄ簡鏌愪簺鎯呭喌涓嬪湪Access涓�鍒楄��鏍囨敞涓衡��#DELETED#鈥�鐨勯棶棰樸��

娉ㄩ噴锛� 濡傛灉浣犳�ｄ娇鐢∕ySQL 3.22锛屽繀椤诲畨瑁匨DAC琛ヤ竵锛屽苟浣跨敤MyODBC 2.50.32鎴�2.50.34鎴栨洿楂樼増鏈�浠ヨВ鍐宠�ラ棶棰樸��

路         瀵逛簬鎵�鏈夌増鏈�鐨凙ccess锛屽簲鍚�鐢ㄢ�淢yODBC杩斿洖鍖归厤琛屸�濋�夐」銆傚�逛簬Access 2.0锛岃繕搴旈�濆�栧惎鐢ㄢ��妯℃嫙ODBC 1.0鈥�閫夐」銆�

路         鍦ㄥ笇鏈涜兘澶熸洿鏂扮殑鎵�鏈夎〃涓�锛屽潎搴旀湁鏃堕棿鎴炽�備负浜嗚幏寰楁渶澶х殑鍙�绉绘�嶆�э紝鍦ㄥ垪澹版槑涓�涓嶈�佷娇鐢ㄩ暱搴﹁�勮寖銆備篃灏辨槸璇达紝搴斾娇鐢�TIMESTAMP锛岃�屼笉鏄疶IMESTAMP(n), n < 14銆�

路         鍦ㄨ〃涓�搴旀湁1涓�涓婚敭銆傚�備笉鐒讹紝鏂扮殑鎴栨洿鏂扮殑琛屽彲鑳戒細鏄剧ず涓衡��#DELETED#鈥濄��

路         浠呭簲浣跨敤DOUBLE娴�鐐瑰瓧娈点��涓庡崟绮惧害娴�鐐硅繘琛屾瘮杈冩椂锛孉ccess灏嗗け璐ャ�傚叾寰佸厗鏄�鏂扮殑鎴栨洿鏂扮殑琛屽彲鑳戒細鏄剧ず涓衡��#DELETED#鈥濓紝鎴栨棤娉曟壘鍒版垨鏇存柊琛屻��

路         濡傛灉浣犳�ｄ娇鐢∕yODBC鏉ラ摼鎺ュ埌鏈塀IGINT鍒楃殑琛�锛岀粨鏋滀細鏄剧ず涓衡��#DELETED鈥濄�傛帓闄ゅ畠鐨勮В鍐虫柟妗堟槸锛�

o        鏈�1涓�浠�TIMESTAMP浣滀负鏁版嵁绫诲瀷鐨勮櫄鎷熷垪銆�

o        鍦ㄢ�淥DBC DSN绠＄悊鍣ㄢ�濈殑杩炴帴瀵硅瘽妗嗕腑閫夋嫨鈥滃皢BIGINT鍒楁洿鏀逛负INT鈥濋�夐」銆�

o        鍒犻櫎涓嶢ccess鐨勮〃閾炬帴锛屽苟閲嶆柊鍒涘缓瀹冦��

鏃ц�板綍浠嶅皢鏄剧ず涓衡��#DELETED#鈥濓紝浣嗘柊澧烇紡鏇存柊鐨勮�板綍浼氭伆褰撴樉绀恒��

瀵逛簬鏌愪簺绋嬪簭锛屽彲鑳戒細鍑虹幇璇ラ敊璇�锛� 鍙︿竴鐢ㄦ埛鏇存敼浜嗕綘鎵�淇�鏀圭殑璁板綍銆傚湪澶у�氭暟鎯呭喌涓嬶紝鍙�閫氳繃涓嬭堪鎺�鏂借В鍐宠�ラ棶棰橈細

路         濡傛灉涓婚敭涓嶅瓨鍦�锛屼负琛ㄦ坊鍔�1涓�涓婚敭銆�

路         濡傛灉鏃堕棿鎴充笉瀛樺湪锛屾坊鍔�1涓�鏃堕棿鎴冲垪銆�

路         浠呭簲浣跨敤DOUBLE娴�鐐瑰瓧娈点��涓庡崟绮惧害娴�鐐瑰�兼瘮杈冩椂锛屾煇浜涚▼搴忎細鍑洪敊銆�

濡傛灉杩欎簺鎺�鏂芥湭鑳借В鍐抽棶棰橈紝棣栧厛搴斾粠ODBC绠＄悊鍣ㄧ敓鎴�1涓�鏃ュ織鏂囦欢锛堣�锋眰鏉ヨ嚜ODBC ADMIN鐨勬棩蹇楁椂鑾峰緱鐨勬棩蹇楁枃浠讹級锛屼互鍙�1涓狹yODBC鏃ュ織锛屼娇鐢ㄥ畠浠�鎵惧嚭鍑洪敊鐨勫師鍥犮�傚叿浣撲粙缁嶏紝璇峰弬瑙�26.1.9.7鑺傦紝鈥滆幏鍙朞DBC璺熻釜鏂囦欢鈥�銆�

灏嗗厜鏍囦綅缃�鎸囧畾涓篴dUseServer鏃讹紝ADO鐨�GetChunk()鍜�AppendChunk()鏂规硶涓嶈兘鎸夐�勬湡鐨勬柟寮忓伐浣溿�備粠鍙︿竴鏂归潰涓婅�诧紝鍙�浣跨敤adUseClient鍏嬫湇璇ラ棶棰樸��

鍦�http://www.dwam.net/iishelp/ado/docs/adomth02_4.htm涓婄粰鍑轰簡涓�涓�绠�鍗曠ず渚嬨��

涓嬮潰缁欏嚭浜哅ike Hillyer锛�m.hillyer@telusplanet.net锛夊啓鐨勪竴绡囧ソ鏂囩珷锛屽叾涓�瑙ｉ噴浜嗗�備綍鍦ˋDO涓�閫氳繃MyODBC鎻掑叆鏁版嵁鍜岋紡鎴栦粠Blob鍒楄幏鍙栨暟鎹�鐨勬柟娉曘��MySQL BLOB鍒楀拰Visual Basic 6銆�

涓嬮潰缁欏嚭浜咥DO銆丏AO鍜孯DO涓嶸B涓�璧蜂娇鐢ㄧ殑鐢ㄦ硶绀轰緥锛�

路         ADO绀轰緥锛� 26.1.19鑺傦紝鈥淢yODBC涓嶸B锛欰DO銆丏AO鍜孯DO鈥�

路         DAO绀轰緥锛� 26.1.19鑺傦紝鈥淢yODBC涓嶸B锛欰DO銆丏AO鍜孯DO鈥�

路         RDO绀轰緥锛� 26.1.19鑺傦紝鈥淢yODBC涓嶸B锛欰DO銆丏AO鍜孯DO鈥�

濡傛灉浣犳湁鍏朵粬濂界殑渚嬪瓙锛屾垨鍏充簬ADO/DAO/RDO鐨勫熀鏈�鐭ヨ瘑锛岃�峰皢璇︽儏鍙戦�佽嚦myodbc@lists.mysql.com銆�

涓�涓�甯歌�侀棶棰樻槸锛屽�備綍鑾峰彇浠嶪NSERT璇�鍙ヨ嚜鍔ㄧ敓鎴愮殑ID鐨勫�笺�備娇鐢∣DBC锛屼綘鍙�浠ヤ綔涓庝互涓嬬ず渚嬬被浼肩殑浠讳綍浜嬶紙鍋囧畾鈥渁uto鈥濅负AUTO_INCREMENT瀛楁�碉級锛�

INSERT INTO tbl (auto,text) VALUES(NULL,'text');

SELECT LAST_INSERT_ID();

鎴栬�咃紝濡傛灉浣犱粎鎵撶畻灏咺D鎻掑叆鍒板彟涓�琛ㄤ腑锛屼綘鍙�浠ワ細

INSERT INTO tbl (auto,text) VALUES(NULL,'text');

INSERT INTO tbl2 (id,text) VALUES(LAST_INSERT_ID(),'text');

璇峰弬瑙�25.2.13.3鑺傦紝鈥滃�備綍鑾峰緱涓婃�℃彃鍏ヨ�岀殑鍞�涓�ID鈥�銆�

涓轰簡浣挎煇浜汷DBC搴旂敤绋嬪簭锛堣嚦灏戞槸Delphi鍜孉ccess锛夎幏寰楁洿濂界殑鎬ц兘锛屽彲浣跨敤涓嬭堪鏌ヨ�㈡潵鎵惧埌鏂版彃鍏ョ殑琛岋細

SELECT * FROM tbl WHERE auto IS NULL;

鏄�銆備綘鍙�浠ヤ娇鐢�odbc.net锛岄�氳繃MyODBC杩炴帴鍒癕ySQL銆傝繖閲岀粰鍑轰簡涓�浜涗粠VC.NET鍜孷B.NET杩炴帴鍒癕ySQL鐨勫熀鏈�绀轰緥銆�

路         璇峰弬瑙�26.1.20.1鑺傦紝鈥淥DBC.NET: CSHARP(C#)鈥�

路         璇峰弬瑙�26.1.20.2鑺傦紝鈥淥DBC.NET: VB鈥�

杩欓噷缁欏嚭浜�Venu锛圡yODBC寮�鍙戜汉鍛橈級鎾板啓鐨勫彟涓�绡囧ソ鏂囩珷鐮旂┒.NET鐜�澧冧笅鐨凪ySQL锛屽叾涓�锛岀粰鍑轰簡鎵�鏈夌殑MySQL .NET鎺ュ彛浠ュ強涓�浜涙湁鐢ㄧ殑渚嬪瓙銆�

娉ㄦ剰锛� 鍦ㄤ笌MyODBC涓�璧蜂娇鐢∣DBC.NET鐨勮繃绋嬩腑锛屽湪鑾峰彇绌哄瓧绗︿覆鐨勫悓鏃讹紙闀垮害涓�0锛夛紝灏嗙粰鍑篠QL_NO_DATA寮傚父銆備粠绔欑偣http://support.microsoft.com/default.aspx?scid=kb;EN-US;q319243锛屽彲鑾峰彇閽堝�瑰畠鐨勮ˉ涓併��

MyODBC姣斿叾浠朞DBC椹卞姩绋嬪簭蹇�寰堝�氥�傜紦鎱㈠彲鑳芥槸鍥犳湭浣跨敤涓嬭堪閫夐」閫犳垚鐨勶細

路         鎵撳紑鈥淥DBC璺熻釜鈥濋�夐」銆傞伒寰�杩欓噷缁欏嚭鐨勬寚绀鸿�存槑锛屼氦鍙夋��鏌ユ槸鍚︽湭鍚�鐢ㄨ�ラ�夐」銆�

濡備笂鍥炬墍绀猴紝鈥淥DBC鏁版嵁婧愮�＄悊鍣ㄢ�濃�滆窡韪�鈥濋�夐」鍗＄殑鈥滀綍鏃惰窡韪�鈥濋�夐」搴斿�嬬粓鎸囧悜鈥滅幇鍦ㄥ紑濮嬭窡韪�鈥濓紝鑰屼笉鏄�鈥滅幇鍦ㄥ仠姝㈣窡韪�鈥濄��

路         浣跨敤浜嗛┍鍔ㄧ▼搴忕殑璋冭瘯鐗堟湰銆傚�傛灉浣犳�ｅ湪浣跨敤椹卞姩DLL鐨勮皟璇曠増鏈�锛屼篃浼氫娇鏌ヨ�㈠�勭悊鍙樻參銆備綘鍙�浠ユ墽琛屼氦鍙夋��鏌ワ紝閫氳繃椹卞姩DLL灞炴�э紙鍦ㄧ郴缁熺洰褰曚笅锛屽彸鍑婚┍鍔―LL骞剁偣鍑烩�滃睘鎬р�濓級鐨勨�滄敞閲娾�濆尯锛屾��鏌�DLL鏄�鍚︽槸璋冭瘯鐗堟垨鍙戝竷鐗堬紝濡備笅鍥炬墍绀猴細

路         鍚�鐢ㄤ簡鈥滈┍鍔ㄨ窡韪�鍜屾煡璇㈡棩蹇椻�濄�傚嵆浣夸綘鎵撶畻浣跨敤椹卞姩绋嬪簭鐨勮皟璇曠増锛堝湪鐢熶骇鐜�澧冧笅鎬诲簲浣跨敤鍙戝竷鐗堬級锛屼篃搴旂‘淇濈�佹��浜嗏�滈┍鍔ㄨ窡韪�鍜屾煡璇㈡棩蹇椻�濋�夐」锛圤PTION=4,524288锛夛紝濡備笅鍥炬墍绀猴細

鍦ㄤ笅闈㈢殑ADO锛圓ctiveX鏁版嵁瀵硅薄锛夌ず渚嬩腑锛屽垱寤轰簡琛�my_ado锛屽苟婕旂ず浜唕s.addNew銆�rs.delete鍜�rs.update鐨勭敤娉曘��

Private Sub myodbc_ado_Click()

Dim conn As ADODB.Connection

Dim rs As ADODB.Recordset

Dim fld As ADODB.Field

Dim sql As String

'connect to MySQL server using MySQL ODBC 3.51 Driver锛堜娇鐢∕ySQL ODBC 3.51椹卞姩绋嬪簭杩炴帴鍒癕ySQL鏈嶅姟鍣�锛�

Set conn = New ADODB.Connection

conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};"_

                      & "SERVER=localhost;"_

                      & " DATABASE=test;"_

                      & "UID=venu;PWD=venu; OPTION=3"

conn.Open

'create table锛堝垱寤鸿〃锛�

conn.Execute "DROP TABLE IF EXISTS my_ado"

conn.Execute "CREATE TABLE my_ado(id int not null primary key, name varchar(20)," _

                               & "txt text, dt date, tm time, ts timestamp)"

'direct insert锛堢洿鎺ユ彃鍏ワ級

conn.Execute "INSERT INTO my_ado(id,name,txt) values(1,100,'venu')"

conn.Execute "INSERT INTO my_ado(id,name,txt) values(2,200,'MySQL')"

conn.Execute "INSERT INTO my_ado(id,name,txt) values(3,300,'Delete')"

Set rs = New ADODB.Recordset

rs.CursorLocation = adUseServer

'fetch the initial table ..锛堣幏鍙栧垵濮嬭〃鈥︼級

rs.Open "SELECT * FROM my_ado", conn

  Debug.Print rs.RecordCount

  rs.MoveFirst

  Debug.Print String(50, "-") & "Initial my_ado Result Set " & String(50, "-")

  For Each fld In rs.Fields

    Debug.Print fld.Name,

    Next

    Debug.Print

    Do Until rs.EOF

    For Each fld In rs.Fields

    Debug.Print fld.Value,

    Next

    rs.MoveNext

    Debug.Print

  Loop

rs.Close

'rs insert锛�rs鎻掑叆锛�

rs.Open "select * from my_ado", conn, adOpenDynamic, adLockOptimistic

rs.AddNew

rs!Name = "Monty"

rs!txt = "Insert row"

rs.Update

rs.Close

'rs update锛�rs鏇存柊锛�

rs.Open "SELECT * FROM my_ado"

rs!Name = "update"

rs!txt = "updated-row"

rs.Update

rs.Close

'rs update second time..锛�rs鏇存柊绗�2娆♀�︼級

rs.Open "SELECT * FROM my_ado"

rs!Name = "update"

rs!txt = "updated-second-time"

rs.Update

rs.Close

'rs delete锛�rs鍒犻櫎锛�

rs.Open "SELECT * FROM my_ado"

rs.MoveNext

rs.MoveNext

rs.Delete

rs.Close

'fetch the updated table ..锛堣幏鍙栨洿鏂扮殑琛ㄢ�︼級

rs.Open "SELECT * FROM my_ado", conn

  Debug.Print rs.RecordCount

  rs.MoveFirst

  Debug.Print String(50, "-") & "Updated my_ado Result Set " & String(50, "-")

  For Each fld In rs.Fields

    Debug.Print fld.Name,

    Next

    Debug.Print

    Do Until rs.EOF

    For Each fld In rs.Fields

    Debug.Print fld.Value,

    Next

    rs.MoveNext

    Debug.Print

  Loop

rs.Close

conn.Close

End Sub

鍦ㄤ笅闈㈢殑绠�鍗曠ず渚嬩腑鍒涘缓浜嗚〃my_odbc_net锛屽苟浠嬬粛浜嗗畠鍦–#涓�鐨勪娇鐢ㄣ��

/**
* @sample    : mycon.cs
* @purpose   : Demo sample for ODBC.NET using MyODBC
* @author    : Venu, <venu@mysql.com>
*
* (C) Copyright MySQL AB, 1995-2004
*
**/

/* build command
*
*  csc /t:exe
*      /out:mycon.exe mycon.cs
*      /r:Microsoft.Data.Odbc.dll
*/

using Console = System.Console;
using Microsoft.Data.Odbc;

namespace myodbc3
{
class mycon
{
  static void Main(string[] args)
  {
    try
    {
      //Connection string for MyODBC 2.50
      /*string MyConString = "DRIVER={MySQL};" +
                           "SERVER=localhost;" +
                           "DATABASE=test;" +
                           "UID=venu;" +
                           "PASSWORD=venu;" +
                           "OPTION=3";
      */
      //Connection string for MyODBC 3.51
      string MyConString = "DRIVER={MySQL ODBC 3.51 Driver};" +
                           "SERVER=localhost;" +
                           "DATABASE=test;" +
                           "UID=venu;" +
                           "PASSWORD=venu;" +
                           "OPTION=3";

      //Connect to MySQL using MyODBC
      OdbcConnection MyConnection = new OdbcConnection(MyConString);
      MyConnection.Open();

      Console.WriteLine("\n !!! success, connected successfully !!!\n");

      //Display connection information
      Console.WriteLine("Connection Information:");
      Console.WriteLine("\tConnection String:" + MyConnection.ConnectionString);
      Console.WriteLine("\tConnection Timeout:" + MyConnection.ConnectionTimeout);
      Console.WriteLine("\tDatabase:" + MyConnection.Database);
      Console.WriteLine("\tDataSource:" + MyConnection.DataSource);
      Console.WriteLine("\tDriver:" + MyConnection.Driver);
      Console.WriteLine("\tServerVersion:" + MyConnection.ServerVersion);

      //Create a sample table
      OdbcCommand MyCommand = new OdbcCommand("DROP TABLE IF EXISTS my_odbc_net",MyConnection);
      MyCommand.ExecuteNonQuery();
      MyCommand.CommandText = "CREATE TABLE my_odbc_net(id int, name varchar(20), idb bigint)";
      MyCommand.ExecuteNonQuery();

      //Insert
      MyCommand.CommandText = "INSERT INTO my_odbc_net VALUES(10,'venu', 300)";
      Console.WriteLine("INSERT, Total rows affected:" + MyCommand.ExecuteNonQuery());;

      //Insert
      MyCommand.CommandText = "INSERT INTO my_odbc_net VALUES(20,'mysql',400)";
      Console.WriteLine("INSERT, Total rows affected:" + MyCommand.ExecuteNonQuery());

      //Insert
      MyCommand.CommandText = "INSERT INTO my_odbc_net VALUES(20,'mysql',500)";
      Console.WriteLine("INSERT, Total rows affected:" + MyCommand.ExecuteNonQuery());

      //Update
      MyCommand.CommandText = "UPDATE my_odbc_net SET id=999 WHERE id=20";
      Console.WriteLine("Update, Total rows affected:" + MyCommand.ExecuteNonQuery());

      //COUNT(*)
      MyCommand.CommandText = "SELECT COUNT(*) as TRows FROM my_odbc_net";
      Console.WriteLine("Total Rows:" + MyCommand.ExecuteScalar());

      //Fetch
      MyCommand.CommandText = "SELECT * FROM my_odbc_net";
      OdbcDataReader MyDataReader;
      MyDataReader =  MyCommand.ExecuteReader();
      while (MyDataReader.Read())
      {
       if(string.Compare(MyConnection.Driver,"myodbc3.dll") == 0) {
         Console.WriteLine("Data:" + MyDataReader.GetInt32(0) + " " +
                                     MyDataReader.GetString(1) + " " +
                                     MyDataReader.GetInt64(2)); //Supported only by MyODBC 3.51
       }
       else {
         Console.WriteLine("Data:" + MyDataReader.GetInt32(0) + " " +
                                     MyDataReader.GetString(1) + " " +
                                     MyDataReader.GetInt32(2)); //BIGINTs not supported by MyODBC
       }
      }

      //Close all resources
      MyDataReader.Close();
      MyConnection.Close();
    }
    catch (OdbcException MyOdbcException)//Catch any ODBC exception ..
    {
      for (int i=0; i < MyOdbcException.Errors.Count; i++)
      {
        Console.Write("ERROR #" + i + "\n" +
          "Message: " + MyOdbcException.Errors[i].Message + "\n" +
          "Native: " + MyOdbcException.Errors[i].NativeError.ToString() + "\n" +
          "Source: " + MyOdbcException.Errors[i].Source + "\n" +
          "SQL: " + MyOdbcException.Errors[i].SQLState + "\n");
      }
    }
  }
}
}

鍦ㄤ笅闈㈢殑绠�鍗曠ず渚嬩腑鍒涘缓浜嗚〃my_vb_net锛屽苟浠嬬粛浜嗗畠鍦╒B涓�鐨勭敤娉曘��

' @sample    : myvb.vb
' @purpose   : Demo sample for ODBC.NET using MyODBC
' @author    : Venu, <venu@mysql.com>
'
' (C) Copyright MySQL AB, 1995-2004
'
'

'
' build command
'
' vbc /target:exe
'     /out:myvb.exe
'     /r:Microsoft.Data.Odbc.dll
'     /r:System.dll
'     /r:System.Data.dll
'

Imports Microsoft.Data.Odbc
Imports System

Module myvb
  Sub Main()
      Try

          'MyODBC 3.51 connection string
          Dim MyConString As String = "DRIVER={MySQL ODBC 3.51 Driver};" & _
                         "SERVER=localhost;" & _
                         "DATABASE=test;" & _
                         "UID=venu;" & _
                         "PASSWORD=venu;" & _
                         "OPTION=3;"

          'Connection
          Dim MyConnection As New OdbcConnection(MyConString)
          MyConnection.Open()

          Console.WriteLine ("Connection State::" & MyConnection.State.ToString)

          'Drop
          Console.WriteLine ("Dropping table")
          Dim MyCommand As New OdbcCommand()
          MyCommand.Connection = MyConnection
          MyCommand.CommandText = "DROP TABLE IF EXISTS my_vb_net"
          MyCommand.ExecuteNonQuery()

          'Create
          Console.WriteLine ("Creating....")
          MyCommand.CommandText = "CREATE TABLE my_vb_net(id int, name varchar(30))"
          MyCommand.ExecuteNonQuery()

          'Insert
          MyCommand.CommandText = "INSERT INTO my_vb_net VALUES(10,'venu')"
          Console.WriteLine("INSERT, Total rows affected:" & MyCommand.ExecuteNonQuery())

          'Insert
          MyCommand.CommandText = "INSERT INTO my_vb_net VALUES(20,'mysql')"
          Console.WriteLine("INSERT, Total rows affected:" & MyCommand.ExecuteNonQuery())

          'Insert
          MyCommand.CommandText = "INSERT INTO my_vb_net VALUES(20,'mysql')"
          Console.WriteLine("INSERT, Total rows affected:" & MyCommand.ExecuteNonQuery())

          'Insert
          MyCommand.CommandText = "INSERT INTO my_vb_net(id) VALUES(30)"
          Console.WriteLine("INSERT, Total rows affected:" & MyCommand.ExecuteNonQuery())

          'Update
          MyCommand.CommandText = "UPDATE my_vb_net SET id=999 WHERE id=20"
          Console.WriteLine("Update, Total rows affected:" & MyCommand.ExecuteNonQuery())

          'COUNT(*)
          MyCommand.CommandText = "SELECT COUNT(*) as TRows FROM my_vb_net"
          Console.WriteLine("Total Rows:" & MyCommand.ExecuteScalar())

          'Select
          Console.WriteLine ("Select * FROM my_vb_net")
          MyCommand.CommandText = "SELECT * FROM my_vb_net"
          Dim MyDataReader As OdbcDataReader
          MyDataReader = MyCommand.ExecuteReader
          While MyDataReader.Read
              If MyDataReader("name") Is DBNull.Value Then
                  Console.WriteLine ("id = " & CStr(MyDataReader("id")) & "  name = " & _
                    "NULL")
              Else
                  Console.WriteLine ("id = " & CStr(MyDataReader("id")) & "  name = " & _
                                        CStr(MyDataReader("name")))
              End If
          End While

      'Catch ODBC Exception
      Catch MyOdbcException As OdbcException
          Dim i As Integer
          Console.WriteLine (MyOdbcException.ToString)

      'Catch program exception
      Catch MyException As Exception
          Console.WriteLine (MyException.ToString)
  End Try
  End Sub
End Module

MySqlCommand绫�浠ｈ〃瀵筂ySQL鏁版嵁搴撹繘琛屾墽琛屾搷浣滅殑SQL璇�鍙ャ��

娉ㄩ噴锛�鍦ㄤ互鍓嶇殑鐗堟湰涓�锛岄噰鐢ㄧ�﹀彿鈥淍鈥濇潵鏍囪瘑SQL涓�鐨勫弬鏁般�傚畠涓嶮ySQL鐢ㄦ埛鍙橀噺涓嶅吋瀹癸紝鍥犳�わ紝鐜伴噰鐢ㄧ�﹀彿鈥�?鈥濇潵瀹氫綅SQL涓�鐨勫弬鏁般�備负浜嗘敮鎸佹棭鏈熶唬鐮侊紝涔熷彲浠ュ湪杩炴帴瀛楃�︿覆涓�璁剧疆鈥渙ld syntax=yes鈥濄�傚�傛灉杩涜�屼簡杩欑被璁剧疆锛岃�锋敞鎰忥紝濡傛灉鏃犳硶瀹氫箟甯屾湜鍦⊿QL涓�浣跨敤鐨勫弬鏁帮紙瀹氫箟澶辫触锛夛紝涓嶄細缁欏嚭寮傚父鎻愮ず銆�

Public Sub InsertRow(myConnectionString As String)
    ' If the connection string is null, use a default.
    If myConnectionString = "" Then
        myConnectionString = "Database=Test;Data Source=localhost;User Id=username;Password=pass"
    End If
    Dim myConnection As New MySqlConnection(myConnectionString)
    Dim myInsertQuery As String = "INSERT INTO Orders (id, customerId, amount) Values(1001, 23, 30.66)"
    Dim myCommand As New MySqlCommand(myInsertQuery)
    myCommand.Connection = myConnection
    myConnection.Open()
    myCommand.ExecuteNonQuery()
    myCommand.Connection.Close()
End Sub

public void InsertRow(string myConnectionString) 
{
    // If the connection string is null, use a default.
    if(myConnectionString == "") 
    {
        myConnectionString = "Database=Test;Data Source=localhost;User Id=username;Password=pass";
    }
    MySqlConnection myConnection = new MySqlConnection(myConnectionString);
    string myInsertQuery = "INSERT INTO Orders (id, customerId, amount) Values(1001, 23, 30.66)";
    MySqlCommand myCommand = new MySqlCommand(myInsertQuery);
    myCommand.Connection = myConnection;
    myConnection.Open();
    myCommand.ExecuteNonQuery();
    myCommand.Connection.Close();
}

MySqlDataAdapter涓嶄細鑷�鍔ㄧ敓鎴愭墍闇�鐨凷QL璇�鍙ワ紙鐢ㄤ簬鍗忚皟瀵笵ataSet鎵�浣滅殑鏇存敼鍜岀浉鍏崇殑MySQL瀹炰緥锛夈�備絾鏄�锛屽�傛灉璁剧疆浜哅ySqlDataAdapter鐨凷electCommand灞炴�э紝鍙�浠ュ垱寤篗ySqlCommandBuilder瀵硅薄鏉ヨ嚜鍔ㄧ敓鎴愰拡瀵瑰崟涓�琛ㄦ洿鏂扮殑SQL璇�鍙ャ�傞殢鍚庯紝MySqlCommandBuilder灏嗙敓鎴愪綘鏈�璁剧疆鐨勪换浣曢檮鍔犵殑SQL璇�鍙ャ��

涓�鏃︿綘璁剧疆浜咲ataAdapter灞炴�э紝MySqlCommandBuilder浼氬皢鑷�宸辨敞鍐屼负閽堝�筄nRowUpdating浜嬩欢鐨勭洃鍚�绋嬪簭銆備竴娆″彧鑳藉皢1涓狹ySqlDataAdapter鎴朚ySqlCommandBuilder瀵硅薄鍏宠仈璧锋潵銆�

涓轰簡鐢熸垚INSERT銆乁PDATE鎴朌ELETE璇�鍙ワ紝MySqlCommandBuilder浣跨敤浜哠electCommand灞炴�ф潵鑷�鍔ㄦ��绱㈡墍闇�鐨勫厓鏁版嵁闆嗗悎銆傚�傛灉鍦ㄦ��绱㈠畬鍏冩暟鎹�鍚庢洿鏀逛簡SelectCommand锛堜緥濡傞�栨�℃洿鏂板悗锛夛紝搴旇皟鐢≧efreshSchema鏂规硶鏉ユ洿鏂板厓鏁版嵁銆�

SelectCommand涔熷繀椤昏繑鍥炶嚦灏�1涓�涓婚敭鎴栧敮涓�鍒椼�傚�傛灉鏈�鏄剧ず浠讳綍杩斿洖淇℃伅锛屽皢鐢熸垚InvalidOperation寮傚父锛岃�屼笖涓嶄細鐢熸垚鍛戒护銆�

MySqlCommandBuilder杩樹細浣跨敤SelectCommand寮曠敤鐨凜onnection銆丆ommandTimeout鍜孴ransaction灞炴�с�傚�傛灉鏇存敼浜嗚繖浜涘睘鎬т腑鐨勪换浣�1涓�锛屾垨鑰咃紝濡傛灉鏇挎崲浜哠electCommand鏈�韬�锛岀敤鎴峰簲璋冪敤RefreshSchema銆傚�備笉鐒讹紝InsertCommand銆乁pdateCommand鍜孌eleteCommand灞炴�у皢淇濇寔瀹冧滑浠ュ墠鐨勫�笺��

濡傛灉璋冪敤浜咲ispose锛孧ySqlCommandBuilder灏嗚В闄や笌MySqlDataAdapter鐨勫叧鑱旓紝宸茬敓鎴愮殑鍛戒护灏嗕笉鍐嶄娇鐢ㄣ��

  Public Shared Function SelectRows(myConnection As String, mySelectQuery As String, myTableName As String) As DataSet
        Dim myConn As New MySqlConnection(myConnection)
        Dim myDataAdapter As New MySqlDataAdapter()
        myDataAdapter.SelectCommand = New MySqlCommand(mySelectQuery, myConn)
        Dim cb As SqlCommandBuilder = New MySqlCommandBuilder(myDataAdapter)

        myConn.Open()

        Dim ds As DataSet = New DataSet
        myDataAdapter.Fill(ds, myTableName)

        ' Code to modify data in DataSet here 

        ' Without the MySqlCommandBuilder this line would fail.
        myDataAdapter.Update(ds, myTableName)

        myConn.Close()
    End Function 'SelectRows
    

    public static DataSet SelectRows(string myConnection, string mySelectQuery, string myTableName)
    {
      MySqlConnection myConn = new MySqlConnection(myConnection);
      MySqlDataAdapter myDataAdapter = new MySqlDataAdapter();
      myDataAdapter.SelectCommand = new MySqlCommand(mySelectQuery, myConn);
      MySqlCommandBuilder cb = new MySqlCommandBuilder(myDataAdapter);

      myConn.Open();

      DataSet ds = new DataSet();
      myDataAdapter.Fill(ds, myTableName);

      //code to modify data in DataSet here

      //Without the MySqlCommandBuilder this line would fail
      myDataAdapter.Update(ds, myTableName);

      myConn.Close();

      return ds;
    }  
    

MySqlConnection瀵硅薄浠ｈ〃涓嶮ySQL鏈嶅姟鍣ㄦ暟鎹�婧愮殑浼氳瘽銆傚垱寤篗ySqlConnection瀹炰緥鏃讹紝鎵�鏈夊睘鎬у潎灏嗚��璁剧疆涓哄畠浠�鐨勫垵濮嬪�笺�傚叧浜庤繖浜涘�肩殑鍒楄〃锛岃�峰弬瑙丮ySqlConnection鏋勯�犲嚱鏁般��

濡傛灉MySqlConnection瓒呭嚭鑼冨洿锛屼笉浼氳��鍏抽棴銆傚洜姝わ紝蹇呴』閫氳繃璋冪敤Close鎴朌ispose鏄庣‘鍦板叧闂�杩炴帴銆�

Public Sub InsertRow(myConnectionString As String)
    ' If the connection string is null, use a default.
    If myConnectionString = "" Then
        myConnectionString = "Database=Test;Data Source=localhost;User Id=username;Password=pass"
    End If
    Dim myConnection As New MySqlConnection(myConnectionString)
    Dim myInsertQuery As String = "INSERT INTO Orders (id, customerId, amount) Values(1001, 23, 30.66)"
    Dim myCommand As New MySqlCommand(myInsertQuery)
    myCommand.Connection = myConnection
    myConnection.Open()
    myCommand.ExecuteNonQuery()
    myCommand.Connection.Close()
End Sub
      

public void InsertRow(string myConnectionString) 
{
    // If the connection string is null, use a default.
    if(myConnectionString == "") 
    {
        myConnectionString = "Database=Test;Data Source=localhost;User Id=username;Password=pass";
    }
    MySqlConnection myConnection = new MySqlConnection(myConnectionString);
    string myInsertQuery = "INSERT INTO Orders (id, customerId, amount) Values(1001, 23, 30.66)";
    MySqlCommand myCommand = new MySqlCommand(myInsertQuery);
    myCommand.Connection = myConnection;
    myConnection.Open();
    myCommand.ExecuteNonQuery();
    myCommand.Connection.Close();
}