Database connection string-Informix

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 ();