POSTGREQL Problem

[sudip]

Hello Angel,

I haven't used postgresql with hmg yet sorry.

Thank you.
And I must say Postgresql is a very good RDBMS (as per different posts I have read)
And IMHO, if we can use it with HMG, it will be Great
With best regards.
Sudip

[sudip]

Hello All,

I am able to go one step forward

I compiled project with HMG 3.0.0. Copied all .dll files from Postgresql bin folder to the project folder. Then copied libMysql.dll folder (God knows why ), as it requires it (yes, but I don't know why). Finally program runs But, I can't connect

I put "localhost" and "localhost:5432" in Host name, "postgres" in user name and put my password in password. But, still I can't connect it.

There must be something which I am missing. Rathi, have you tested it?

With best regards.

Sudip

[Roberto Lopez]

Hello All,

I am able to go one step forward

I compiled project with HMG 3.0.0. Copied all .dll files from Postgresql bin folder to the project folder. Then copied libMysql.dll folder (God knows why ), as it requires it (yes, but I don't know why). Finally program runs But, I can't connect

I put "localhost" and "localhost:5432" in Host name, "postgres" in user name and put my password in password. But, still I can't connect it.

There must be something which I am missing. Rathi, have you tested it?

With best regards.

Sudip

mmm... strange. I've tested all samples, you should not need libmysql.dll.

I've simple installed Postgre latest version, copied the required dlls and it is working.

Regards,

Roberto.

[sudip]

Hello Master Roberto,

Thanks a lot

I must check my codes. I might have done some careless mistakes

If you find time is it possible for you to compile test codes from download/file.php?id=401

(Same code I tested with MySql and SQLite with minor differences)

With best regards.

Sudip

[sudip]

Hello Friends,
Finally I can create a console based app from Harbour sample with HMG IDE (this time no warning from NAV ), which connects and works with PostgreSql!!!
Believe me, this is a real vast DBMS!!! I like it There are many things to learn for PostgreSql.
Please open PGAdmin III from Start Menu -> Programs -> PostGreSQL 8.4 and browse different objects!!!
I must be very serious to work with it. Thanks to all friends
With best regards.
Sudip

[apais]

If you want total and easy control over postgresql try this:

http://www.turnkeylinux.org/postgresql

You can install it on a virtual machine, on a dedicated one or in the cloud.

Very easy to add or delete users and permisions, program backups and thousand things more.

HTH
Angel