DSN ModeThe DSN contains ODBC Driver do Microsoft Access (*. mdb)
Microsoft Access Driver(*. Mdb)
Microsoft Access-Treiber (*. mdb) ODBCJT32.DLL
Microsoft ODBC for OracleMSORCL32.DLL
SQL ServerSQLSRV32.DLL
Oracle in OraHome92Odbc32.dll
DSN Less Mode1. The default value of ADO in ODBC mode is MSDASQL. In addition, MSIDXS and ADSDSOObject Oracle
"Provider = MSDASQL; DRIVER = {Microsoft ODBC for ORACLE}; UID = User; PWD = Password; Server = Your_TNSNames_Alias" Access "Provider = MSDASQL; DRIVER = {Microsoft Access Driver (*. mdb)}; DBQ = zjgadb/zjsjdb. mdb; DefaultDir =; "MS SQLServer
"Provider = MSDASQL; Driver = {SQL Server}; Server = localhost; User ID = sa; Password = sa; Data Source = zcps" "Provider = MSDASQL; driver = {SQL Server}; Server = localhost; Uid = sa; Pwd = sa; Database = zcps "2 OLE DB mode the OLE Provider provided by ADO2.0/2.1: Oracle:
MSDAORA (ole db Provider for Oracle)
"Provider = msdaora; Data Source = MyOracleDB; User Id = UserName; Password = asdasd;" (MS Provider)
"Provider = OraOLEDB. Oracle; Data Source = MyOracleDB; User Id = Username; Password = asdasd;" (Oracle) Access:
Microsoft. Jet. OLEDB.3.51 (ole db Provider for Microsoft Jet (for ACCESS ))
"Provider = Microsoft. Jet. OLEDB.4.0; Data Source =/somepath/mydb. mdb; User Id = admin; Password =;" MS SQLServer:
SQLOLEDB (Microsoft SQL Server OLE DB Provider)
"Provider = sqloledb; Data Source = Aron1; Initial Catalog = pubs; User Id = sa; Password = asdasd ;"
Trackback: http://tb.blog.csdn.net/TrackBack.aspx? PostId = 496947
