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 :D
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 :o ), 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 :o ), 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!!! :D
Believe me, this is a real vast DBMS!!! :o 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