SEO

#1 (**permalink**) 04-16-2008, 01:21 AM

I think it's fairly safe to say that the new libpq version of psqlODBC
is more stable than the previous release versions of the driver, and
also now offers more features such as SSL, Kerberos authentication (has
anyone tried this yet?), pgpass files and so on.

In light of this, I think the libpq version should now take over as the
official driver, and lose the 'libpq' suffix that was added for testing.

If anyone has any strong objections, please shriek soon!!

Regards, Dave.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

#2 (**permalink**) 04-16-2008, 01:21 AM

* Dave Page (dpage@vale-housing.co.uk) wrote:
> I think it's fairly safe to say that the new libpq version of psqlODBC
> is more stable than the previous release versions of the driver, and
> also now offers more features such as SSL, Kerberos authentication (has
> anyone tried this yet?), pgpass files and so on.
>
> In light of this, I think the libpq version should now take over as the
> official driver, and lose the 'libpq' suffix that was added for testing.
>
> If anyone has any strong objections, please shriek soon!!

I was playing around with psqlodbclibpq-08_01_0003.zip and seemed to be
having problems in Access with it. I'd get errors about a failed
command happening inside a transaction and that all commands till the
end of the transaction would be ignored. Is there a more recent version
of the driver? This is against an 8.0.3 database.

Never saw this with the older driver. I got it right off the bat (when
getting the table listing in Access to link to) when I had
'declare/fetch' on (which I really need...). When I turned that off I
was able to get past the table list and actually link to a table but
when I tried to open the table that's what I got. :/

I'd really like to get these issues resolved, of course...

Thanks,

Stephen

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFDBlkdrzgMPqB3kigRAit1AJ45z1Aj1dIxgKNfHEWEY5/FjsvXgQCfUio3
0pvTMRF4heTstXh5BoxCdIQ=
=VyCl
-----END PGP SIGNATURE-----

#3 (**permalink**) 04-16-2008, 01:21 AM

We are using psqlODBC 8.0.0102 and it is very stable to older versions...
New driver (libpq) seems stable, but so slow (why?) to ODBC 08.00.0102. I
can't find any reason for this. Can anyone help me? New driver has more
futures (SSL and so on), so we'll happy if we can use it.

Here is my system config:

MS WIN XP SP2 +
MS .NET Framework 1.1 SP1 +
MS VS 2003 +
psqlodbclibpq-08_01_0003

Database server PostgreSQL 8.0.3 on Fedora 4

My connection string (DSN less):
DRIVER={PostgreSQL};SERVER=x;DATABASE=x;UID=x;PASS WORD=x;PORT=5432;
A0=0;A1=6.4;A2=0;A3=0;A4=0;A5=0;A6=;A7=100;A8=4096 ;A9=0B0=254;B1=8190;B2=0;B3=0;B4=1;B5=1;B6=0;B7=1; B8=0;B9=1;C0=0;C1=0;C2=dd_

----- Original Message -----
From: "Dave Page" <dpage@vale-housing.co.uk>
To: <pgsql-odbc@postgresql.org>
Sent: Friday, August 19, 2005 9:40 PM
Subject: [ODBC] "Official" version

>I think it's fairly safe to say that the new libpq version of psqlODBC
> is more stable than the previous release versions of the driver, and
> also now offers more features such as SSL, Kerberos authentication (has
> anyone tried this yet?), pgpass files and so on.
>
> In light of this, I think the libpq version should now take over as the
> official driver, and lose the 'libpq' suffix that was added for testing.
>
> If anyone has any strong objections, please shriek soon!!
>
> Regards, Dave.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode