ADO访问数据库整理

DSN方式

DSN里面都是ODBC驱动

Driver do Microsoft Access (*.mdb)
Microsoft Access Driver (*.mdb)
Microsoft Access-Treiber (*.mdb) ODBCJT32.DLL

Microsoft ODBC for Oracle MSORCL32.DLL

SQL Server SQLSRV32.DLL

Oracle in OraHome92 odbc32.dll

DSN Less方式

1 ODBC方式

ADO 缺省值是MSDASQL，此外还有MSIDXS和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方式

ADO2.0/2.1提供的OLE Provider:

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;"