Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » Elevate Web Builder Technical Support » Support Forums » Elevate Web Builder General » View Thread |
Messages 1 to 5 of 5 total |
A connection problem or perhaps two problems. |
Sun, Jul 20 2014 10:31 PM | Permanent Link |
Jeff Cook Aspect Systems Ltd | 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 |
Mon, Jul 21 2014 3:05 AM | Permanent Link |
Uli Becker | 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 |
Mon, Jul 21 2014 7:53 PM | Permanent Link |
Jeff Cook Aspect Systems Ltd | 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=********* |
Tue, Jul 22 2014 3:02 AM | Permanent Link |
Uli Becker | 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 |
Tue, Jul 22 2014 11:50 PM | Permanent Link |
Jeff Cook Aspect Systems Ltd | 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 |
This web page was last updated on Monday, October 14, 2024 at 05:15 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |