Remote Access [UNRESOLVED]

[ArChAnGeL2k3]

Hello again,
im still trying to build VB program which will connect DB via remote connection, now here is the code i use:


Dim rs As New ADODB.Recordset
Dim cn As New ADODB.Connection
cn.Open "Provider=MS Remote;Data Source=1.mdb;" & _
"Remote Server=http://www33.brinkster.com/acagl/"
rs.Open "SELECT * FROM authors", cn

i use brinkster free DB access, the DB located here:
http://www33.brinkster.com/acagl/1.mdb
it works u can check, now this code give me INVALID SERVER ERROR, im trying to solve this problem for 2 weeks now please if any one know how to connect the DB and have done it before reply me.

thanks and happy new year!

[Matt_T_hat]

I understand that Brinkster do not allow remote access to images and would not be supprised if they disallowed to databases too.

I would imagine that you could get round it by simulating remote access with ASP pages server side called in web objects on your form...?

Sorry I can not help more or have better news.

Haveing said that what about ActiveX web controls... if you want read only you could try useing another directory

[ArChAnGeL2k3]

Actually it can be done by XML object, but solving the problem that way would be just wrong and with a lot of bugs...

[Matt_T_hat]

*Draws in a breath through his teath and begins seriously to think*

Hmmm I see...