Unanswered: RDS Server Error : The server has denied access to the default RDS Handler....
I want to connect my Access Database through IIS. I am using IIS on Windows XP. I have configured the MSADC according to Microsoft Support article.
But I am getting the fallowing Error:
Run-Time error 2147024891 (80070005)
RDS Server Error : The server has denied access to the default RDS Handler Used to access this page. See4 the server Administrator for more information about server security settings
Here is my code :
Dim conn As ADODB.Connection
Set conn = New ADODB.Connection
Dim rst As ADODB.Recordset
Set rst = New ADODB.Recordset
conn.Open "Provider=MS Remote; Remote Provider=Microsoft.Jet.OLEDB.4.0;;Remote Server=http://projects ; Data Source=D:\inetpub\wwwroot\Inventory.mdb"
SQL = "select * from Invoice"
rst.Open SQL, conn
If Not rst.EOF Then