Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » Elevate Web Builder Technical Support » Support Forums » Elevate Web Builder General » View Thread |
Messages 1 to 10 of 10 total |
settings for datasets when wanting to deploy to real server.. |
Sun, Mar 16 2014 1:03 AM | Permanent Link |
Bruno Larochelle | I'm new to EWB, but experienced with DBISAM, databases, and fairly comfortable with web servers etc.
Although I'm able to do local testing of a simple 1-table (dbisam) web application using EWB, I'm a little lost at the moment in trying to deploy a simple example on to a 'real' server (not 'localhost'). Server : I am using the EWB web server provided, and have installed and configured that on to my external machine. It is hooked up to the dataset which I call 'testdata' and I can see that the connection is fine and I can see my data on the 'preview' tab. I have configured and registered the server with the EWB IDE, and selected it as the web server to use (instead of the default local server). Web app : this is where I'm a little confused, particularly in the 'connection properties' of the 'Editing dataset' form for my 'testdata'. Do I set this as a 'local' dataset, or a 'remote' dataset? If it is 'local', do I specify the settings local to the server? If it is 'remote'.. do I simply provide the hostname and the databasename? I have yet been able to 'preview' the data in the dataset configuration.. can't find the table etc etc.. I'm a tad confused here, as you can no doubt tell, would love a hint or two from those who have been down this path. thanks Bruno Larochelle |
Sun, Mar 16 2014 11:08 AM | Permanent Link |
Uli Becker | Bruno,
> Server : I am using the EWB web server provided, and have installed and configured that on to my external machine. It is hooked up to the dataset which I call 'testdata' and I can see that the connection is fine and I can see my data on the 'preview' tab. I have configured and registered the server with the EWB IDE, and selected it as the web server to use (instead of the default local server). Correct. > Web app : this is where I'm a little confused, particularly in the 'connection properties' of the 'Editing dataset' form for my 'testdata'. Do I set this as a 'local' dataset, or a 'remote' dataset? If it is 'local', do I specify the settings local to the server? If it is 'remote'.. do I simply provide the hostname and the databasename? I have yet been able to 'preview' the data in the dataset configuration.. can't find the table etc etc.. I'm a tad confused here, as you can no doubt tell, would love a hint or two from those who have been down this path. Actually the you *can* use the dataset manager in the EWB IDE, but you don't *need* to use it when using a remote server. When you execute the web app and connect to a remote server, the dataset settings of the server are decisive. If you don't use the dataset manager in the IDE, qou can drop a dataset component on your form and fetch the columns from the remote server by using a server request (right icon after having double clicked the dataset component) like this: http://MyServerIP/datasets?method=columns&dataset=TestData That should import all columns of the dataset and you are all done. Hope that helps. Uli |
Sun, Mar 16 2014 1:53 PM | Permanent Link |
Bruno Larochelle | Thanks Uli, that is helping me understand a few things
I followed as you said, and tried to tell the dataset to fetch it's columns from the remote server : http://vcmac.edm.ab.ec.gc.ca:8086/datasets?method=columns&dataset=testdata (that machine is running a live ewb server, test purposes) .. this however gives me error 12029 (can't connect, I searched the forum). I decided to try running a local server, also on 8086, and doing the same thing : http://localhost:8086/datasets?method=columns&dataset=testdata and that worked fine. I have checked the firewalls, antivirus etc.. I may be wrong but I think everything should be open for this. I will continue fooling around, possibly trying on another server. regards.. Bruno Uli Becker wrote: Bruno, ... > to 'preview' the data in the dataset configuration.. can't find the table etc etc.. I'm a tad confused here, as you can > no doubt tell, would love a hint or two from those who have been down this path. Actually the you *can* use the dataset manager in the EWB IDE, but you don't *need* to use it when using a remote server. When you execute the web app and connect to a remote server, the dataset settings of the server are decisive. If you don't use the dataset manager in the IDE, qou can drop a dataset component on your form and fetch the columns from the remote server by using a server request (right icon after having double clicked the dataset component) like this: http://MyServerIP/datasets?method=columns&dataset=TestData That should import all columns of the dataset and you are all done. Hope that helps. Uli |
Sun, Mar 16 2014 2:29 PM | Permanent Link |
Uli Becker | Bruno,
> I followed as you said, and tried to tell the dataset to fetch it's columns from the remote server : > http://vcmac.edm.ab.ec.gc.ca:8086/datasets?method=columns&dataset=testdata > > (that machine is running a live ewb server, test purposes) > this however gives me error 12029 (can't connect, I searched the forum). Are you sure that the server is accessible regardless of the EWB Server configuration? Just create a test.html and try. I just tried the URL you posted and it's pending. Also: you can get the rows of the dataset in JSON format using a similar request: http://vcmac.edm.ab.ec.gc.ca:8086/datasets?method=rows&dataset=testdata From Tim: << Do you have FireFox or Chrome ? If so, then you can use the F12 developer tools window to debug what is getting sent "over the wire" via the Network panel, and if there is any error occurring during the process. >> Uli |
Sun, Mar 16 2014 3:00 PM | Permanent Link |
Bruno Larochelle | Uli.. thanks again for your time here
I created a small html doc, and still am UNable to see it : http://vcmac.edm.ab.ec.gc.ca:8086/index.html or http://vcmac.edm.ab.ec.gc.ca:8086/datasets/index.html so it would appear something on that server is not letting me go through 8086 my configuration settings on the EWB server : -> server -> domain .. '' (blank) -> connections -> listening IP .. '' (blank) -> content -> content folder .. location of my data, also location of 'index.html' (static content, as I understand it) -> datasets -> 'testdata' which appears to properly connect to the data I will try using Chrome, as suggested, to see what is getting hung up regrads .. Bruno /////////////////////////// Uli Becker wrote: Bruno, > I followed as you said, and tried to tell the dataset to fetch it's columns from the remote server : > http://vcmac.edm.ab.ec.gc.ca:8086/datasets?method=columns&dataset=testdata > > (that machine is running a live ewb server, test purposes) > this however gives me error 12029 (can't connect, I searched the forum). Are you sure that the server is accessible regardless of the EWB Server configuration? Just create a test.html and try. I just tried the URL you posted and it's pending. Also: you can get the rows of the dataset in JSON format using a similar request: http://vcmac.edm.ab.ec.gc.ca:8086/datasets?method=rows&dataset=testdata From Tim: << Do you have FireFox or Chrome ? If so, then you can use the F12 developer tools window to debug what is getting sent "over the wire" via the Network panel, and if there is any error occurring during the process. >> Uli |
Sun, Mar 16 2014 4:10 PM | Permanent Link |
Raul Team Elevate | On 3/16/2014 3:00 PM, Bruno Larochelle wrote:
> http://vcmac.edm.ab.ec.gc.ca:8086/index.html > or > http://vcmac.edm.ab.ec.gc.ca:8086/datasets/index.html Definitely unable to connect to those. Either firewall blocking i, server listening on 8086 or server is not routing responses back. EWB Server settings look right to me. Generally you do not need to work against an internet facing production server. Do the development on your dev machine ewb server but make sure you use relative URLs in your code. Specifically for loading TDataSets you can set the baseURL to something like this : Database.baseURL := window.location.protocol + '//'+ window.location.host + '<your url>'; and for TServerRequests you can just modify the URL direct myServerERquest.URL := window.location.protocol + '//'+ + window.location.host+'<your url>'; At deployment time you host the EWB app from same server so if EWB app can load you know the server is online ok and sonce you use relative URLs no code changes are needed. Datasets still need be to configured but that's easy to test as well using the query as per prev posts. Raul |
Sun, Mar 16 2014 4:11 PM | Permanent Link |
Raul Team Elevate | On 3/16/2014 4:10 PM, Raul wrote:
> On 3/16/2014 3:00 PM, Bruno Larochelle wrote: >> http://vcmac.edm.ab.ec.gc.ca:8086/index.html >> or >> http://vcmac.edm.ab.ec.gc.ca:8086/datasets/index.html > > Definitely unable to connect to those. Either firewall blocking i, > server listening on 8086 or server is not routing responses back. Sorry - meant "either fierall blocking it, server not listening on 8086 or server is not routing responses back" Raul |
Mon, Mar 17 2014 12:04 AM | Permanent Link |
Bruno Larochelle | Thank you Uli and Raul for your assistance/comments/tips - very helpful.
I've yet to find my blockage, but i'm now confident that it is indeed a firewall or routing issue, and I will be able to solve it. I'll advise when that is the case, to put some closure on it! regards.. Bruno Raul wrote: On 3/16/2014 4:10 PM, Raul wrote: > On 3/16/2014 3:00 PM, Bruno Larochelle wrote: >> http://vcmac.edm.ab.ec.gc.ca:8086/index.html >> or >> http://vcmac.edm.ab.ec.gc.ca:8086/datasets/index.html > > Definitely unable to connect to those. Either firewall blocking i, > server listening on 8086 or server is not routing responses back. Sorry - meant "either fierall blocking it, server not listening on 8086 or server is not routing responses back" Raul |
Wed, Mar 19 2014 11:42 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Bruno,
<< Server : I am using the EWB web server provided, and have installed and configured that on to my external machine. It is hooked up to the dataset which I call 'testdata' and I can see that the connection is fine and I can see my data on the 'preview' tab. I have configured and registered the server with the EWB IDE, and selected it as the web server to use (instead of the default local server). >> So, just to confirm: you configured a dataset called 'testdata' in the EWB Web Server configuration dialog, correct ? << Web app : this is where I'm a little confused, particularly in the 'connection properties' of the 'Editing dataset' form for my 'testdata'. Do I set this as a 'local' dataset, or a 'remote' dataset? If it is 'local', do I specify the settings local to the server? If it is 'remote'.. do I simply provide the hostname and the databasename? I have yet been able to 'preview' the data in the dataset configuration.. can't find the table etc etc.. I'm a tad confused here, as you can no doubt tell, would love a hint or two from those who have been down this path. >> Datasets are *always* configured relative to the location of the EWB Web Server. IOW, whatever machine is running the EWB Web Server is the perspective from which all paths, IP addresses, etc. will be resolved. As to whether you use local or remote for the dataset, that is completely up to you and your database configuration (I assume that you're using DBISAM). If you're using the DBISAM Database Server, then you'll want to use a remote connection for the dataset definition. If the DBISAM database is on the same machine as the EWB Web Server, then you can get away with using a direct local connection. If you have any other questions, please let me know. Tim Young Elevate Software www.elevatesoft.com |
Sun, Mar 23 2014 2:46 PM | Permanent Link |
Bruno Larochelle | thank you Uli, Raul and Tim for your kind assistance and expertise
i have it working now, my problem was a firewall issue of which i had no control - went to another server to get this resolved .. off topic .. in the process, i've learned more on how this all works, and i'm now set to take over the world! sort of have the same feeling i had with Delphi 1 in 1995 .. many new open doors! regards.. Bruno "Tim Young [Elevate Software]" wrote: Bruno, |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |