Database connection string-Informix
Odbc dsn -- Informix 3.30 ODBC driver
// Odbc dsn -- Informix 3.30 ODBC driver Using system. Data. ODBC; Odbcconnection conn = new odbcconnection (); Conn. connectionstring = "DSN = dsnname;" + "Host = hostname;" + "Server = servername;" + "Service = servername;" + "Protocol = olsoctcp;" + "Database = databasename;" + "Uid = username;" + "Pwd = secret ;"; Conn. open (); |
ODBC without DSN -- Informix 3.30 ODBC driver
// ODBC without DSN -- Informix 3.30 ODBC driver Using system. Data. ODBC; Odbcconnection conn = new odbcconnection (); Conn. connectionstring = "DSN =" ";" + "Driver = {Informix 3.30 32 bit};" + "Host = hostname;" + "Server = servername;" + "Service = servername;" + "Protocol = olsoctcp;" + "Database = databasename;" + "Uid = username;" + "Pwd = secret ;"; Conn. open (); |
ODBC Informix-cli 2.5 ODBC driver
// ODBC Informix-cli 2.5 ODBC driver Using system. Data. ODBC; Odbcconnection conn = new odbcconnection (); Conn. connectionstring = "Driver = {Informix-cli 2.5 (32 bit)};" + "Server = servername;" + "Database = databasename;" + "Uid = username;" + "Pwd = secret ;"; Conn. open (); |
Oledb -- IBM Informix oledb provider
// Oledb -- IBM Informix oledb provider Using system. Data. oledb; Oledbconnection conn = new oledbconnection (); Conn. connectionstring = "Driver = ifxoledbc;" + "Data Source = databasename @ servername;" + "User ID = username;" + "Password = secret ;"; "Persist Security info = true ;"; Conn. open (); |