visual studio 2010 - Connect to informix database windows form application -
i trying figure out how connect ibm informix database. have been doing research , have found threads 5 years ago examples not working.
i have installed latest sdk ibm informix.
i have included ibm.data.informix.dll references in project.
i have included using ibm.data.informix;
i adding button , on click testing conenction. debug error "sql0035n file "c:\users\adam\documents\visual studio 2010\projects\test\test\msg\en_us\db2nmp.xml" cannot opened."
this file not exist , dont see anywhere in program files (x86)\ibm informix client sdk directory.
my on click code is
private void button1_click(object sender, eventargs e) { const string host = "192.168.obfuscated"; const string servicenum = "1525"; //port? const string server = "serverobfuscated"; const string database = "dbobfuscatedy"; const string user = "myusername"; const string password = "mypassword"; string connectionstring = "host=" + host + "; " + "service=" + servicenum + "; " + "server=" + server + "; " + "database=" + database + "; " + "user id=" + user + "; " + "password=" + password + "; "; ifxconnection conn = new ifxconnection(); conn.connectionstring = connectionstring; try { conn.open(); messagebox.show("made connection!"); } catch (ifxexception ex) { messagebox.show("problem connection attempt: " + ex.message); } }
anyone know doing wrong or current best way connect informix database?
thanks in advance.
check version of informix. need connector compatible version of informix database installed.
check this: http://www.ibm.com/developerworks/data/library/techarticle/dm-1007dsnetids/index.html
Comments
Post a Comment