how read/write from remote DB

[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

 

[Arne Vajhøj]

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.

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

 

[kjqua]

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

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

for me in not what you mean.

thanks marco

 

[Arne Vajhøj]

I could give more details about:
for me in not what you mean.

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

 

[kjqua]

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

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

 

[Arne Vajhøj]

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.

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

should work fine.

Arne

 

[Jason Keats]

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

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.

 

[kjqua]

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.

Thanks for the link, i will carefully read the example.