Abhijit Sarkar asked 11 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….
Abu Ghufran answered 11 years ago
If you wish to evaluate first, you can email at [email protected] from your official email address.
David answered 10 years ago
Hi!
Appreciate if you can allow the me to evaluate the version that supports Postgresql.
Thank you.
David
Abu Ghufran answered 10 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 10 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 10 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.
