Thread: LIBPQXX on Windows

<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Hello,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">I need to get <span class="SpellE">LibPqxx</span> up and running on Windows. I have a <span
class="SpellE">pgSQL</span>client which works fine on Linux and I need to port the baby to Windows. 1<sup>st</sup>
challengewas getting a port of ‘<span class="SpellE">popt</span>’ library which I used to parse <span
class="SpellE">cmdline</span>options. Now I need to get <span class="SpellE">libpqxx</span> up and running. Does anyone
haveany experience in accomplishing <span class="GramE">this.</span> If not, what do other people do to get around
<spanclass="GramE">this.</span> Is there a more portable <span class="SpellE">pgsql</span>/C++ interface? I have MSVC
6.0and can’t seem to get the <span class="SpellE">makefile</span> to work. Is there a binary I can just link with? Also
wherecan I get the pgsql.dll which is <span class="GramE">required.</span></span></font><p class="MsoNormal"><font
face="Arial"size="2"><span style="font-size:10.0pt;
 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Any help would be appreciated… If I get no answer then I am busted on the Windows platform and I
willrue the day I chose to go with <span class="SpellE">libpqxx</span>. Is there <span class="GramE">a</span> ODBC
driverfor <span class="SpellE">postgres</span> on Windows? Maybe I can go that route? If so, my Linux implementation
willneed some major tweaking…</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Please help… I am hoping to have this solved by next week. I was really hoping to get the
applicationto start building this week, but this is becoming a bit of a <span
class="SpellE">hinderance</span>…</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Thank you,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">Michael Uman</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">Sr. Software Engineer</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">Softwaremagic.net</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial"><a href="http://www.softwaremagic.net/">http://www.softwaremagic.net</a></span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt;
 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial"> </span></font></div>

-----Oorspronkelijk bericht-----
Van: pgsql-interfaces-owner@postgresql.org [mailto:pgsql-interfaces-owner@postgresql.org]Namens Michael Uman
Verzonden: donderdag 13 februari 2003 9:57
Aan: pgsql-interfaces@postgresql.org
Onderwerp: [INTERFACES] LIBPQXX on Windows

Hello,

 

I need to get LibPqxx up and running on Windows. I have a pgSQL client which works fine on Linux and I need to port the baby to Windows. 1^st challenge was getting a port of ‘popt’ library which I used to parse cmdline options. Now I need to get libpqxx up and running. Does anyone have any experience in accomplishing this. If not, what do other people do to get around this. Is there a more portable pgsql/C++ interface? I have MSVC 6.0 and can’t seem to get the makefile to work. Is there a binary I can just link with? Also where can I get the pgsql.dll which is required.

 

Any help would be appreciated… If I get no answer then I am busted on the Windows platform and I will rue the day I chose to go with libpqxx. Is there a ODBC driver for postgres on Windows? Maybe I can go that route? If so, my Linux implementation will need some major tweaking…

 

Please help… I am hoping to have this solved by next week. I was really hoping to get the application to start building this week, but this is becoming a bit of a hinderance…

 

Thank you,

Michael Uman

Sr. Software Engineer

Softwaremagic.net

 

http://www.softwaremagic.net

 

 

On Fri, Feb 14, 2003 at 08:26:03AM +0100, Ries van Twisk wrote:
> 
> I also wanted a LibPqxx on my windows system. At the time I made the
> decission I took the short route and used ODBC which worked fine when using
> Acces, Omnis Studio and the Qt libraries.

Unfortunately I can't maintain the Windows/MSVC++ project setup
myself, so this part is typically a little behind the times.  There
is now some more documentation in the README for building on a
Windows system; basicallly, doing it from scratch should involve
little more than:
- creating a project with all source files (src/*.cxx) in it- telling the compiler where to find the postgres includes
and libpq- editing include/pqxx/config.h, and if necessary, defining   NO_PARTIAL_CLASS_TEMPLATE_SPECIALISATION to work
arounda  limitation in Microsoft's compiler- clicking "build"
 

Several people have done this already, and some have offered help
on getting it into the project (especially Clinton James who produced
the files in the win32 directory) but so far nobody has stepped
forward with a serious commitment to maintain this side of the project.


Jeroen