connection with postgresql

Questionsconnection with postgresql
Abhijit Sarkar asked 7 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 7 years ago

Hello,

The postgres is supported in licensed version now.

Abu Ghufran answered 7 years ago

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

David answered 6 years ago

Hi!

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

Thank you.

David

Abu Ghufran answered 6 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 6 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 6 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

9 + 3 =

Login with your Social Id:

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 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

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

Let us improve this post!

Tell us how we can improve this post?