EWB 2.05 Build 4

After struggling for hours to find out why I get the following error when trying use LoadRows(CusTbl):
Persistent load error (Error executing request "databases" (Access is denied.)) Line 2808 I get this error regardless if the Internal Web Server is running or not.

The Database is set to Remote. I have a Remote Server installed on the same computer but it makes no diffrence if it's started or not.

I created a Database and added all the tables, I tested the connection at all works fine.
Then I drag it into the project manager and a Database Unit was created. I added some labels and assigned the dataset and the datacolumn. In the Onshow of the Main unit I call LoadRows and I get the error. I checked the Environment of the internal web server and it shows 'database' in the Database Resource Name.

I noticed the External web server say 'databases' I change that to 'database'.

Then I opened the Example project MasterDetails and in the ExampleData I tested the connection and it was fine.
I run and I get the following error:
Dataset load response error (Resource /databases not found)

I also noticed when I run my project I have to stop the web server and the start it after the first form is loaded. If not I will get a "HTTP 404 Not Found",  all the example projects run even when the web server is running. I can not see where the difference is.

Hope someone can help me, it seems like I always run my head against the wall every time I add another face to this project which I started off and on for a year.

Thanks,
Kim Jensen

On 11/7/2016 10:02 PM, KimHJ wrote:
> EWB 2.05 Build 4
>
> After struggling for hours to find out why I get the following error when trying use LoadRows(CusTbl):
> Persistent load error (Error executing request "databases" (Access is denied.)) Line 2808 I get this error regardless if the Internal Web Server is running or not.

This error generally is due to the EWB IDE web server not running.

You cannot serve data without web server so always make sure it's on and
starts OK (i.e. it start without errors due to something else already
occupying the port for example).


> The Database is set to Remote. I have a Remote Server installed on the same computer but it makes no diffrence if it's started or not.

Do you mean remote server for EDB or DBISAM? (i.e. edbsrvr or dbsrvr?)

Either way you need the database server running (edb/dbisam) if your
data is remote and you  still need to run the EWB web server as well.

Did you also update your project as per EWB 2.05 release notes as there
are number of changes to database handling :
http://www.elevatesoft.com/download?action=info&category=ewb&type=ewb&majorversion=2&version=2.05


> I noticed the External web server say 'databases' I change that to 'database'.

in 2.05 it should be "databases" - again this is in release notes (4th
bullet).


> Then I opened the Example project MasterDetails and in the ExampleData I tested the connection and it was fine.

This connection i believe accessed the data direct and not thru web server.


How about doing a clean project first to ensure everything is configured
ok  ?

pre-requisites:
- You need to have installed sample data (which looks like you have) - -
Environment->Options->internal Web Server should have "databases" as
database resource name
- Make sure EWB internal web Server is running without errors (check
output pane for "[Internal Web Server] Started listening on port <your
port>"


General steps that work for me using sample data on 2.05 B4:

1. File -> new project and base it on TForm

2. Go to database manager and make see ExampleData database and open and
preview data for "Products" dataset (it should have 9V-BATTERY-12PK as
1st prodct item etc.) ?

3. drag the Products dataset to your form

4. drop a grid on the form

5. set grid dataset to Products (this should auto populate grid columns)

6. double click on empty form area and you should get to FormCreate
event and add databasename and then loadrows. it should look as follows:

procedure TForm1.Form1Create(Sender: TObject);
begin
   Database.DatabaseName:='ExampleData';
   Database.Loadrows(Products);
end;

7. compile and run - you should see data in grid now

If you do not then either your web server is not properly running or
dataset resource name is off.

You can quickly test using URL in browser :

http://localhost:<web server
port>/databases?method=rows&database=ExampleData&dataset=Products

If you do not see data then something in your config is not valid.

Raul

Raul wrote:

>>in 2.05 it should be "databases" - again this is in release notes (4th bullet).

Sorry, I thought I saw a post where it said database, but I went back and looked and it did say databases.

After changing the databases the example worked, but I keep getting 'HTTP 404 error when starting any project I have made. I noticed in the example that the Output Path was just the word output. After I change my Output Path to a folder in my project folder called output I no longer got the HTTP 404 error when the Internal Web Server was running. Now I'm able run my project.

Thanks again Raul I can finally move forward.
Kim Jensen

On 11/8/2016 11:15 AM, KimHJ wrote:
> After changing the databases the example worked, but I keep getting 'HTTP 404 error when starting any project I have made. I noticed in the example that the Output Path was just the word output. After I change my Output Path to a folder in my project folder called output I no longer got the HTTP 404 error when the Internal Web Server was running. Now I'm able run my project.
> Thanks again Raul I can finally move forward.

Kim,

Glad to hear its working.

The output path value "output" is normal and it represents relative path
- it should place the files in "output\" folder within the project folder.

Sounds like something is confusing the IDE and/or internal web server -
if you have a copy of that project that gets the 404 still it might be
worthwhile to zip it up and send copy to support so Tim can check out
what's going on.

Raul

Kim,

<< After changing the databases the example worked, but I keep getting 'HTTP 404 error when starting any project I have made. I noticed in the example that the Output Path was just the word output. After I change my Output Path to a folder in my project folder called output I no longer got the HTTP 404 error when the Internal Web Server was running. Now I'm able run my project. >>

As Raul says, the project output path is relative, so changing the folder to a sub-folder (called "output") of your project folder should result in the EWB IDE converting the path right back to just "output".  In other words, there should be no difference between the two.

Tim Young
Elevate Software
www.elevatesoft.com