PLZ. HELP with remote DB

[email protected]

Hi, i wont to know, it's posible to use DB on www.myDB.lt/data.mdb without any SQL server ? PLZ. explain my if it's not posible why.


P.S sorry for my english :)

Connecting to an Access db over the Internet is a bad idea, but anyways:

VB Code:

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://myServer;" _
            & "Remote Provider=Microsoft.Jet.OLEDB.4.0;" _
            & "Data Source=c:\inetpub\wwwroot\biblio.mdb;admin,"
Debug.Print cnn.State
 
rs.Open "SELECT * From Authors", cnn, adOpenKeyset, adLockOptimistic
 
Debug.Print rs.RecordCount

Try it out. If it doesn't work, I doubt anything's possible for that matter.

What kind of refereces i must use?

i found, but i can Data Source=c:\inetpub\wwwroot\biblio.mdb; line.

i found reference, but i can understand line: Data Source=c:\inetpub\wwwroot\biblio.mdb;

Do you know the location of the MDB file on the server?

It would make things slightly easier for you if you could create a DSN on that server. Do you have access to its controls, by any chance?

Helpful link (MS REMOTE)

http://support.microsoft.com/default...NoWebContent=1

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

Quote:

---

Originally posted by Fizikas

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.

---

You'll have to contact your server support team, and ask them to grant you remote access to the database.