By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,829 Members | 673 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,829 IT Pros & Developers. It's quick & easy.

help with remote DB

P: n/a

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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
This sounds like a security issue with IIS. Try this: goto IIS/Default
Web Directory - right click, goto properties goto Directory Security.
Check to see what the settings are. Obviously not anonymous. If you
are using windows integrated security you might try adding an account to
the server, then include UID = ...; PWD = ...; in your connection
string.

One other option, if you have physical access to the server computer,
then don't use the remote connection string. Connect directly to the
DB. And if you have direct access to the server you could take this one
step further and just link to the table directly.

Rich
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #2

P: n/a
You need to specify a full path name for the mdb file.

In other words, to open the mdb file, you have to be able to physically see
the file.

If you can browse to the file via network neighbourhood and see the file,
then you can make a ado connection. Remember, JET is only a file share
system. Thus, it is no different then Excel, Word, PowerPoitn etc. To open
and use the data, you have to be able to use the standard windows file
dialog.

Since you can't open excel, or word files via a web address, you can't do
the same to a mdb file either.

You can consider setting up a VPN, but then you will suffer performance
problems. I have some notes on the problems, and solutions to this at:

http://www.attcanada.net/~kallal.msn/Wan/Wans.html
--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
ka****@msn.com
http://www.attcanada.net/~kallal.msn
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.