how read/write from remote DB

  • Thread starter Thread starter kjqua
  • Start date Start date
K

kjqua

Hello,

I was wondering if there is a possibility to connect to a sqlite db
remotely from an application that runs on desktop.
Let me better explain.
let's say that I create a Sqlite db (myDb.db3), the fill it, then load
on a Web site http://mySitoWeb.com/
At this point the db would be found http://mySitoWeb.com/myDb.db3

In yours opinion is possible to read / write from a desktop
application the above example ?
I experimented by changing the connection string but unfortunately
failed.
If is possible please explain how to do it.


marco
 
I was wondering if there is a possibility to connect to a sqlite db
remotely from an application that runs on desktop.
Let me better explain.
let's say that I create a Sqlite db (myDb.db3), the fill it, then load
on a Web site http://mySitoWeb.com/
At this point the db would be found http://mySitoWeb.com/myDb.db3

In yours opinion is possible to read / write from a desktop
application the above example ?
I experimented by changing the connection string but unfortunately
failed.
If is possible please explain how to do it.
Click to expand...

SQLite is a file database, so you can only access a SQLite database
as a file (local file, file on network share etc.) not over HTTP.

You can have your desktop app call a web service on the
server that updates the database.

desktop app---(HTTP)---SQLite DB

is not posisble, but:

desktop app---(HTTP)---web service @ server------SQLite DB

is.

Arne
 
SQLite is a file database, so you can only access a SQLite database
as a file (local file, file on network share etc.) not over HTTP.

You can have your desktop app call a web service on the
server that updates the database.

desktop app---(HTTP)---SQLite DB

is not posisble, but:

desktop app---(HTTP)---web service @ server------SQLite DB

is.

Arne
Click to expand...

Arne, thanks for the reply.
I could give more details about:
You can have your desktop app call a web service on the
server that updates the database
desktop app---(HTTP)---web service @ server------SQLite DB
Click to expand...
for me in not what you mean.

thanks marco
 
I could give more details about:
for me in not what you mean.
Click to expand...

You create a web service at the site using whatever server side
technology is available there that exposes all the database
access you need and call that from your desktop app.

Arne
 
You create a web service at the site using whatever server side
technology is available there that exposes all the database
access you need and call that from your desktop app.

Arne
Click to expand...

Thanks for the clarification. Now is clear your Opinion.
Unfortunately I have no chance to install applications on the Server
side.
The Server is a provider that offer PHP scripting Mysql on their
server with free web hosting.
So no deep control on the machine.

Sorry for bad spelling mistakes in the previous post but as you
understand i'm not English speakers.

marco
 
Thanks for the clarification. Now is clear your Opinion.
Unfortunately I have no chance to install applications on the Server
side.
The Server is a provider that offer PHP scripting Mysql on their
server with free web hosting.
So no deep control on the machine.

Sorry for bad spelling mistakes in the previous post but as you
understand i'm not English speakers.
Click to expand...

..NET desktop app----(SOAP/HTTP or REST)----PHP----MySQL

should work fine.

Arne
 
kjqua said:
Unfortunately I have no chance to install applications on the Server
side.
The Server is a provider that offer PHP scripting Mysql on their
server with free web hosting.
So no deep control on the machine.

Sorry for bad spelling mistakes in the previous post but as you
understand i'm not English speakers.

marco
Click to expand...


It is possible to use HttpWebRequest to communicate with a PHP page
which in turn accesses the SQLite database.

Here's a simple example of the use of HttpWebRequest:
http://www.codeproject.com/KB/webservices/HttpWebRequest_Response.aspx

I don't know much about PHP or SQLite, so can't help much further.
 
Back
Top