PLZ. HELP with remote DB

[Fizikas]

[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

[mendhak]

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

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.

[Fizikas]

What kind of refereces i must use?

[Fizikas]

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

[Fizikas]

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

[mendhak]

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?

[mendhak]

Helpful link (MS REMOTE)

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

[Fizikas]

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

[mendhak]

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.