[Lazarus] Trouble with PostGres access

[Andrew Brunner]

The only feedback I have is that it appears that the windows client
postgresql library requires SSL sockets.  And it uses SSLEasy.  I
recall that under windows, all you need to do is get the SSLEasy.DLL
into the program's directory and then, the Client component should be
able to find that DLL.


2009/3/20 Arí Ricardo Ody <ari.ody at japinfo.com.br>:
> I've copied the dll's from pgAdmin directory to my application one.
>
> I add transaction, query, datasource, DBNavigator and DBGrid.
>
> When I change the property Connected of PQConnection to true the msg:
>
> It wasn't possible to find(or locate) the ordinal number 2821 in the
> dynamic link library LIBEAY32.dll
> (I'm sure that I've copied this library form pgAdmin to my
> application directory)
>
> When I click OK I receive the msg:
>
> Cannot load PostGreSQL client. Is it installed?(libpq.dll)
> (again I'm sure that I've copied this library from pgAdmin to my
> application directory.
>
> I put: japi29 in the hostname, Conversor in DataBaseName, the
> username and the password in the PQConnection
>
> I'm trying to browse a table named DATATYPES. I put the SQL command
> below in the SQLQuery sql statement:
>
> select * from Conversor.DATATYPES;
>
> When I run the application the DBNavigator and the DBGrid appear
> empty. And no errors are reported. But if I try to manually change
> the PQCOnnection I receive the errors explained above>
>
> Some aditional suggerstion(s)?
>
> Cheers
>
> Ricardo
>
> P.S.: If someone would like to try I send my project
>
> At 11:09 20/3/2009, you wrote:
>> > When I choose true in the Connected property I receive first the message:
>>
>> > It wasn't possible to locate  the ordinal number 2824 in the
>> dynamic link library LIBEAY32.dll
>>
>>For some reason, the DLLs from OpenSSL.org do not work with libpq.
>>
>>Use the DLLs that came with PostgreSQL or pgAdmin and it should work fine.
>>
>>As others already suggested, you can put one of those folders
>>(containing libpq, libeay32, ssleay32, etc) on your search path, or
>>copy those files to your program folder.
>>_______________________________________________
>>Lazarus mailing list
>>Lazarus at lazarus.freepascal.org
>>http://www.lazarus.freepascal.org/mailman/listinfo/lazarus
>
>
> _______________________________________________
> Lazarus mailing list
> Lazarus at lazarus.freepascal.org
> http://www.lazarus.freepascal.org/mailman/listinfo/lazarus
>