Page 2 of 2
Re: POSTGREQL Problem
Posted: Sat Oct 10, 2009 5:17 pm
by sudip
Hello Angel,
apais wrote:
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
Re: POSTGREQL Problem
Posted: Mon Oct 19, 2009 8:06 am
by 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
Re: POSTGREQL Problem
Posted: Mon Oct 19, 2009 1:11 pm
by Roberto Lopez
sudip wrote: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.
Re: POSTGREQL Problem
Posted: Tue Oct 20, 2009 1:08 pm
by 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
Re: POSTGREQL Problem
Posted: Wed Oct 28, 2009 3:41 pm
by 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
Re: POSTGREQL Problem
Posted: Wed Oct 28, 2009 4:12 pm
by 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