I have been trying to connect to a remote database on my internet provider's server. It is an Access 2000 database and they support FrontPage Extentions.(But they don't support SQL Server at this time).
I had them create a DSN for me. Please tell me what I am doing wrong :(
(I keep getting an error: Internet Server Error when the record set tries to execute)
Dim adoRS As ADODB.Recordset
Dim adoCn As ADODB.Connection
Dim strSQL As string
strSQL = "select ID,UserName,Password, UserLevel from tblUsers"
Set adoCn = New Connection
adoCn.Open "Provider=MS Remote;" _
& "Remote Provider=MSDataShape;" _
& "Remote Server=http://www.url.com;" _
& "Data Source=someDSN;" _
& "User Id=myID;Password=pass;"
Set adoRS = New Recordset
With adoRS
.CursorLocation = adUseClient
.Open strSQL, adoCn, adOpenStatic, adLockReadOnly
.ActiveConnection = Nothing
End With
