I created a custom data set module in Delphi called RoverModule.dll and copied it into the folder bin\datasetmodule\win32.  I added RoverModule.dll as RoverModule to the “Internal Web Server Modules” in Environment Options.

To run the application, I must change the value of “Custom Datasets Module” in “Internal Web Server” of Environment Options to RoverModule.

I can then get the application to access the data by using these two commands in the EWB2 application:
Database.BaseURL:='customdatasets';
Database.LoadRows(RoverLocations);

What do I do if I need to access multiple CustomDatasets at the same time?

Is there a way to specify the DLL to use outside of “Environment Options”?

Thanks

Sidney,

Sorry, missed this post from the weekend.

<< I created a custom data set module in Delphi called RoverModule.dll and copied it into the folder bin\datasetmodule\win32.  I added RoverModule.dll as RoverModule to the “Internal Web Server Modules” in Environment Options.

To run the application, I must change the value of “Custom Datasets Module” in “Internal Web Server” of Environment Options to RoverModule.

I can then get the application to access the data by using these two commands in the EWB2 application:
Database.BaseURL:='customdatasets';
Database.LoadRows(RoverLocations);

What do I do if I need to access multiple CustomDatasets at the same time? >>

You don't really need the Custom DataSet Module setting anymore, and it's actually gone in 2.05.  All you need to do is specify the base path to the module in the Database.BaseURL property setting in your application:

Database.BaseURL:='modules\rovermodule';

Essentially, any module can act as a dataset module, provided that it's been coded to properly handle the incoming dataset requests/parameters.

Tim Young
Elevate Software
www.elevatesoft.com

1)
Do you have an estimate on when 2.05 will be available?

2)
I had the Fish Facts Dataset Client Example working at one point but it no longer works.  I get the message "Error loading fish data" - "Dataset load response error (An error occurred with the web server module datasetmodule (Execution Error: The specified file was not found))"

I am not sure why this error is happening as datasetclient worked before.  My internal web server and modules settings appear to be correct.  I also exited and restarted EWB2.

My test application no longer works with the Internal Web Server either.  

What could be causing this error?

3)
I am able to run the test application using an external EWB2 Web Server but I get an error message when I attempt to activate the data via RoverModule.dll:

The EWB2 application has buttons to load either from an ODBC dataset or from the custom DLL RoverModule.dll.  The RoverModule button does this:
 RoverDataGrid.DataSet := RoverLocations;
 Database.BaseURL:='customdatasets';
 Database.LoadRows(RoverLocations);

The ODBC button works correctly.

The EWB2 Web Server has content set to:
folder: c:\elevate
Default Document:
Enable Cross-Origin Resource Sharing - Checked
DataSets Resource Name:  datasets
Custom Datasets Resource Name: customdatasets
Custom DataSets Module: RoverModule
Modules Resource Name: Modules

Modules lists:  c:\elevate\modules\RoverModule.dll

RoverModule.dll is in c:\elevate\modules

I am accessing the EWB2 application in FireFox and it works correctly other than the error message:
"Application Error" - "Error: Dataset load response error (Error) Line: 20031".

What is causing this error?

Thanks, Sidney

Sidney

<< Do you have an estimate on when 2.05 will be available? >>

I'm still working on finishing up the MySQL PHP layer, so as soon as that's done, then it's ready to go.

<< I had the Fish Facts Dataset Client Example working at one point but it no longer works.  I get the message "Error loading fish data" - "Dataset load response error (An error occurred with the web server module datasetmodule (Execution Error: The specified file was not found))"

I am not sure why this error is happening as datasetclient worked before.  My internal web server and modules settings appear to be correct.  I also exited and restarted EWB2.

My test application no longer works with the Internal Web Server either.  

What could be causing this error? >>

There's an error in your dataset module code - that's what's showing up in the "Specified filed was not found" portion.

<< 3) I am able to run the test application using an external EWB2 Web Server but I get an error message when I attempt to activate the data via RoverModule.dll:

The EWB2 application has buttons to load either from an ODBC dataset or from the custom DLL RoverModule.dll.  The RoverModule button does this:
 RoverDataGrid.DataSet := RoverLocations;
 Database.BaseURL:='customdatasets';
 Database.LoadRows(RoverLocations);

The ODBC button works correctly.

The EWB2 Web Server has content set to:
folder: c:\elevate
Default Document:
Enable Cross-Origin Resource Sharing - Checked
DataSets Resource Name:  datasets
Custom Datasets Resource Name: customdatasets
Custom DataSets Module: RoverModule
Modules Resource Name: Modules

Modules lists:  c:\elevate\modules\RoverModule.dll

RoverModule.dll is in c:\elevate\modules

I am accessing the EWB2 application in FireFox and it works correctly other than the error message:
"Application Error" - "Error: Dataset load response error (Error) Line: 20031".

What is causing this error? >>

Again, this is a coding issue.  If you want to post your dataset module here along with a client application that exhibits the issue(s), I'll take a look and tell you what's wrong.

Tim Young
Elevate Software
www.elevatesoft.com

Tim:

I am Looking forward to the release of 2.05.

The issue has been resolved.  I was able to determine the errors were caused by problems with user authentication in the DLL.

Thank you.