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.

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

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
>

"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

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

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

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
>

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

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
>
>
>

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