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