Connect Remote MS Access Database

[danish_ara]

Hi,

I am trying to connect to a remote ms access database (db.mdb) file which is on the web.

I can establish the connection ... but as soon as I execute the SQL it throws an error.

I my database is on brinkster.com therefore I cannot set any security permissions...

I am in desperate need.

thanks,
Danish

[rmiao]

How did you conenct to it? What was the error?

[danish_ara]

I can connect to the file correctly using the following syntax in asp 3.0.



set conn = CreateObject("ADODB.Connection")
conn.open "Provider=MS Remote;" &_
"Remote Server=http://<Web SERVER IP>;" &_
"Remote Provider=Microsoft.Jet.OLEDB.4.0;" &_
"Data Source=<Database Path>;"



But as soon as I try to create the recordset and execute the sql query...it throws an error.



set rs=server.CreateObject("ADODB.recordset")
rs.open "Select * from userold", conn,1,2



Error: Unexpected Error.



I dont know if its because of the iis permission or something...I cannot set any permissions on server since its on shared hosting.



is there any workaround for this ? I can work on C#, VB and asp.net/asp3.0. solutions in these language will be greatly appriciated.

[rmiao]

You should find out from sys admin what kind of permission the ie account has.