I'm running Lazarus 0.9.26 under windows XP pro SP3.

I know that in a machine named japi29 in the internal netword there is Posgres installed.

When I open PgAdmin postgres client in my machine I see for databases. The database that I want to access is name Conversor.

Okay. I create a new project and add a TPQConnection and type "Conversor"(without quotes) in the DataBaseName property, I type "japi29"(without quotes) in the hostname property. 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

(this is a translation of the message. it was written in portuguese here in my machine)

After click OK, I receive tehe message:

Cannot load PosgreSQLclient. Is it installed? (libpq.dll)

Well... What do I do to access PostGres databases?

Please. May someone help me?

Greetings from Sao Paulo - Brazil

Ricardo

Maybe need copy PostGre libary (files) to your working folder or your Lazarus folder, like pqsql.dll, libeay32.dll and another dll popup on error.

2009/3/19 Ar? Ricardo Ody

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.lazarus.freepascal.org/pipermail/lazarus/attachments/20090320/17950198/attachment.html

I search the whole lazarus directory and can't
find libeay32.dll(I found a reference in the openssl unit). I search the whole lazarus directory and can't
find pqsql.dll. Not in disc, nor a reference in some module. :'(

[ ]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.lazarus.freepascal.org/pipermail/lazarus/attachments/20090319/01687139/attachment.html

Did you move and of the installed postgre dlls to a different place ? If so, restrore them to the original location

Is the bin-directory where pgAdmin is located part of your system path ? If not, add it (my computer - properties - advanced - environment vars)

Check if you can run psql on a command prompt.

Marc

I've cpoied the dll's to the application
directory and everytinng's altright when change
the connected property to true. lets go straight
forward and see what will happen.

Is there a directory ohter that the application
one where I can copy teh PostGreSQL dll's?

Thank you

Ricardo

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.lazarus.freepascal.org/pipermail/lazarus/attachments/20090320/edff0bcd/attachment.html

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. -------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.lazarus.freepascal.org/pipermail/lazarus/attachments/20090320/26210347/attachment.html

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

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 :

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

That's the file "SSLEay.dll" Just copy it to the program's folder and try again at runtime... what happens?

2009/3/20 Ar? Ricardo Ody :

---------- Forwarded message ----------

I am running a Postgres 8.3 db and I find no problems to connect,query and post to it. However, I copied all the DLL's from the postgres bin directory(i.e. C:\Program Files\PostgreSQL\8.3\bin) into my application directory i.e. where the exe file resides. I also distribute these files in the exe directory when I deploy the application. I think the other directory to install them would be C:\WINDOWS\system32

HTH

Alex

I can guarantee that I copy the dll's from the directory you tell above. Late, someone told about the dll's that reside in the pgAdmin directories and I copy again from there...

As soon as I read your message I copied all dll's from the same directory you mention in your message. When I try to change the "connected" property of TPQConnection to true, the errors remain appearing. (In the property DataBaseName of the TPQConnection I put the name of database that I saw via pgAdmin. Is this right?)

Reading your message I can't have idea about what's the trouble in my environment and 'bout which other trials I should do.

Thanks

Ricardo

Try copying all the dll's in the postgres bin directory to C:\WINDOWS\system32
I have just created a test app with only TPQConnection filled in server name, database name, user and password and it connected without any hiccup.

The messages you get are typically when Lazarus(and your app) can't see the dll's.

I also noticed that you are not running the postgres server locally (i.e. localhost - 127.0.0.1). Have you edited postgres.conf on the server to allow connections from machines other than localhost? Stated differently: Have you told the postgres server to allow connections from network machines?

I done. And it seems to solve the trouble. Thank you. At least, when I change the connected property to true, no errors occur.

If I open the postgres databases with pgAdmin that runs in my machine, I suppose that the connections from the netword machines is allowed. Doesn't it?

pgAdmin show that my table is in the schema "public" and in a database named "Conversor". If the table I want to access is named DATATYPES how should I write the sql command to acess the table in a full browse?

select * from Conversor.DATATYPES?
select * from public.DATATYPES?

Or how?

Thanks for your efforts and patience.

Ricardo

Trouble with SQL statement solved. I must use quotes in the name of the table I want to open, because the name of the tables in PostGres are case sensitive.

Copy the PostGres DLLs from the bin directory to windows\system32 directory solve the trouble with access, as mr. Alex du Plessis, said.

Thanks to everyone that try to help.

Ricardo

That would seem so yes.

If you have set TPQConnection to connect to the database "Conversor", you don't need to qualify the tablename with the schema name(although that is allowed) because schema "public" is the default schema. When you create other schemas though and want to access the tables in the new schema then you do have to qualify the tablename with the schema name as you have done above.

Or how? Thanks for your efforts and patience.

My pleasure