Re: [lazarus] Trouble with postgres
Alex du Plessis schreef: I certainly did - and in the library file directory one only finds the libpq.a file no libpq.dll That is a bit strange. Did previous version install a dll? Vincent _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Trouble with postgres
Vincent Snijders wrote: Alex du Plessis schreef: I certainly did - and in the library file directory one only finds the libpq.a file no libpq.dll That is a bit strange. Did previous version install a dll? Vincent _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives No, also a .a file. I tried a couple of previous versions and they all seem to have a similar problem. I also get no reply from the postgres mailing list when posing the same question/problem. _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Trouble with postgres
Alex du Plessis wrote: Vincent Snijders wrote: Alex du Plessis schreef: I certainly did - and in the library file directory one only finds the libpq.a file no libpq.dll That is a bit strange. Did previous version install a dll? Vincent _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives No, also a .a file. I tried a couple of previous versions and they all seem to have a similar problem. I also get no reply from the postgres mailing list when posing the same question/problem. _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives Vincent I did a re-install of postgres and now libpq is a .lib file. Any thoughts on what that file type might be? Seems the only workaround at the moment is to use odbc. With odbc at least I can get connected I still need to find out how to directly connect to postgres via sqldb and libpq. Any ideas on that matter will be greatly appreciated Thanx Alex _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Trouble with postgres
please search the libpq.dll on the web and download it, or you can copy the *.dll in your server such in C:\Program Files\PostgreSQL\8.1\bin\libpq.dll and other depend *.dll in same directory. Put the *.dll in C:\Windows\System32\ directory in client computer. may be can help you. On Feb 6, 2008 3:16 PM, Alex du Plessis [EMAIL PROTECTED] wrote: Vincent Snijders wrote: Alex du Plessis schreef: I certainly did - and in the library file directory one only finds the libpq.a file no libpq.dll That is a bit strange. Did previous version install a dll? Vincent _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives No, also a .a file. I tried a couple of previous versions and they all seem to have a similar problem. I also get no reply from the postgres mailing list when posing the same question/problem. _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Trouble with postgres
dayat wrote: please search the libpq.dll on the web and download it, or you can copy the *.dll in your server such in C:\Program Files\PostgreSQL\8.1\bin\libpq.dll and other depend *.dll in same directory. Put the *.dll in C:\Windows\System32\ directory in client computer. may be can help you. Or better extend your windows path to include C:\Program Files\PostgreSQL\8.1\bin\ copying dlls is usually a bad thing. You will loose track of versions. Also upgrading will be a pain when you forget to overwrite an older one. Marc _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Trouble with postgres
Vincent Snijders wrote: Alex du Plessis schreef: I did a re-install of postgres and now libpq is a .lib file. Any thoughts on what that file type might be? Seems the only workaround at the moment is to use odbc. With odbc at least I can get connected I still need to find out how to directly connect to postgres via sqldb and libpq. Any ideas on that matter will be greatly appreciated For your sake, I installed postgresql 8.3 and found libpq.dll in C:\Program Files\PostgreSQL\8.3\bin Vincent _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives Thank you Vincent. I then wonder what could have caused my installation to rename those files during installation. Thanx Alex _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Trouble with postgres
Alex du Plessis schreef: I did a re-install of postgres and now libpq is a .lib file. Any thoughts on what that file type might be? Seems the only workaround at the moment is to use odbc. With odbc at least I can get connected I still need to find out how to directly connect to postgres via sqldb and libpq. Any ideas on that matter will be greatly appreciated For your sake, I installed postgresql 8.3 and found libpq.dll in C:\Program Files\PostgreSQL\8.3\bin Vincent _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Trouble with postgres
Op woensdag 06-02-2008 om 10:16 uur [tijdzone +0200], schreef Alex du Plessis: Vincent Snijders wrote: Alex du Plessis schreef: I certainly did - and in the library file directory one only finds the libpq.a file no libpq.dll That is a bit strange. Did previous version install a dll? Vincent _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives No, also a .a file. I tried a couple of previous versions and they all seem to have a similar problem. I also get no reply from the postgres mailing list when posing the same question/problem. I've downloaded postgres for windows, and it does contain the libpq.dll file. You'll have probably done something wrong. (Maybe the installer doesn't install this client by default, and you didn't checked it?) http://wwwmaster.postgresql.org/download/mirrors-ftp?file=%2Fbinary%2Fv8.3.0%2Fwin32%2Fpostgresql-8.3.0-2-binaries-no-installer.zip Joost. _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
RE: [lazarus] Trouble with postgres
When I last worked with Postgres 8.2, I had to rename libpq.dll to pq.dll in order for it to work with FPC. The FPC postgres3 unit looks for pq, but on Windows this does not expand to libpq like on Linux and OS X. Postgres3 unit probably needs an $IFDEF for Windows. I copied libpq.dll to the client app folder, along with these .dll's: comerr32.dll libintl-2.dll libiconv-2.dll krb5_32.dll libeay32.dll ssleay32.dll See the OutKafe installer file (.iss) for how the DLL's are installed with OutKafe. Thanks. -Phil -Original Message- From: Alex du Plessis [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 06, 2008 6:01 AM To: lazarus@miraclec.com Subject: Re: [lazarus] Trouble with postgres Vincent Snijders wrote: Alex du Plessis schreef: I did a re-install of postgres and now libpq is a .lib file. Any thoughts on what that file type might be? Seems the only workaround at the moment is to use odbc. With odbc at least I can get connected I still need to find out how to directly connect to postgres via sqldb and libpq. Any ideas on that matter will be greatly appreciated For your sake, I installed postgresql 8.3 and found libpq.dll in C:\Program Files\PostgreSQL\8.3\bin Vincent _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives Thank you Vincent. I then wonder what could have caused my installation to rename those files during installation. Thanx Alex _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Trouble with postgres
Joost van order Sluis wrote: Op woensdag 06-02-2008 om 10:16 uur [tijdzone +0200], schreef Alex du Plessis: Vincent Snijders wrote: Alex du Plessis schreef: I certainly did - and in the library file directory one only finds the libpq.a file no libpq.dll That is a bit strange. Did previous version install a dll? Vincent _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives No, also a .a file. I tried a couple of previous versions and they all seem to have a similar problem. I also get no reply from the postgres mailing list when posing the same question/problem. I've downloaded postgres for windows, and it does contain the libpq.dll file. You'll have probably done something wrong. (Maybe the installer doesn't install this client by default, and you didn't checked it?) http://wwwmaster.postgresql.org/download/mirrors-ftp?file=%2Fbinary%2Fv8.3.0%2Fwin32%2Fpostgresql-8.3.0-2-binaries-no-installer.zip Joost. _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives Thank you everyone for all your input. It seems I am the only one experiencing this problem which means I probably have something nasty (or just unknown to me) lurking on my disk drive. These files redefined rename in some way or another. Aah well, I needed to do a reinstall of my whole system anyway. I will reinstall everything (from OS up) and report back as soon as I'm up and running again.(backups of course will be the order of the day). Thanx for your effort Alex du Plessis _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Trouble with postgres
Alex du Plessis schreef: I have recently installed lazarus 0.9.25 and postgres version 8.3 on a Windows XP box. sqldb used to connect flawlessly in my previous installations but suddenly I have no luck in connecting to the database.Even after updating fpc.cfg to point to all the correct directories. Lazarus keeps on insisting it cannot find libpq.dll.When I investigated I found a number of .lib files in the /lib subdirectory of postgres but a libpq.a (among a few other .a files). Did you install the postgress client libraries? I assume they include a .dll file. Vincent _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
Re: [lazarus] Trouble with postgres
Vincent Snijders wrote: Alex du Plessis schreef: I have recently installed lazarus 0.9.25 and postgres version 8.3 on a Windows XP box. sqldb used to connect flawlessly in my previous installations but suddenly I have no luck in connecting to the database.Even after updating fpc.cfg to point to all the correct directories. Lazarus keeps on insisting it cannot find libpq.dll.When I investigated I found a number of .lib files in the /lib subdirectory of postgres but a libpq.a (among a few other .a files). Did you install the postgress client libraries? I assume they include a .dll file. Vincent _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives I certainly did - and in the library file directory one only finds the libpq.a file no libpq.dll Alex _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives