Thread: what is best way to get the latest libpq version.

Is

http://www.postgresql.org/ftp/odbc/versions/snapshots/

where I need to be?

Is psqlodbclibpq-08 01 0001.zip the file to look at?

Do I have to compile it or is the a dll in there as well?

I appreciate the help thanks.

Joel Fradkin

I compiled the snapshot version ok in visual studio 6 version of C++ (couldn’t seem to figure out the .net configuration, but I am not a c++ guy).

I did get one warning

d:\joel\wazagua_src\psqlodbc\results.c(3063) : warning C4101: 'conn' : unreferenced local variable

Is this something I need worry about?

Also is that the most fixed code or do I need to get on a csv or something.

-----Original Message-----
From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Joel Fradkin
Sent: Wednesday, July 20, 2005 2:32 PM
To: pgsql-odbc@postgresql.org
Subject: [ODBC] what is best way to get the latest libpq version.

Is

http://www.postgresql.org/ftp/odbc/versions/snapshots/

where I need to be?

Is psqlodbclibpq-08 01 0001.zip the file to look at?

Do I have to compile it or is the a dll in there as well?

I appreciate the help thanks.

Joel Fradkin

Thanks for the off line suggestions. I did comment out the conn variable and got no warnings.

Will this lib work like the older 7.4 version ?

I currently have a sqlascii databse and the 7.4 will read French chars from that data base and display ok.

When I tried the 8.0.3 I had to convert to Unicode to get the French to display ok, but I found multiple oledb errors when several users got onto the system.

I had to switch back to the 7.4 drivers and SQLASCII data base because of the errors.

I can of course do the conversion again (takes aprx 12 hours to convert using my .net application, which reads from SQLASCII and writes to UNICODE).

I was not able to use either the 8.0.3 msi install (pre libpq) or the at the time beta not for production use libpq vewrsion without getting errors.

I will definitely try testing the UNICODE database with the current libpq more robustly to see if I can isolate what the issues were.

I had a tester working with a UNICODE database for a day with 8.0.3 msi install (pre libpq) driver and did not have errors, so I was disappointed finding when I tried in production it was returning errors.

I wanted to add I appreciate all the work everyone has been doing and hope I can get a more dependable solution worked out. At this moment the 7.4 drivers seem to lock up the IIS every now and then (I am guessing this is some kind of Unicode in ascii issue).

-----Original Message-----
From: Joel Fradkin [mailto:jfradkin@wazagua.com]
Sent: Wednesday, July 20, 2005 4:14 PM
To: 'Joel Fradkin'; pgsql-odbc@postgresql.org
Subject: RE: [ODBC] what is best way to get the latest libpq version.

I compiled the snapshot version ok in visual studio 6 version of C++ (couldn’t seem to figure out the .net configuration, but I am not a c++ guy).

I did get one warning

d:\joel\wazagua_src\psqlodbc\results.c(3063) : warning C4101: 'conn' : unreferenced local variable

Is this something I need worry about?

Also is that the most fixed code or do I need to get on a csv or something.

-----Original Message-----
From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Joel Fradkin
Sent: Wednesday, July 20, 2005 2:32 PM
To: pgsql-odbc@postgresql.org
Subject: [ODBC] what is best way to get the latest libpq version.

Is

http://www.postgresql.org/ftp/odbc/versions/snapshots/

where I need to be?

Is psqlodbclibpq-08 01 0001.zip the file to look at?

Do I have to compile it or is the a dll in there as well?

I appreciate the help thanks.

Joel Fradkin

OK I grabbed Connection, Qresult, Results, And convert off csv.

Does that get me up to date using the snapshot as the original source (also it converted to .net when I opened it and is compiling ok, so I must of mucky-mucked it up trying to create the project in .net).

-----Original Message-----
From: Dave Page [mailto:dpage@vale-housing.co.uk]
Sent: Thursday, July 21, 2005 3:20 AM
To: Joel Fradkin; pgsql-odbc@postgresql.org
Subject: RE: [ODBC] what is best way to get the latest libpq version.

 

---

From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Joel Fradkin
Sent: 20 July 2005 21:14
To: 'Joel Fradkin'; pgsql-odbc@postgresql.org
Subject: Re: [ODBC] what is best way to get the latest libpq version.

I compiled the snapshot version ok in visual studio 6 version of C++ (couldn’t seem to figure out the .net configuration, but I am not a c++ guy).

 

I did get one warning

d:\joel\wazagua_src\psqlodbc\results.c(3063) : warning C4101: 'conn' : unreferenced local variable

Is this something I need worry about?

 

Also is that the most fixed code or do I need to get on a csv or something. 

 

That warning is fixed in CVS already, but no, you don't need to worry about it. CVS is always the most up to date code, and does have some major memory leaks fixed which are in 08.01.0001.

/D 

On my freshly compiled libpq version, is debug=1 supposed to be working?

Any clue where I should look to see why I always get a catastrophic error when I enable it?

Catastrophic failure is returned from my connection object with a connection string of:

DRIVER={PostgreSQL};DATABASE=wazuni;SERVER=192.168.123.252;PORT=5432;UID=postgres;PWD=1brain;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=8190;Debug=1;CommLog=0;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0

Works ok without debug, but I am trying to isolate errors in my app.

-----Original Message-----
From: Dave Page [mailto:dpage@vale-housing.co.uk]
Sent: Thursday, July 21, 2005 9:24 AM
To: Joel Fradkin; pgsql-odbc@postgresql.org
Subject: RE: [ODBC] what is best way to get the latest libpq version.

 

---

From: Joel Fradkin [mailto:jfradkin@wazagua.com]
Sent: 21 July 2005 14:12
To: Dave Page; pgsql-odbc@postgresql.org
Subject: RE: [ODBC] what is best way to get the latest libpq version.

OK I grabbed Connection, Qresult, Results, And convert off csv.

Does that get me up to date using the snapshot as the original source (also it converted to .net when I opened it and is compiling ok, so I must of mucky-mucked it up trying to create the project in .net). 

 

Use a CVS client (I use TortoiseCVS) to keep up to date. It's the only way you know for sure you are up to date. Also, compile from the command line using the win32.mak makefile e.g. " nmake /f win32.mak ". Doing it in the GUI will be more tricky as you won't necessarily get the build settings right (even I didn't when I tried the other day). You may need to run vcvars32.bat to setup the VC++ environment. Finally, use VC++ 6 if you have it. .NET may make you dependent on newer versions of the runtime libraries that we haven't tested.

/D