I use computer that is conneted to domain. Im trying connect to
remote db, i sharing that db with IIS 5.0. When i'm connecting to bd
apears error:
RDS server error:The server has denited accses to the default RDS
Handler used to access this page. See the server Administrator for more
information about server security settings.
What's wrong, what must i do ??? PLZ HELP ME !!!!!!!!
Option Explicit
Private Sub Command1_Click()
Dim cnn As ADODB.Connection
Dim rs As ADODB.Recordset
Set cnn = New ADODB.Connection
Set rs = New ADODB.Recordset
Debug.Print cnn.State
cnn.Open "Provider=MS Remote;Remote Server=http://MyServername.com;" _
& "Remote Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=c:\wwwroot\biblio.mdb;"
Debug.Print cnn.State
rs.Open "SELECT * From Authors", cnn, adOpenKeyset, adLockOptimistic
Debug.Print rs.RecordCount
End Sub
--
Posted via
http://dbforums.com