ODBC-Treiber für Informix

5. Oktober 2015 von Centron GmbH

Falls Sie den INFORMIX 3.30 ODBC-Treiber benutzen:

oConn.Open "Dsn='';" & _
           "Driver={INFORMIX 3.30 32 BIT};" & _
           "Host=myHostname;" & _
           "Server=myServerName;" & _
           "Service=myServiceName;" & _
           "Protocol=olsoctcp;" & _
           "Database=myDbName;" & _
           "UID=myUsername;" & _
           "PWD=myPassword" & _

oConn.Open "Dsn='';" & _

"Driver={INFORMIX 3.30 32 BIT};" & _

"Host=myHostname;" & _

"Server=myServerName;" & _

"Service=myServiceName;" & _

"Protocol=olsoctcp;" & _

"Database=myDbName;" & _

"UID=myUsername;" & _

"PWD=myPassword" & _

oder:

oConn.Open "Dsn=myDsn;" & _
           "Host=myHostname;" & _
           "Server=myServerName;" & _
           "Service=myServiceName;" & _
           "Protocol=onsoctcp;" & _
           "Database=myDbName;" & _
           "Uid=myUsername;" & _
           "Pwd=myPassword"

oConn.Open "Dsn=myDsn;" & _

"Host=myHostname;" & _

"Server=myServerName;" & _

"Service=myServiceName;" & _

"Protocol=onsoctcp;" & _

"Database=myDbName;" & _

"Uid=myUsername;" & _

"Pwd=myPassword"

Falls Sie den INFORMIX-CLI 2.5 ODBC-Treiber benutzen:

oConn.Open "Driver={Informix-CLI 2.5 (32 Bit)};" & _
           "Server=myServerName;" & _
           "Database=myDbName;" & _
           "Uid=myUsername;" & _
           "Pwd=myPassword" & _

oConn.Open "Driver={Informix-CLI 2.5 (32 Bit)};" & _

"Server=myServerName;" & _

"Database=myDbName;" & _

"Uid=myUsername;" & _

"Pwd=myPassword" & _