ODBC鑸嘨C鐗堥噾绗涚煭淇′腑闁撲欢
閲戠瑳鐭俊涓枔浠舵槸閫氶亷(gu貌)鏁�(sh霉)鎿�(j霉)搴�(k霉)閫f帴妤�(y猫)鍕�(w霉)绯荤当(t菕ng)锛屽(sh铆)鐝�(xi脿n)鐒�(w煤)绺皪(du矛)鎺�锛岃畵妤�(y猫)鍕�(w霉)绯荤当(t菕ng)鍙婃檪(sh铆)銆佸彲闈�銆佹柟渚垮湴鐧�(f膩)鍑虹煭淇�銆傛暩(sh霉)鎿�(j霉)搴�(k霉)鍙互鏄换浣曞钩鑷�(t谩i)銆佷换浣曠恫(w菐ng)绲�(lu貌)銆佷换浣曟暩(sh霉)鎿�(j霉)搴�(k霉)锛屽熀鏈笂鍙互鍋氬埌閫f帴涓€鍒囨暩(sh霉)鎿�(j霉)搴�(k霉)銆傞€欐槸濡備綍鍋氬埌鐨勫憿锛� 鏍稿績灏卞湪浜嶰DBC銆�
ODBC(Open Database Connectivity锛岄枊(k膩i)鏀炬暩(sh霉)鎿�(j霉)搴�(k霉)浜掗€�)鏄井杌熷叕鍙搁枊(k膩i)鏀炬湇鍕�(w霉)绲�(ji茅)妲�(g貌u)(WOSA锛學indows Open Services Architecture)涓湁闂�(gu膩n)鏁�(sh霉)鎿�(j霉)搴�(k霉)鐨勪竴鍊�(g猫)绲勬垚閮ㄥ垎锛屽畠寤虹珛浜嗕竴绲勮(gu墨)鑼�锛屽苟鎻愪緵浜嗕竴绲勫皪(du矛)鏁�(sh霉)鎿�(j霉)搴�(k霉)瑷晱(w猫n)鐨勬(bi膩o)婧�(zh菙n)API銆傞€欎簺API鍒╃敤SQL渚�(l谩i)瀹屾垚鍏跺ぇ閮ㄥ垎浠诲嫏(w霉)銆侽DBC鏈韩涔熸彁渚涗簡灏�(du矛)SQL瑾�(y菙)瑷€鐨勬敮鎸�锛岀敤鎴�(h霉)鍙互鐩存帴灏嘢QL瑾�(y菙)鍙ラ€佺郸ODBC銆�
涓€鍊�(g猫)鍩轰簬ODBC鐨勬噳(y墨ng)鐢ㄧ▼搴�?q奴)顩�?sh霉)鎿�(j霉)搴�(k霉)鐨勬搷浣滀笉渚濊炒(l脿i)浠讳綍DBMS锛屼笉鐩存帴鑸嘍BMS鎵撲氦閬�锛屾墍鏈夌殑鏁�(sh霉)鎿�(j霉)搴�(k霉)鎿嶄綔鐢卞皪(du矛)鎳�(y墨ng)鐨凞BMS鐨凮DBC椹�(q奴)鍕�(d貌ng)绋嬪簭瀹屾垚銆備篃灏辨槸瑾�(shu艒)锛屼笉璜栨槸FoxPro銆丄ccess 銆丮YSQL閭勬槸Oracle鏁�(sh霉)鎿�(j霉)搴�(k霉)锛屽潎鍙敤ODBC API閫�(j矛n)琛岃í鍟�(w猫n)銆�
ODBC鐨勬渶澶у劒(y艒u)榛�(di菐n)鏄兘浠ョ当(t菕ng)涓€鐨勬柟寮忚檿鐞嗘墍鏈夌殑鏁�(sh霉)鎿�(j霉)搴�(k霉)銆�
鍙笉瑕佸皬鐬DBC锛屽畠鍑虹従(xi脿n)浜�1991骞�锛岃嚦浠婂凡缍�(j墨ng)鏈�27骞存鍙蹭簡锛屽彲浠ヨ(shu艒)闈炲父鎴愮啛锛岄潪甯告櫘鍙娿€傚競鍫�(ch菐ng)涓婂叕闁�(k膩i)鐧�(f膩)琛岀殑鏁�(sh霉)鎿�(j霉)搴�(k霉)鐗堟湰锛屾矑(m茅i)鏈変笉鏀寔ODBC鐨勩€�
閲戠瑳鐭俊涓枔浠跺氨鏄娇鐢∣DBC锛屽(sh铆)鐝�(xi脿n)鐭俊閫f帴涓€鍒�锛屽(sh铆)鐝�(xi脿n)娑堟伅鍙婃檪(sh铆)銆佸彲闈�銆佹柟渚垮湴鐧�(f膩)鍑恒€傚叿楂斾締(l谩i)瑾�(shu艒)锛�
涓€銆佹秷鎭浣曞強鏅�(sh铆)鐧�(f膩)鍑�锛�
鍙婃檪(sh铆)锛屽闀�(zh菐ng)鏅�(sh铆)闁撶畻鍙婃檪(sh铆)锛熶竴鑸締(l谩i)瑾�(shu艒)锛�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)璀夌⒓閮芥槸閫氶亷(gu貌)鐭俊鐧�(f膩)閫�锛岀劇(w煤)瀹�锛屽敮閫熷害鐖俱€�
浜�銆佹秷鎭浣曞彲闈犵櫦(f膩)鍑�锛�
鍙潬锛岃帿閬�(gu貌)浜庣啊(ji菐n)鍠�銆傞€f帴绨�(ji菐n)鍠�銆佺恫(w菐ng)绲�(lu貌)绨�(ji菐n)鍠�锛屾笡灏戝皪(du矛)缍�(w菐ng)绲�(lu貌)鐨勪緷璩�(l脿i)銆傜恫(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膩)鍑�锛�
鏂逛究鐨勬剰缇╂槸锛岄枊(k膩i)鐧�(f膩)鏂逛究锛岄儴缃查潏娲汇€傞潏娲婚儴缃�锛屼篃灏辨槸甯朵締(l谩i)浜嗘柟渚�銆侽DBC璺ㄥ钩鑷�(t谩i)銆佽法缍�(w菐ng)绲�(lu貌)锛岄€f帴涓€鍒囨暩(sh霉)鎿�(j霉)搴�(k霉)锛岄洊涓嶅OLEDB銆丄DO绛夐偅涔堟檪(sh铆)楂�锛屼絾鏄付渚�(l谩i)鐨勬槸鐒�(w煤)姣旂殑闁�(k膩i)鏀炬€�锛岀劇(w煤)姣旂殑闈堟椿鎬с€傚彧瑕佷綘鏈変竴鍊�(g猫)鍙í鍟�(w猫n)鐨勬暩(sh霉)鎿�(j霉)搴�(k霉)锛屽氨鍙互閫d笂锛屾姄鍙栦俊鎭櫦(f膩)閫佸嚭鍘�銆�
閲戠瑳VC鐗堢煭淇′腑闁撲欢閫氶亷(gu貌)ODBC锛岃畵SMS鍜孌ATABASE铻嶇偤涓€楂�锛岀湡姝e(sh铆)鐝�(xi脿n)浜嗘秷鎭緸鏈夌窔鍒扮劇(w煤)绶氱殑鍙婃檪(sh铆)銆佸彲闈�銆佹柟渚垮偝閬炪€�