ODBC鑸嘨C鐗堥噾绗涚煭淇′腑闁撲欢
閲戠瑳鐭俊涓枔浠舵槸閫氶亷鏁�(sh霉)鎿�(j霉)搴€ｆ帴妤�(y猫)鍕�(w霉)绯荤当(t菕ng)锛屽鐝�(xi脿n)鐒＄斧灏嶆帴锛岃畵妤�(y猫)鍕�(w霉)绯荤当(t菕ng)鍙婃檪銆佸彲闈犮€佹柟渚垮湴鐧�(f膩)鍑虹煭淇�銆傛暩(sh霉)鎿�(j霉)搴彲浠ユ槸浠讳綍骞宠嚭銆佷换浣曠恫(w菐ng)绲�(lu貌)銆佷换浣曟暩(sh霉)鎿�(j霉)搴紝鍩烘湰涓婂彲浠ュ仛鍒伴€ｆ帴涓€鍒囨暩(sh霉)鎿�(j霉)搴�銆傞€欐槸濡備綍鍋氬埌鐨勫憿锛� 鏍稿績灏卞湪浜嶰DBC銆�
ODBC(Open Database Connectivity锛岄枊鏀炬暩(sh霉)鎿�(j霉)搴簰閫�)鏄井杌熷叕鍙搁枊鏀炬湇鍕�(w霉)绲�(ji茅)妲�(g貌u)(WOSA锛學indows Open Services Architecture)涓湁闂�(gu膩n)鏁�(sh霉)鎿�(j霉)搴殑涓€鍊嬬祫鎴愰儴鍒�锛屽畠寤虹珛浜嗕竴绲勮(gu墨)鑼冿紝骞舵彁渚涗簡涓€绲勫皪鏁�(sh霉)鎿�(j霉)搴í鍟忕殑妯欐簴API銆傞€欎簺API鍒╃敤SQL渚嗗畬鎴愬叾澶ч儴鍒嗕换鍕�(w霉)銆侽DBC鏈韩涔熸彁渚涗簡灏峉QL瑾炶█鐨勬敮鎸�锛岀敤鎴跺彲浠ョ洿鎺ュ皣SQL瑾炲彞閫佺郸ODBC銆�
涓€鍊嬪熀浜嶰DBC鐨勬噳(y墨ng)鐢ㄧ▼搴�?q奴)顩�?sh霉)鎿�(j霉)搴殑鎿嶄綔涓嶄緷璩翠换浣旸BMS锛屼笉鐩存帴鑸嘍BMS鎵撲氦閬擄紝鎵€鏈夌殑鏁�(sh霉)鎿�(j霉)搴搷浣滅敱灏嶆噳(y墨ng)鐨凞BMS鐨凮DBC椹�(q奴)鍕曠▼搴忓畬鎴�銆備篃灏辨槸瑾�锛屼笉璜栨槸FoxPro銆丄ccess 銆丮YSQL閭勬槸Oracle鏁�(sh霉)鎿�(j霉)搴�锛屽潎鍙敤ODBC API閫茶瑷晱銆�
ODBC鐨勬渶澶у劒(y艒u)榛炴槸鑳戒互绲�(t菕ng)涓€鐨勬柟寮忚檿鐞嗘墍鏈夌殑鏁�(sh霉)鎿�(j霉)搴�銆�
鍙笉瑕佸皬鐬DBC锛屽畠鍑虹従(xi脿n)浜�1991骞�锛岃嚦浠婂凡缍�(j墨ng)鏈�27骞存鍙蹭簡锛屽彲浠ヨ闈炲父鎴愮啛锛岄潪甯告櫘鍙�銆傚競鍫翠笂鍏枊鐧�(f膩)琛岀殑鏁�(sh霉)鎿�(j霉)搴増鏈紝娌掓湁涓嶆敮鎸丱DBC鐨�銆�
涓枔浠堕€ｆ帴绀烘剰鍦�
閲戠瑳鐭俊涓枔浠跺氨鏄娇鐢∣DBC锛屽鐝�(xi脿n)鐭俊閫ｆ帴涓€鍒�锛屽鐝�(xi脿n)娑堟伅鍙婃檪銆佸彲闈�銆佹柟渚垮湴鐧�(f膩)鍑�銆傚叿楂斾締瑾細
涓€銆佹秷鎭浣曞強鏅傜櫦(f膩)鍑�锛�
鍙婃檪锛屽闀锋檪闁撶畻鍙婃檪锛熶竴鑸締瑾�锛�10绉掑収(n猫i)锛�5绉掑収(n猫i)锛�2绉掑収(n猫i)锛屾寜绉掕▓绠楋紝绠楁槸鍙婃檪銆傛瘮濡傚湴闇囬爯(y霉)璀�锛岄兘鏄寜绉掔畻鐨�銆傚咕绉掑収(n猫i)锛岀煭淇″嚭鐝�(xi脿n)鍦ㄦ墜姗熷睆骞曚笂锛岄€欐槸寰俊绛堿PP姣斾笉浜嗙殑銆傜煭淇℃槸閫氳▕鎶€琛�(sh霉)锛孉PP閫氫俊鎶€琛�(sh霉)锛屼竴瀛椾箣宸�锛屼竴绋槸闆昏矾浜ゆ彌锛屼竴绋槸IP浜ゆ彌锛岄€熷害涔熺浉宸緢閬�銆傚ぇ閮ㄥ垎椹楄瓑纰奸兘鏄€氶亷鐭俊鐧�(f膩)閫�锛岀劇瀹冿紝鍞€熷害鐖�銆�
浜�銆佹秷鎭浣曞彲闈犵櫦(f膩)鍑�锛�
鍙潬锛岃帿閬庝簬绨″柈銆傞€ｆ帴绨″柈銆佺恫(w菐ng)绲�(lu貌)绨″柈锛屾笡灏戝皪缍�(w菐ng)绲�(lu貌)鐨勪緷璩淬€傜恫(w菐ng)绲�(lu貌)鎿佸牭銆佺恫(w菐ng)绲�(lu貌)鏂风窔銆佺恫(w菐ng)绲�(lu貌)鏁呴殰渚濈劧鑳藉惁鐧�(f膩)鍑虹煭淇�锛岄潬鐨勫氨鏄啊鍖栫郴绲�(t菕ng)鏋舵(g貌u)锛屾暣鍊嬬郴绲�(t菕ng)灏卞儚涓€閮ㄦ墜姗熷湪宸ヤ綔锛屽彧瑕佹湁闆汇€佸彧瑕佹湁淇¤櫉锛屽氨鍙互鐧�(f膩)鍑虹煭淇�銆傚彟澶栧彲闈犳€у湪浜庤粺浠剁殑瀹归尟姗熷埗锛岄嚌灏嶉亱鐕熷晢杩斿洖鐨勪俊鎭(di脿o)鏁磋粺浠堕亱琛屽Э鎱�(t脿i)锛屾垨鑰呴噸鐧�(f膩)銆佹垨鑰呴噸鏂板垵濮嬪寲锛岀瓑绛�銆�
涓�銆佹秷鎭浣曟柟渚垮湴鐧�(f膩)鍑�锛�
鏂逛究鐨勬剰缇╂槸锛岄枊鐧�(f膩)鏂逛究锛岄儴缃查潏娲�銆傞潏娲婚儴缃诧紝涔熷氨鏄付渚嗕簡鏂逛究銆侽DBC璺ㄥ钩鑷�銆佽法缍�(w菐ng)绲�(lu貌)锛岄€ｆ帴涓€鍒囨暩(sh霉)鎿�(j霉)搴�锛岄洊涓嶅OLEDB銆丄DO绛夐偅涔堟檪楂�锛屼絾鏄付渚嗙殑鏄劇姣旂殑闁嬫斁鎬�锛岀劇姣旂殑闈堟椿鎬�銆傚彧瑕佷綘鏈変竴鍊嬪彲瑷晱鐨勬暩(sh霉)鎿�(j霉)搴�锛屽氨鍙互閫ｄ笂锛屾姄鍙栦俊鎭櫦(f膩)閫佸嚭鍘�銆�
閲戠瑳VC鐗堢煭淇′腑闁撲欢閫氶亷ODBC锛岃畵SMS鍜孌ATABASE铻嶇偤涓€楂旓紝鐪熸瀵︾従(xi脿n)浜嗘秷鎭緸鏈夌窔鍒扮劇绶氱殑鍙婃檪銆佸彲闈�銆佹柟渚垮偝閬�銆�