by mike burk » Fri, 17 Aug 2001 06:32:32
Any advice???
Thanks!
by Carl Prothma » Fri, 17 Aug 2001 06:35:42
Mike,Quote:> I'm trying to convert a client/server app to use an access database that
> exists on the web. I'm using MS Remote provider connection string and RDS
> Datafactory. I get an error message: RDS Server Error: THe server has
> denied access to the default RDS handler used to access this page....
--
Thanks,
Carl Prothman
Microsoft Visual Basic MVP
http://www.able-consulting.com
by Gary » Fri, 17 Aug 2001 18:19:52
Troubleshooting Common Problems with Remote Data Services
http://support.microsoft.com/support/kb/articles/Q251/1/22.asp
Regards,
by mike burk » Fri, 17 Aug 2001 21:34:05
Thanks! That FAQ was exactly what I needed!
Mike Burke
> Mike,
> Check out the following RDS FAQ
> http://www.able-consulting.com/RDS_Faq.htm#Q18
> --
> Thanks,
> Carl Prothman
> Microsoft Visual Basic MVP
> http://www.able-consulting.com
by mike burk » Fri, 17 Aug 2001 21:34:30
Mike
Quote:> Please refer to the following article:
> Troubleshooting Common Problems with Remote Data Services
> http://support.microsoft.com/support/kb/articles/Q251/1/22.asp
> Regards,
Hello
I'm trying to access a database over an intranet with a vb-app. But can't Runtime error '-2147024891(80070005)'; RDS Server Error: The server has denied access to the default RDS Handler -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- Option Explicit Private Sub Form_Load() 'create connectionstring 'Establish a connection with the database 'create a query 'open the recordset 'Move to Next Record 'close rsCon 'close con 'destroy con End Sub -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- Can anybody help me? I'd be really happy if you could THX!!! Erwin Bon 2. Why Abort don't function when the table is in a DataModule ????? 3. RDS 2.5 - How to use RDS to get and maintain data on a Remote Server 6. RDS : Internet Server Error 7. Error with 2 applications using BDE 8. RDS/MDAC/Component Checker Errors/Win2000 Server 9. RDS + IIS5 + RDS DataControl 10. Speed of Indexes between RDS 6.04 and RDS 4.20 11. RDS + IIS5 + RDS DataControl 12. Compiling 4GL code in RDS 6.00 is not like RDS 4.00
get it working. The error I get is the following:
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
-.
used to access this page. See the Server Administrator for more information
about server security settings.
-.
The code I used was:
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
-.
Private con As ADODB.Connection
Private rsCon As ADODB.Recordset
Dim cmd As String
Dim sql As String
Dim con As ADODB.Connection
Dim rsCon As ADODB.Recordset
cmd = "Provider=MS Remote;" & _
"Remote Server=http://erwin;" & _
"Remote Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Handler=MSDFMAP.Handler;" & _
"Data Source=AquariumAgenda/AquariumAgenda.mdb" & _
"Uid=admin;"
Set con = New ADODB.Connection
With con
.ConnectionString = cmd
.Open
End With
sql = "SELECT * FROM tblTest"
Set rsCon = New ADODB.Recordset
With rsCon
.Open sql, con, adOpenForwardOnly, adLockReadOnly
Do While Not rsCon.EOF
'Add testA to the list
lstTest.AddItem rsCon.Fields("testA")
rsCon.MoveNext
Loop
.Close
End With
Set rsCon = Nothing
con.Close
Set con = Nothing
-.