""Vorweg:"" es kann keine definitive Liste geben, da immer neue OLE DB Provider entwickelt werden. In diesem FAQ Artikel sind allerdings die am häufigsten verwendeten mit einem Connection String Beispiel beschrieben.
Eine grössere Liste gibt es hier.
| Microsoft OLE DB Provider for SQL Server | Provider=SQLOLEDB;Data Source=serverName;Initial Catalog=databaseName; User ID=userName;Password=userPassword;" |
| Microsoft OLE DB Provider for ODBC | Provider=MSDASQL;DSN=dsnName;UID=userName;PWD=userPassword;" |
| OLE DB Provider for Microsoft Jet | Provider=Microsoft.Jet.OLEDB.4.0;Data Source=databaseName;User ID=userName;Password=userPassword;" |
| Microsoft OLE DB Provider for Oracle | Provider=MSDAORA;Data Source=serverName;User ID=userName;Password=userPassword;" |
| Microsoft OLE DB Provider for Internet Publishing | Provider=MSDAIPP.DSO;Data Source=ResourceURL;User ID=userName;Password=userPassword;" oder "URL=ResourceURL;User ID=userName;Password=userPassword;" |
| OLE DB Provider for Microsoft Active Directory Service (ADSI) | Provider=ADSDSOObject;User ID=userName;Password=userPassword;" |
| Microsoft OLE DB Provider for Microsoft Indexing Service | Provider=MSIDXS;Data Source=myCatalog;Locale Identifier=nnnn;" |
| OLE DB Provider for AS/400 and VSAM | Provider=SNAOLEDB;User ID=USERNAME;Password=password;LocalLU=LOCAL;RemoteLU=DATABASE;odeName=QPCSUP P;CCSID=37;PCCodePage=437" oder "Provider=SNAOLEDB;Data Source=REMLU;User ID=USERNAME;Password=password;ModeName=QPCSUPP" |
| OLE DB Provider for DB2 | Provider=DB2OLEDB;User ID=USERNAME;Password=password;LocalLU=LOCAL;RemoteLU=DATABASE;ModeName=QPCSU PP;CCSID=37;PcCodePage=437" |