Hi,

I have my app (app.html and app.js files) on a Linux web server A and an EDB database running on a Windows box on server B.

I have configured the database from within the ewebserver running on server B, and, from within the ewebserver I can connect to the database (locally), via a remote 127.0.0.1 session and can see the tables and preview the data in them.

My "Databases Resource Name" is the default "databases" as displayed on the content tab of the ewebserver configuration page.

From within my app, when I try and call DBMain.LoadRows I am getting the error:

"Unable to find database: databasename" (where databasename is the name of my database as configured in the ewserver on server B.

I think the issue is within the BaseURL property of my global database DBMain, which I've set as:
\\serverB\databases ?

The DatabaseName property of DBMain is also set the same as the database that's configured in the ewebserver on Server B

Both servers are on the same local network.

Any ideas as to what I'm doing incorrectly?

Thanks

Richard

Richard,

<< I have my app (app.html and app.js files) on a Linux web server A and an EDB database running on a Windows box on server B. >>

Do some reading on CORS:

https://developer.mozilla.org/en-US/docs/Web/HTTP/Access_control_CORS

and then read this section of the manual:

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

under "Content", specifically this:

Enable Cross-Origin Resource Sharing

That will allow you to fix this issue.

Tim Young
Elevate Software
www.elevatesoft.com

<< Do some reading on CORS:

https://developer.mozilla.org/en-US/docs/Web/HTTP/Access_control_CORS

and then read this section of the manual:

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

under "Content", specifically this:

Enable Cross-Origin Resource Sharing

That will allow you to fix this issue.>>

Ah, yes, I had read about that before. I adjusted that and still get the same error.

Should the BaseUrl of the Database in EWB be:

ServerB/databases

In my case?

Richard

Richard,

<< Should the BaseUrl of the Database in EWB be:

ServerB/databases

In my case? >>

The base URL for server B should be something like this:

https://<domain or IP address of server B>/databases

(if you're only doing testing, then http:// will work also, but don't deploy servers that are accessible via HTTP anymore)

Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

<< The base URL for server B should be something like this:

https://<domain or IP address of server B>/databases

(if you're only doing testing, then http:// will work also, but don't deploy servers that are accessible via HTTP anymore) >>

Thanks Tim, definitely getting further now.
Now, I am getting a slight delay (in the browser) and then I'm getting:

"Uncaught error: Dataset load response error (Cannot connect to server)"?

I've double checked, and the "Cross-Origin Resource Sharing" is on.

I've tried with both running the app in the IDE, and after deploying ti to Server A.
I've also checked, and their is no firewall on Server B (the Server running both EWB server and EDB server)
I can also ping server B from the machine that's running the client.

Any further thoughts?

Thanks

Richard

Richard,

<< Thanks Tim, definitely getting further now.
Now, I am getting a slight delay (in the browser) and then I'm getting:

"Uncaught error: Dataset load response error (Cannot connect to server)"? >>

Run it in an external browser, hit F12 to bring up the developer tools panel, and then click on the Network tab.  That will show you all of your requests and their response status.  You should see what response is coming back from each server.

Tim Young
Elevate Software
www.elevatesoft.com