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