Hi,
I am going through some serious issues while connecting to ms access database on web.
My database is on a shared hosted site. I am trying to access the db.mdb file.
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.
I am in urgent need for the solution.
thanks.