OLE DB Datenquellen für DB2 (bereitgestellt von Microsoft)

5. Oktober 2015 von Centron GmbH

Für TCP/IP Verbindungen:

oConn.Open = "Provider=DB2OLEDB;" &_
             "Network Transport Library=TCPIP;" &_
             "Network Address=xxx.xxx.xxx.xxx;" & _
             "Initial Catalog=MyCatalog;" &_
             "Package Collection=MyPackageCollection;" &_
             "Default Schema=MySchema;" & _
             "User ID=MyUsername;" & _
             "Password=MyPassword"

oConn.Open = "Provider=DB2OLEDB;" &_

"Network Transport Library=TCPIP;" &_

"Network Address=xxx.xxx.xxx.xxx;" & _

"Initial Catalog=MyCatalog;" &_

"Package Collection=MyPackageCollection;" &_

"Default Schema=MySchema;" & _

"User ID=MyUsername;" & _

"Password=MyPassword"

For APPC connections:

oConn.Open = "Provider=DB2OLEDB;" &_
"APPC Local LU Alias=MyLocalLUAlias;" &_
             "APPC Remote LU Alias=MyRemoteLUAlias;" &_
             "Initial Catalog=MyCatalog;" &_
             "Package Collection=MyPackageCollection;" &_
             "Default Schema=MySchema;" & _
             "User ID=MyUsername;" & _
             "Password=MyPassword"