install-demo-first-steps-with-free-version-sqlserver-error-because-of-table-customers

Questionsinstall-demo-first-steps-with-free-version-sqlserver-error-because-of-table-customers
Albert Lens asked 5 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.

4 Answers
Abu Ghufran Staff answered 5 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”;

_________________________
Abu Ghufran - Dev Team
Grid 4 PHP Framework
 
Albert Lens answered 5 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 5 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.

_________________________
Abu Ghufran - Dev Team
Grid 4 PHP Framework
 
Albert Lens answered 5 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???

Your Answer

17 + 1 =

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?