connection with postgresql

Questionsconnection with postgresql
Abhijit Sarkar asked 6 years ago

When I have connect php grid with postgresql,then show run time error.This error is —–

Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:xampplitehtdocswbcs_auditleaveincjqgrid_dist.php on line 47

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:xampplitehtdocswbcs_auditleaveincjqgrid_dist.php on line 47
Couldn't execute query. Access denied for user 'ODBC'@'localhost' (using password: NO) – select * from leave_trans where trim(idcode)='CS1993038' order by from_date desc LIMIT 1 OFFSET 0

Please help me to correct way and please give me one example file connection with postgresql. Thank you….

6 Answers
Abu Ghufran answered 6 years ago

Hello,

The postgres is supported in licensed version now.

Abu Ghufran answered 6 years ago

If you wish to evaluate first, you can email at [email protected] from your official email address.

David answered 5 years ago

Hi!

Appreciate if you can allow the me to evaluate the version that supports Postgresql.

Thank you.

David

Abu Ghufran answered 5 years ago

Latest free version support PGsql and it contains demo in demos/loading/db-pgsql.php
You can try downloading free version from http://phpgrid.org/download

Luca answered 5 years ago

Hi!
Postgres demo not warking in the latest release. I try with
demos/loading/db-layer-pgsql.php (not find demos/loading/db-pgsql.php) and don't work.
In the same file (db-layer-pgsql.php) I substitute postgres driver with mysql driver and it works! So I think that the ADODB layer is working but jqgrid_dist.php is not ready for postgresql.

Is it correct?

Thank you.

Luca

Abu Ghufran answered 5 years ago

Hello,

I am not sure whats going wrong on your side but i have re-tested and verified it's working with pgsql.
Please recheck your database config.

Your Answer

12 + 1 =

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating / 5. Vote count:

We are sorry that this post was not useful for you!

Let us improve this post!