[Lazarus] Trouble with PostGres access
Arí Ricardo Ody
ari.ody at japinfo.com.br
Fri Mar 20 17:24:47 CET 2009
I seek for SSLEasy.dll in Google and in my local
disk. I can't find it. I only found SSLEay.dll
May you help me?
[ ]
Ricardo
At 12:10 20/3/2009, you wrote:
>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
> >
>
>_______________________________________________
>Lazarus mailing list
>Lazarus at lazarus.freepascal.org
>http://www.lazarus.freepascal.org/mailman/listinfo/lazarus
More information about the Lazarus
mailing list