![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 10 of 15 total |
![]() |
Tue, Nov 17 2009 4:25 AM | Permanent Link |
=?iso-8859-1?Q?Santy_Concepci=F3n?= | Hi!
I have been using Dbisam for desktop applications for about 3 years. I have read about web applications development with Dbisam, but I'm new to web development. I would like to learn about web development with dbisam (if possible). Is it possible to host a DBISAM database on a web server? How can I access a web hosted DBIsam app from a desktop application? How can I access a web hosted DBIsam app through a web app? Is it possible to access a desktop database from a web application? As you see, I have a lot of basic questions. Are there any project examples or detailed instructions for what do I need? Any simple 'hello world' project to start with? Thanks. -- Santy C. |
Tue, Nov 17 2009 6:10 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Santy,
<< Is it possible to host a DBISAM database on a web server? >> Sure. You can use either the DBISAM Database Server, or a web application, or both, to access the database(s). However, hosting a DBISAM Database Server on a web server can be dicey if using a 3rd party hosting provider, since many refuse to run anything other than MySQL or SQL Server. << How can I access a web hosted DBIsam app from a desktop application? >> You can use the DBISAM Database Server on the web server, but see above for the caveat about 3rd party hosting providers. << How can I access a web hosted DBIsam app through a web app? >> You don't actually access a DBISAM application through a web application. What you do is have the web application running with the web server on the server machine, and then have a web browser access the web application. << Is it possible to access a desktop database from a web application? >> I'm not sure what you mean by this question. Do you mean accessing a database on a client machine from a web application running on the web server ? Perhaps it might help if you start with what you need to do, and then we can progress from there. Most of what you're asking is very general in scope, and therefore it isn't very easy to provide answers that give much information to you. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Nov 18 2009 11:17 AM | Permanent Link |
=?iso-8859-1?Q?Santy_Concepci=F3n?= | Hi, Tim...
Thanks for your answers, and please forgive my very basic question. Ok. I would like to store a database on a web server and access it from a client machine. And I would like to create a web application too (yes, another different project) which connects to a database server hosted on client machine. I just want to try this in my holidays (I can't stop developing, ![]() I have been a lot of years developing desktop applications and now I would like to start with web development, and maybe make by old applications compatible with hosted database servers. Let's beging with storing a database server on a web server... -- Santy C "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> escribió en el mensaje de noticias:3F0F8B90-FAD3-49CB-9C16-52213BD86EF4@news.elevatesoft.com... > Santy, > > << Is it possible to host a DBISAM database on a web server? >> > > Sure. You can use either the DBISAM Database Server, or a web > application, or both, to access the database(s). However, hosting a > DBISAM Database Server on a web server can be dicey if using a 3rd party > hosting provider, since many refuse to run anything other than MySQL or > SQL Server. > > << How can I access a web hosted DBIsam app from a desktop application? >> > > You can use the DBISAM Database Server on the web server, but see above > for the caveat about 3rd party hosting providers. > > << How can I access a web hosted DBIsam app through a web app? >> > > You don't actually access a DBISAM application through a web application. > What you do is have the web application running with the web server on the > server machine, and then have a web browser access the web application. > > << Is it possible to access a desktop database from a web application? >> > > I'm not sure what you mean by this question. Do you mean accessing a > database on a client machine from a web application running on the web > server ? > > Perhaps it might help if you start with what you need to do, and then we > can progress from there. Most of what you're asking is very general in > scope, and therefore it isn't very easy to provide answers that give much > information to you. > > -- > Tim Young > Elevate Software > www.elevatesoft.com > |
Wed, Nov 18 2009 1:59 PM | Permanent Link |
"Rita" | "Santy Concepción" <santyweb@hotmail.com> wrote in message news:46C390AB-2394-404C-8CC3-F68CD4EBC163@news.elevatesoft.com... > > Let's beging with storing a database server on a web server... > 1st get a remote server that you have full control off. Try a VPS its a great way to go cheapest way now. On VPS u can upload whatever you like. As for your line above "database server on a web server" I know what you mean but its not exactly true. The computer is the server then people write socket servers to run on that. So Tims DBIsam is running on port 2005 as a socket server, and IIS for the website part is running on port 80 as a socket server. There is an example of running a DBisam server in the Intraweb demos called "DieFlyDie" that's web based + the usual Fish demo. As for the desktop applications thats easy just the same as you do now on a LAN and u only need to add the remote IP address for the DBIsam server. It really is that simple. So get a Windows VPS package and play with that to find your way around, then upload a DBIsam server, a couple of tables and 1st job log onto it via DBSys after you have registered your database via the the sysadmin tool. Good luck. Rita |
Thu, Nov 19 2009 1:47 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Santy,
<< Ok. I would like to store a database on a web server and access it from a client machine. And I would like to create a web application too (yes, another different project) which connects to a database server hosted on client machine. >> As Rita indicated, you have to get a web server machine that you can open firewall ports for, specifically 12005 and 12006 (admin) in order to use the DBISAM Database Server. If you want to just test this, however, I can send you details on how to use our test DBISAM Database Server located here at Elevate Software with your application. Just email me if you're interested. -- Tim Young Elevate Software www.elevatesoft.com |
Mon, Nov 23 2009 5:05 AM | Permanent Link |
adam | Santy,
If you are a Delphi developer & happy to try INTRAWEB they make it very easy to develop DBISAM on web. Basically the Intraweb application is an EXE on the web-server which responds to requests from client-side browsers sending out data which the browser views as a webpage. I have an Intraweb app & only use the DBISAM desktop database connection! Because the Intraweb app is on the webserver, which is the same machine as the DB, access is fast and works really well. You just have to ensure that your DB files are in private folders so they can't be hacked. Developing Intraweb is not totally easy, but for a Delphi programmer it is not too difficult. I have also looked at the Morfik development environment for the Web, which is probably slightly more pretty and clever but comes with its own IDE separate from Delphi, so connecting to DBISAM is easier via ODBC. Adam |
Mon, Nov 23 2009 8:02 AM | Permanent Link |
=?iso-8859-1?Q?Santy_Concepci=F3n?= | Hi, Tim...
Ok, I have a lot of registered domains and hostings. If I want to store a DBISAm Database on a web server... May I upload a dbisam table to a private folder on my web page? Is it that simple? Let's focus on 'acces to a web hosted database server from a desktop client windows application', for now. What do I need? What files may I upload to my web? Thanks a lot and please forgive my poor knowledge and poor english ![]() -- Santy C "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> escribió en el mensaje de noticias:3FADBF82-6412-4C1C-B9FB-6A7AA2FF5E66@news.elevatesoft.com... > Santy, > > << Ok. I would like to store a database on a web server and access it from > a client machine. And I would like to create a web application too (yes, > another different project) which connects to a database server hosted on > client machine. >> > > As Rita indicated, you have to get a web server machine that you can open > firewall ports for, specifically 12005 and 12006 (admin) in order to use > the DBISAM Database Server. If you want to just test this, however, I can > send you details on how to use our test DBISAM Database Server located > here at Elevate Software with your application. Just email me if you're > interested. > > -- > Tim Young > Elevate Software > www.elevatesoft.com > |
Mon, Nov 23 2009 1:18 PM | Permanent Link |
"Raul" | What exactly do you mean by "web hosted database server" ?
If you mean database server that you can access over internet using tcp/ip then Tim has already provided you the answer. You basically need: - server on internet that allows you to run DBISAM Database server executable on it (windows server basically; running linux with wine works as well but is not supported by Elevate as far as I know) - allow TCP traffic on ports 12005 and 12006 - create a database (folder name) on your dbisam server - copy/create some tables in database - in desktop app just use remote session to connect to your dbisam server (using the IP or DSN name of the server). This setup is really no different than a normal "client/server" model except communication happens over internet instead of lan or vpn. The things you need to be aware of is the link latency, bandwidth and overall unreliability - so reduce the traffic (avoid chatty data bound controls) and do as much possible on server in terms of filtering, etc - goal is to transmit as little data as possible. There are postings in this NG that deal with slow remote connections. Hope this helps. Raul "Santy Concepción" <santyweb@hotmail.com> wrote in message news:60D050AC-7C75-440A-8E4C-52FCC0D05C1E@news.elevatesoft.com... > Hi, Tim... > > Ok, I have a lot of registered domains and hostings. > If I want to store a DBISAm Database on a web server... May I upload a > dbisam table to a private folder on my web page? Is it that simple? > > Let's focus on 'acces to a web hosted database server from a desktop > client windows application', for now. > What do I need? What files may I upload to my web? > > Thanks a lot and please forgive my poor knowledge and poor english ![]() > > -- > Santy C > __________ Information from ESET NOD32 Antivirus, version of virus signature database 4630 (20091123) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com |
Mon, Nov 23 2009 1:47 PM | Permanent Link |
=?iso-8859-1?Q?Santy_Concepci=F3n?= | Hi, Raul...
I will try to explain it this way, so I hope you can understand me better: 1) I have a web site with a MySQL database. 2) I have a client machine with a desktop application which connects to the MySQL web database using its Host IP, username, password, etc... So the question is... Is it possible to do the same using DBISAM? Is it possible to store a '.dat' table on a web site private folder and access it from a client machine delphi application? If not, then I will focus on 'creating a web application with Intraweb (for example) that connects to a dbisam database server'. Thanks! -- Santy C "Raul" <raul@raul.ca> escribió en el mensaje de noticias:DEF17676-C7A1-43B1-8FEC-A0E79121B64F@news.elevatesoft.com... > What exactly do you mean by "web hosted database server" ? > > If you mean database server that you can access over internet using > tcp/ip then Tim has already provided you the answer. > > You basically need: > - server on internet that allows you to run DBISAM Database server > executable on it (windows server basically; running linux with wine works > as well but is not supported by Elevate as far as I know) > - allow TCP traffic on ports 12005 and 12006 > - create a database (folder name) on your dbisam server > - copy/create some tables in database > - in desktop app just use remote session to connect to your dbisam server > (using the IP or DSN name of the server). > > This setup is really no different than a normal "client/server" model > except communication happens over internet instead of lan or vpn. The > things you need to be aware of is the link latency, bandwidth and overall > unreliability - so reduce the traffic (avoid chatty data bound controls) > and do as much possible on server in terms of filtering, etc - goal is to > transmit as little data as possible. There are postings in this NG that > deal with slow remote connections. > > Hope this helps. > > Raul > > > "Santy Concepción" <santyweb@hotmail.com> wrote in message > news:60D050AC-7C75-440A-8E4C-52FCC0D05C1E@news.elevatesoft.com... >> Hi, Tim... >> >> Ok, I have a lot of registered domains and hostings. >> If I want to store a DBISAm Database on a web server... May I upload a >> dbisam table to a private folder on my web page? Is it that simple? >> >> Let's focus on 'acces to a web hosted database server from a desktop >> client windows application', for now. >> What do I need? What files may I upload to my web? >> >> Thanks a lot and please forgive my poor knowledge and poor english ![]() >> >> -- >> Santy C >> > > > > __________ Information from ESET NOD32 Antivirus, version of virus > signature database 4630 (20091123) __________ > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.com > > > |
Mon, Nov 23 2009 2:04 PM | Permanent Link |
"Raul" | Yes - this is exactly what previous posting listed steps for.
1. run DBISAM Database Server on your web server 2. Connect from client app using server IP, username and password The reason I asked is that this is not really anything to do with "web" or "web site"- it's a regular client/server type access over internet to a server. Similarly the mysql setup you described is nothing to do with "web" really. There are web hosting providers that give a you a mysql instance but as long as you can run your own server (dbisam db server in this case) you can use DBISAM. If you want you can even run MySQL and DBISAM side-by-side on same machine. Raul "Santy Concepción" <santyweb@hotmail.com> wrote in message news:0220FBD8-2D21-467E-B43C-0FFB0B6AD121@news.elevatesoft.com... > Hi, Raul... > > I will try to explain it this way, so I hope you can understand me better: > > 1) I have a web site with a MySQL database. > 2) I have a client machine with a desktop application which connects to > the MySQL web database using its Host IP, username, password, etc... > > So the question is... > Is it possible to do the same using DBISAM? Is it possible to store a > '.dat' table on a web site private folder and access it from a client > machine delphi application? > > If not, then I will focus on 'creating a web application with Intraweb > (for example) that connects to a dbisam database server'. > > Thanks! > > -- > Santy C > > "Raul" <raul@raul.ca> escribió en el mensaje de > noticias:DEF17676-C7A1-43B1-8FEC-A0E79121B64F@news.elevatesoft.com... >> What exactly do you mean by "web hosted database server" ? >> >> If you mean database server that you can access over internet using >> tcp/ip then Tim has already provided you the answer. >> >> You basically need: >> - server on internet that allows you to run DBISAM Database server >> executable on it (windows server basically; running linux with wine works >> as well but is not supported by Elevate as far as I know) >> - allow TCP traffic on ports 12005 and 12006 >> - create a database (folder name) on your dbisam server >> - copy/create some tables in database >> - in desktop app just use remote session to connect to your dbisam server >> (using the IP or DSN name of the server). >> >> This setup is really no different than a normal "client/server" model >> except communication happens over internet instead of lan or vpn. The >> things you need to be aware of is the link latency, bandwidth and overall >> unreliability - so reduce the traffic (avoid chatty data bound controls) >> and do as much possible on server in terms of filtering, etc - goal is to >> transmit as little data as possible. There are postings in this NG that >> deal with slow remote connections. >> >> Hope this helps. >> >> Raul >> >> >> "Santy Concepción" <santyweb@hotmail.com> wrote in message >> news:60D050AC-7C75-440A-8E4C-52FCC0D05C1E@news.elevatesoft.com... >>> Hi, Tim... >>> >>> Ok, I have a lot of registered domains and hostings. >>> If I want to store a DBISAm Database on a web server... May I upload a >>> dbisam table to a private folder on my web page? Is it that simple? >>> >>> Let's focus on 'acces to a web hosted database server from a desktop >>> client windows application', for now. >>> What do I need? What files may I upload to my web? >>> >>> Thanks a lot and please forgive my poor knowledge and poor english ![]() >>> >>> -- >>> Santy C >>> >> >> >> >> __________ Information from ESET NOD32 Antivirus, version of virus >> signature database 4630 (20091123) __________ >> >> The message was checked by ESET NOD32 Antivirus. >> >> http://www.eset.com >> >> >> > > __________ Information from ESET NOD32 Antivirus, version of virus > signature database 4631 (20091123) __________ > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.com > > > __________ Information from ESET NOD32 Antivirus, version of virus signature database 4631 (20091123) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |