Hi

I have two PCs on my local network.  My development machine and and a machine that I'm using as test server.  I'll can these DEV (Windows 8.1) and ASL3 (Windows XP)  - using latest downloads of EDB and EWB.

On ASL3 I have:-

1. A deployment folder "C:\EWB\Content\trial" that contains apmcontacts.html plus all the bits EWB makes.

2.  EWB web server running on port 8082 with content folder "C:\EWB\Content"

3.  The "C:\Documents and Settings\All Users.WINDOWS\Application Data\Elevate Software\Elevate Web Builder Web Server\ewbsrvr.ini" file contains the lines:-

                             RemoteHost=ASL3
                             RemotePort=12010

4.  EDB server running on port 12010 and being used to support the development of our desktop application - so I know that this server is working for sure.  It is also being accessed from across the Internet as ASL3 has a dynalias from dynalias.net.


On DEV I am running the EWB IDE and have written a simple app that is using the the built in server with URL http://localhost and listening on port 8080.   I can connect and preview a dataset via the ASL3 EDB Server.

BUT if I create another server in the IDE that goes to "http://ASL3/trial" on port 8082 and change the IDE to use this server, then I get a "Dataset load response error" message.   I can still preview the dataset in the IDE.

After poring over newsgroups, I decided to try some direct action.
---------------------------------------------------------------------------------------------

If I key this URL "http://asl3:8082/trial/apmcontacts.html" into Chrome then application loads but fails with the same dataset problem.

If I key this URL "http://asl3:8082/datasets/SearchContacts?method=rows" into chrome, then the response that I get is:-

{   "rows": [
] }

... in this case SearchContacts is a Query on a view.

If I key this URL "http://asl3:8082/datasets/Landlords?method=rows" into chrome, then  no response, no error message.

... in this case Landlords is a Table

If I key this URL "http://asl3:8082/datasets/Tracks?method=rows" I get the rows from the EWB examples.

-----------------------------------------------------------

The reason that I said two problems in the Subject of this post is that the first problem may be related to one that I am anticipating.  

I can see that when creating datasets you can specify the connection parameters in the IDE, but I can't see how to   change these parameters at run time.

In my Delphi application on the same data I first connect a session then, depending on the LogInUser, I open a database.  We allow for a cloud based application where there may be companies with more than one database and users who may have access to one or more databases - including the developers who can access all databases.  This is managed quite nicely with roles.  So we want to be able to have the same security system for our EWB projects.

Too much explanation - but I felt that I had to tell you what I was trying to achieve ...

Cheers

Jeff

Jeff,

two things:

1. did you define the dataset(s) in the new server? The EWB server has to know the dataset, otherwise you'll get the error you got.

2. This URL:
http://asl3:8082/datasets/SearchContacts?method=rows
is wrong - in 1.03 there was a breaking change; the URL has to be now:

http://asl3:8082/datasets?method=rows&dataset=SearchContacts

Uli

Uli Becker wrote:

Jeff,

two things:

1. did you define the dataset(s) in the new server? The EWB server has to know the dataset, otherwise you'll get the error you got.

2. This URL:
http://asl3:8082/datasets/SearchContacts?method=rows
is wrong - in 1.03 there was a breaking change; the URL has to be now:

http://asl3:8082/datasets?method=rows&dataset=SearchContacts

Uli
-------------------------------------------------
Hi Uli

1.  I believe the datasets are known to the server.  If I stop the server and go to "Configure the web server", then to "DataSets, then I can see the SearchContacts dataset and can test the connection and preview the dataset.  I get zero lines in the grid (presumably because my datasert is a parameterised query (on a View, not a Table) but do get a valid response unlike my app.

I didn't know how to get the dataset imported into the server from the IDE as the IDE is on my development PC while the server is on another PC on my network.  What I did was copy entries from the EDBIDE.INI on the development PC into the EWBSRVR.INI on the server PC.

The entries are below my sig.

2.  Using Chrome the link http://asl3:8082/datasets?method=rows&dataset=SearchContacts just hung while using IE11 it gave "HTTP 404 Not Found"

Cheers

Jeff
--------------------------------------------------------
[DataSet_SearchContacts]
EngineType=0
Description=
DataSetType=1
TableName=admintrans
DefaultParams=SelectType=''<#CR#><#LF#>Type=''<#CR#><#LF#>SortKey=''<#CR#><#LF#>Name=''<#CR#><#LF#>ContactName=''<#CR#><#LF#>DayTimePhone=''<#CR#><#LF#>AfterHoursPhone=''<#CR#><#LF#>MobilePhone=''<#CR#><#LF#>
SQL=SELECT *<#CR#><#LF#>FROM SearchALL<#CR#><#LF#>WHERE ({SelectType=''} = 'No' OR Type = {Type=''}) <#CR#><#LF#>  AND (SortKey LIKE '%' + {SortKey=''} + '%'<#CR#><#LF#>      OR Name LIKE '%' + {Name=''} + '%'<#CR#><#LF#>      OR ContactName LIKE '%' + {ContactName=''} + '%'<#CR#><#LF#>      OR REPLACE( '-' WITH '' IN REPLACE( ' ' WITH '' IN <#CR#><#LF#>DayTimePhone)) LIKE '%' + {DayTimePhone=''} + '%'<#CR#><#LF#>      OR REPLACE( '-' WITH '' IN REPLACE( ' ' WITH '' IN <#CR#><#LF#>AfterHoursPhone)) LIKE '%' + {AfterHoursPhone=''} + '%'<#CR#><#LF#>      OR REPLACE( '-' WITH '' IN REPLACE( ' ' WITH '' IN MobilePhone)) <#CR#><#LF#>LIKE '%' + {MobilePhone=''} + '%')<#CR#><#LF#>
BaseTableName=Landlords
ForceBufferFlush=0
RecordLockProtocol=0
RecordLockRetryCount=15
RecordLockWaitTime=100
RecordChangeDetection=0
LoginUser=Jeff Cook
LoginPassword=*************
SessionName=APMSession
SessionDescription=
SessionType=1
LocalSignature=edb_signature
LocalEncryptionPassword=elevatesoft
LocalLargeFileSupport=0
LocalStandardNullBehavior=1
LocalConfigMemory=0
LocalConfigPath=
LocalConfigName=EDBConfig
LocalConfigExtension=.EDBCfg
LocalLockExtension=.EDBLck
LocalLogExtension=.EDBLog
LocalMaxLogFileSize=1048576
LocalLogCategoriesInformation=1
LocalLogCategoriesWarning=1
LocalLogCategoriesError=1
LocalCatalogName=EDBDatabase
LocalCatalogExtension=.EDBCat
LocalBackupExtension=.EDBBkp
LocalUpdateExtension=.EDBUpd
LocalTableExtension=.EDBTbl
LocalTableIndexExtension=.EDBIdx
LocalTableBlobExtension=.EDBBlb
LocalTablePublishExtension=.EDBPbl
LocalTempTablesPath=C:\Users\JEFFCO~1\AppData\Local\Temp\
RemoteCompression=0
RemoteSignature=edb_signature
RemoteEncryption=0
RemoteEncryptionPassword=elevatesoft
RemoteHost=ASL3
RemoteAddress=
RemotePort=12010
RemoteService=
RemoteTimeout=180
RemotePing=1
RemotePingInterval=60
DatabaseName=*********

Jeff,

> 2.  Using Chrome the link http://asl3:8082/datasets?method=rows&dataset=SearchContacts just hung while using IE11 it gave "HTTP 404 Not Found"

But you are using the latest version of EWB? The breaking change
regarding the url was in 1.03.

I cannot say what's wrong, but you can debug the request
(http://asl3:8082/datasets?method=rows&dataset=SearchContacts) in Chrome
by pressing F12 before the request. Go to the "Network" tab and you'll
see what's going on.

Uli

Uli Becker wrote:

Jeff,

> But you are using the latest version of EWB? The breaking change regarding the url was in 1.03.

I wasn't - the IDE was 1.03 and the EWB server was 1.03

Fixed that and it made no difference.

I proved that the EDB server was working by starting EDBMgr sessions from both machines.  Tinkered with a few things and finally gave up in frustration.  Rebooted the server and went for lunch.

> I cannot say what's wrong, but you can debug the request
> (http://asl3:8082/datasets?method=rows&dataset=SearchContacts) in Chrome
> by pressing F12 before the request. Go to the "Network" tab and you'll
> see what's going on.

Came back from lunch and decided to attempt debugging as suggested - was simultaneously scared witless by the debugging stuff (hope I don't have to look at this too often!) and amazed.  

Why amazed?  Because my project now works!!!   My server is internet accessible so I jumped on my mobile phone and started chrome - there was my project in all its glory.  (slight exaggeration there!).

So it seems that "something" was wrong on the server which was fixed by the reboot.  The testing I had done more of less proved the fault must be in the communication between the EWB server and the EDB server - but as it has fixed itself, I suspect and hope I'll never need to know what the problem was.

Thanks for all you help Uli and others.

Onward to the next problem.

Cheers

Jeff