Albert Lens asked 6 years ago
Hello.
I have followed instructions and copied files. It is responding, after configuring MSSQL connection on the config.php file. But, now it is telling me the following error message:
Couldn’t execute query. SQLState: 42S02 Error Code: 208 Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]El nombre de objeto ‘customers’ no es válido. – select top (1+0) * FROM customers WHERE 1=1
I cannot connect to try to setup.
The url is : http://85.214.117.92/phpgrid/
Also, for the install page, it is giving a different error, which says:
Checking if config writable:
The configuration file is not writable.
Please copy config.sample.php to config.php and update the database configuration OR Try Manual Setup
That said install page is: http://85.214.117.92/phpgrid/install.php
Any help on how to begin trying with my own tables and fields, will be highly appreciated.
Thanks in advance.
Abu Ghufran Staff answered 6 years ago
The demo package of free version only support mysql database. Demos are not for sql server.
However you can manually set mssql configuration in any demo code and connect grid with sql server.
Here in this error, Perhaps, you need to specify complete db.customer etc.
$g->table = “SalesLT.Customer”;
Albert Lens answered 6 years ago
I see. If I buy the DEVELOPER LICENSE at $99, will it then be suitable for SQL SERCER, with Wizard, install and demos????
Abu Ghufran Staff answered 6 years ago
Currently demos on sql server are not ready. They are only available on Mysql.
This means to test demos and functionality, you need to setup mysql. And then change database configuration to use them with your sql server.
Thats our current limitation.
Albert Lens answered 6 years ago
I have installed MYSQL to see the examples, granted all permissions, installed database.sql, and finally I cannot access.
Your index.php page says: “Please check your database connection configuration. Access denied for user ‘root’@’localhost'”
I have checked that database griddemo exists, user root has ALL GRANTED PRIVILEGES, so I can not understand the message. Any help please???
