2 Replies Latest reply on Jul 18, 2013 4:15 PM by teiiduser

    Error while connecting to VDB using DSN less connection

    teiiduser Newbie



      I get this error while trying to connect to VDB using  a "DSN less" connection.


      ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.


      when I create a DSN, I am able to successfully connect and query the VDB. I am coding in C sharp.


      this works==>


      OdbcConnection Conn = new System.Data.Odbc.OdbcConnection("DSN=DSN_NAME_32;UID=user;PWD=user;");



      this does not work ==>


      OdbcConnection Conn = new System.Data.Odbc.OdbcConnection();



      Conn.ConnectionString =


      "ODBC;DRIVER={PostgreSQL Unicode};DATABASE=myVDBName;SERVER=my.server.com;PORT=35432;Uid=myUid;Pwd=myPwd";