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

    Error while connecting to VDB using DSN less connection

    teiiduser Newbie

      Hello,

       

      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";

       

      Thanks!