I have been able to setup and access my SQLite database in the IDE  database manager through an ado connection.  I then dragged the database table to my form, dropped a grid on the form, connected the grid to the dataset and the connection seems fine in the IDE.  When I run the program using the internal web server, the following code works and loads the data into the grid:

procedure TMainForm.LoadFromServer;
 
begin
  Database.DatabaseName:='P51setup';
  Database.LoadRows(Setup);
end;

This code works fine when I run the program using the internal server.  I  then imported the IDE database settings into the EWB Server and tried running the program using the EWB Server as opposed to the internal server and I get a message that says:


Error executing request "databases" (Access is denied.)  Line 6054


Any thoughts on what I am doing wrong?

<< Error executing request "databases" (Access is denied.)  Line 6054 >>

This is a CORS issue.  Just make sure to go into the Content section of the Server Configuration dialog for the EWB Web Server, and make sure that the Enable Cross-Origin Resource Sharing setting is enabled:

https://www.elevatesoft.com/manual?action=viewtopic&id=ewb2&topic=Configuring_Server

Tim Young
Elevate Software
www.elevatesoft.com

Tim, thank you. Having run across that issue before, I had checked to make sure I Enabled the CORS setting and it was enabled.  To be sure, I just unchecked it, rechecked it, then ran the program and am still getting the same error?  Is there something else I should check?


Tim Young [Elevate Software] wrote:


<< Error executing request "databases" (Access is denied.)  Line 6054 >>

This is a CORS issue.  Just make sure to go into the Content section of the Server Configuration dialog for the EWB Web Server, and make sure that the Enable Cross-Origin Resource Sharing setting is enabled:

https://www.elevatesoft.com/manual?action=viewtopic&id=ewb2&topic=Configuring_Server

Tim Young
Elevate Software
www.elevatesoft.com

DFL wrote:

>   Is there something else I should check?

Look at the browser debug info, and the network traffic. That may give clues as to what is going on.

Will do, thanks!



'Matthew Jones" wrote:

DFL wrote:

>   Is there something else I should check?

Look at the browser debug info, and the network traffic. That may give clues as to what is going on.