asked on

SQL requests on a access database on a webserver....

Right now i am sending SQL requests to my access database om my computer. But i want to do the same with a database on a webserver.
This i how i connect right now.

----
AdoDbQ := TADOQuery.Create(nil);
AdoDbQ.Prepared := True;
AdoDbQ.ConnectionString := 'Provider=Microsoft.Jet.OLEDB.4.0; Data Source=db.mdb;Persist Security Info=False;Jet OLEDB:Database Password=';

AdoDbQ.SQL.Text := 'SQL request';
AdoDbQ.Open;
AdoDbQ.Close;
----

But what do i do when the database is placed on a webserver? and how can i write to it...?

bogiboy

Do you mean database will not be on the same machine as you app but you want to access it from your app, or you want to access db from the web server i.e. write/read from web application (using let's say asp or another scriptin)?

If MS Access db is on web server and you want to open it from your machine, you have to share that folder on web server where .mdb is located, then just use

'...Source=\\myWebserverNetworkName\MySharedFolder\db.mdb'

and that's it.

If you want to access it from the Web application, that's another story. Depends on how you will develop Web app (Delphi, .asp, asp.net, jsp....)

TheFreeGo

ASKER

No... the database i placed on a normal webserver, like http://www.mydomain.com/db.mdb/

I've heard about mySQL, what is it and can it be used...? The webserver supports it...

bogiboy

You want to open Access database from URL i.e using http to connect to it from anywhere?
Or you want to be able to run your site off the Access db?
I don't get it...

TheFreeGo

ASKER

I want to treat the DB like i was placed on my own computer(the client) but only, it is placed on a webserver with a location like this: http://www.mydomain.com/db.mdb.

Because then, all the clients will share the same database.

ASKER CERTIFIED SOLUTION

bogiboy

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

CleanupPing

TheFreeGo:
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.

kacor

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question:
to accept bogiboy's answer
Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Some days and here is the Christmas Time. I wish good luck and good health for you all and for your loved ones

kacor
EE Cleanup Volunteer