涓�銆佸紩瑷�
SQL Server
鏄井杞帹鍑虹殑涓皬鍨嬬綉缁滄暟鎹簱绯荤粺锛?/p>
鏄洰鍓嶆渶甯哥敤鐨勬暟鎹簱绯荤粺涔嬩竴銆?/p>
闅?/p>
鐫�
SQL Server
缃戠粶鏁版嵁搴撳簲鐢ㄧ▼搴忔棩鐩婂澶氾紝杩欑
Web
鏁版嵁搴撳簲鐢ㄧ郴缁熺殑姝ｅ父杩愯涓�鑸緷
璧栦簬宸插瓨鍦ㄧ殑鐢ㄦ埛鏁版嵁搴撱�傚垱寤虹淮鎶ゆ暟鎹簱鐨勫伐浣滃彲鐢?/p>
SQL
Server
鎻愪緵鐨?/p>
SQL
Enterprise
Manager
宸ュ叿鏉ヨ繘琛岋紝
濡傝兘鎻愪緵涓�绉嶅畾鍒剁殑鏁版嵁搴撶鐞嗗伐鍏凤紝
閫氳繃绠＄悊搴旂敤绋嬪簭鏉ョ鐞嗘暟鎹?/p>
搴撳強鍏惰澶囷紝瀵圭敤鎴锋潵璇存棤鐤戞槸鏈�鐞嗘兂鐨勩�?/p>
Visual Basic
浣滀负涓�绉嶉潰鍚戝璞＄殑鍙鍖栫紪绋嬪伐鍏凤紝鍏锋湁绠�鍗曟槗瀛︼紝鐏垫椿鏂逛究鍜屾槗浜庢墿鍏?/p>
鐨勭壒鐐广�傝�屼笖
Microsoft
涓哄叾鎻愪緵浜嗕笌
SQL Server
閫氫俊鐨?/p>
API
鍑芥暟闆嗗強宸ュ叿闆嗭紝鍥犳瀹冭秺鏉?/p>
瓒婂鍦扮敤浣滃ぇ鍨嬪叕鍙告暟鎹拰瀹㈡埛鏈衡�旀湇鍔″櫒搴旂敤绋嬪簭鐨勫墠绔紝
涓庡悗绔殑
Microsoft SQL Server
鐩哥粨鍚堬紝
VB
鑳藉鎻愪緵涓�涓珮鎬ц兘鐨勫鎴锋満鈥旀湇鍔″櫒鏂规銆?/p>
浜屻�?/p>
VB
璁块棶
SQL Server
鏁版嵁鐨勫父鐢ㄦ柟娉?/p>
浣跨敤
Visual Basic
浣滀负鍓嶇寮�鍙戣瑷�锛屼笌
SQL Server
鎺ュ彛鏈夊嚑绉嶅父鐢ㄧ殑鏂规硶锛屽嵆锛氼�?/p>
鈶犳暟鎹闂璞?/p>
/Jet
鈶′负
ODBC API
缂栫▼顎?/p>
鈶娇鐢?/p>
SQL Server
鐨?/p>
Visual Basic
搴?/p>
(VBSQL)
涓?/p>
DB
搴撶殑
API
缂栫▼顎?/p>
鈶?/p>
RDO
杩滅▼鏁版嵁瀵硅薄
(RemoteData Objects)
鈶?/p>
ADO
鏁版嵁瀵硅薄
(Active Data Objects)
1
銆佹暟鎹闂璞?/p>
/Jet
VB
鏀寔
Data Access Objects(DAOs)
鐨勫瓙闆嗐�?/p>
DAO
鐨勬柟娉曡櫧鐒朵笉鏄�ц兘鏈�濂界殑绠＄悊瀹㈡埛
鏈衡�旀湇鍔″櫒涔嬮棿鐨勫璇濇柟寮忥紝浣嗗畠鐨勭‘鏈夎澶氫紭鐐广�?/p>
DAO/Jet
鏄负浜嗗疄鐜颁粠
VB
璁块棶
Access
鏁版嵁搴撹�屽紑鍙戠殑绋嬪簭鎺ュ彛瀵硅薄銆備娇鐢?/p>
DAOs
璁块棶
SQL
Server
鐨勮繃绋嬪涓嬶細搴旂敤绋嬪簭鍑嗗濂?/p>
璇彞骞堕�佽嚦
Jet
锛?/p>
Jet
寮曟搸
(MASJT200.DLL)
浼樺寲鏌ヨ锛岃浇鍏ラ┍鍔ㄧ▼搴忕鐞嗗櫒骞朵笌涔嬮�氳锛岄┍
鍔ㄧ▼搴忕鐞嗗櫒
(ODBC.DLL)
閫氳繃璋冪敤椹卞姩鍣?/p>
(SQLSRVR.DLL)
鐨勫嚱鏁帮紝
瀹炵幇杩炴帴鍒版暟鎹簮锛?/p>
缈?/p>
璇戝苟鍚?/p>
SQL Server
鎻愪氦
SQL
璇彞涓旇繑鍥炵粨鏋溿�備笅闈㈡槸涓�涓敤
DAOs
璁块棶
SQL Server
鐨?/p>
VB
瀹炰緥銆?/p>
娉ㄩ噴锛?/p>
Form Declarations
顎?/p>
Dim mydb As Database
顎?/p>
Dim mydynaset As Dynaset
顎勵�?/p>
Private Sub Form_Load()
顎?/p>
Set
mydb
=
OpenDatabase("",
False,
False,
"ODBC;
DSN=Myserver;
WSID=LCL;
DA
TABASE = sales")
Set mydynaset = mydb CreateDynaset("Select*from Customers")
顎勵�?/p>
End Sub
顎?/p>
涓婅堪渚嬪瓙鏄互闈炵嫭鍗犮�侀潪鍙鏂瑰紡鎵撳紑
sales
鏁版嵁搴擄紝骞舵绱?/p>
Customers
琛ㄤ腑鐨勬墍鏈夊瓧
娈点�?/p>
OpenDatabase
鍑芥暟鐨勬渶鍚庝竴涓弬鏁版槸
ODBC
杩炴帴瀛楃涓插弬鏁帮紝
瀹冩寚鏄庝簡
Microsoft Access
杩炴帴鍒?/p>
SQL
Server
鎵�闇�瑕佺煡閬撶殑涓�浜涘唴瀹广�傚叾涓�?/p>
DSN
鈥濅负鏁版嵁婧愬悕锛?/p>
鈥?/p>
WSID
鈥濅负宸ヤ綔绔?/p>
鍚嶏紝
鈥?/p>
DATABASE
鈥濅负鎵�瑕佽闂殑鏁版嵁搴撳悕銆傤�?/p>
2
銆佸埄鐢?/p>
ODBC API
缂栫▼顎?/p>