Windows driver sometimes returns connection string with two consecutive semicolons

From: Eric Hill <Eric(dot)Hill(at)jmp(dot)com>
To: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Windows driver sometimes returns connection string with two consecutive semicolons
Date: 2014-12-19 21:37:39
Message-ID: dbea0b60b31b4cfca69e383f4627c6e2@MERCMBX41R.na.SAS.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hey,

We cache connection strings in our application so we can know if you already have a connection to a given database. We ran into this:

Windows, Postgres driver version 9.03.03.

When you use the ODBC administrator (which we invoke programmatically by passing the empty string as the third argument to SQLDriverConnect()) to connect to Postgres, driver 9.03.03, the connection string you get back (5th argument) has an extra semicolon after "C2=dd_", to wit:

BI=0;C2=dd_;;CX=1c20502bb;

However, if you call SQLDriverConnect() passing in that connection string with the extra semicolon as the third argument, a connection is made, and the connection string you get back in the 5th param does *not* have the extra semicolon:

BI=0;C2=dd_;CX=1c20502bb;

Yes, I can work around this, but why not stop spitting out the extra semicolon in the first case?

Thanks!

Eric

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Heikki Linnakangas 2014-12-22 16:50:01 Re: Windows driver sometimes returns connection string with two consecutive semicolons
Previous Message Gaurav Srivastava 2014-12-18 05:20:24 Re: High CPU shoot during poll retry