Verbindungstyp zur Datenbank

• ADO Recordset URL
• Data Link File (UDL)
• Microsoft Remote
• Microsoft DataShape Provider
• .NET Data Provider
• ODBC mit DSN
• ODBC ohne DSN
• OLE DB Provider
• Remote Data Services (RDS)

OLE DB .NET Datenquellen (Data Provider) (System.Data.OleDb)

Die Datenquellen (Data Provider) des Microsoft .NET Frameworks für OLE DB erlauben Ihnen die Verwendung nativer OLE DB Datenquellen OLE DB wie etwa Microsoft.JET.OLEDB.4.0 durch COM interop, um den Datenzugriff zu ermöglichen.

IBM AS/400 OLE DB Provider

' VB.NET 
Imports System.Data.OleDb 
... 
Dim oOleDbConnection As OleDbConnection 
Dim sConnString As String = _ 
    "Provider=IBMDA400.DataSource.1;" & _ 
    "Data source=myAS400DbName;" & _ 
    "User Id=myUsername;" & _ 
    "Password=myPassword" 
oOleDbConnection = New OleDb.OleDbConnection(sConnString) 
oOleDbConnection.Open() 

JET OLE DB Provider

' VB.NET 
Imports System.Data.OleDb 
... 
Dim oOleDbConnection As OleDbConnection 
Dim sConnString As String = _ 
    "Provider=Microsoft.Jet.OLEDB.4.0;" & _ 
    "Data Source=C:\myPath\myJet.mdb;" & _ 
    "User ID=Admin;" & _ 
    "Password=" 
oOleDbConnection = New OleDb.OleDbConnection(sConnString) 
oOleDbConnection.Open() 

Oracle OLE DB Provider

' VB.NET 
Imports System.Data.OleDb 
... 
Dim oOleDbConnection As OleDbConnection 
Dim sConnString As String = _ 
    "Provider=OraOLEDB.Oracle;" & _ 
    "Data Source=MyOracleDB;" & _ 
    "User ID=myUsername;" & _ 
    "Password=myPassword" 
oOleDbConnection = New OleDb.OleDbConnection(sConnString) 
oOleDbConnection.Open() 

SQL Server OLE DB Provider

' VB.NET 
Imports System.Data.OleDb 
... 
Dim oOleDbConnection As OleDbConnection 
Dim sConnString As String = _ 
    "Provider=sqloledb;" & _ 
    "Data Source=myServerName;" & _ 
    "Initial Catalog=myDatabaseName;" & _ 
    "User Id=myUsername;" & _ 
    "Password=myPassword" 
oOleDbConnection = New OleDb.OleDbConnection(sConnString) 
oOleDbConnection.Open() 

Sybase ASE OLE DB Provider

' VB.NET 
Imports System.Data.OleDb 
... 
Dim oOleDbConnection As OleDbConnection 
Dim sConnString As String = _ 
    "Provider=Sybase ASE OLE DB Provider;" & _ 
    "Data Source=MyDataSourceName;" & _ 
    "Server Name=MyServerName;" & _ 
    "Database=MyDatabaseName;" & _ 
    "User ID=myUsername;" & _ 
    "Password=myPassword" 
oOleDbConnection = New OleDb.OleDbConnection(sConnString) 
oOleDbConnection.Open()

Für weitere Informationen besuchen Sie bitte folgende Seiten:
OleDbConnection Class und .NET Datenquellen (Data Provider)s.

Um sich Microsofts Knowledgebase-Einträge zu OleDbConnection anzusehen, klicken Sie hier.