My setup is as follows:-

Web Server: IIS
Content Directory: c:\inetpub\wwwroot

EWB Server's Content Directory: c:\inetpub\wwwroot
App Database: c:\mydata

When I attempt to load a dataset via Database.LoadRows(Dataset), IIS complains that dataset is not found in physical path c:\inetpub\wwwroot\databases.

Is it something to do with EWB server's Databases Resource Name which is currently set as Databases? I would like to set the databses for the app at runtime so that it does not affect my other apps.

--
Frederick

What code have you written for IIS to get the request and send back the data?  Did you write PHP, ASP or a Delphi ISAPI module to get the request and manipulate and send back the data?

IIS by itself knows nothing about EWB.


or Are you running 2 different Web Servers (which I think could work - but I don't know)
- IIS to serve pages (Load the XXXHTML and XXX.js - created by EWB)
and
- EWB web server to serve Data

Both servers would be listening on different ports and less they are on two different machines.

In this case you need to have CORS parameters in your Headers and the EWB Database.URL configured in you EWB App so it knows how to get to the EWB Server to get data.  

Walter



Frederick Chin wrote:

My setup is as follows:-

Web Server: IIS
Content Directory: c:\inetpub\wwwroot

EWB Server's Content Directory: c:\inetpub\wwwroot
App Database: c:\mydata

When I attempt to load a dataset via Database.LoadRows(Dataset), IIS complains that dataset is not found in physical path c:\inetpub\wwwroot\databases.

Is it something to do with EWB server's Databases Resource Name which is currently set as Databases? I would like to set the databses for the app at runtime so that it does not affect my other apps.

--
Frederick

Walter Matte wrote:

/*
or Are you running 2 different Web Servers (which I think could work - but I don't know)
- IIS to serve pages (Load the XXXHTML and XXX.js - created by EWB)
and
- EWB web server to serve Data

Both servers would be listening on different ports and less they are on two different machines.
*/

This is the setup I am using. IIS for running a PHP script and EWB server to serve data for DBISAM tables.

Both servers are using different ports but the call to the PHP script must not have a port number in the URL.

I tried the following setup:-

IIS --> dummy HTML --> EWB app --> DBISAM data (works fine). However, a call to the PHP script via a TServerRequest from the EWB app fails (returns the entire PHP script).

I know the PHP script works because if I call it from IIS directly, it returns the correct data.

The second scenario correctly loads the PHP script but fails to load the DBISAM data:-

IIS --> EWB app --> DBISAM data (fails with IIS reporting that Databases does not exist in c:\inetpub\wwwroot)

/*
In this case you need to have CORS parameters in your Headers and the EWB Database.URL configured in you EWB App so it knows how to get to the EWB Server to get data.  
*/

I believe this is what I need. How do I put it in the EWB app?

--
Frederick

After looking at the IIS message again and some experimentation, I have managed to get the EWB app to work.

I changed the database's BaseURL from "databases" to "https://<mydomain name>:<port number>/databases" before calling LoadRows.

Thanks.

--
Frederick