Hi friends,

I want to connect my Access/Oracle 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
MsgBox rst.RecordCount
End If

Please help me soon ………….

Thank You

narendra4/12/2004 11:56:59 PM

ALL KINDS OF PROBLEMS DOWNLOADING WINDOWS UP DATES TRIED WITH NO SUCCESS TO USING INSTRUCTIONS PROVIDED BY MS SIPPORT.EITHER I'M DOING SOMETHING WRONG OR THE INSTRUCTION ARE TOO COMPLICATED TO FOLLOW. I HVE WINDOWS XP HOME.PLEASE HELP. I HOPE I'M IN THE RIGHT PLACE TO GET SOME HELP.

PAT CARBONE 3/4/2004 6:49:57 AM