|
-
July 8th, 2001, 11:16 PM
#1
Access at remote
I'm trying to simulate accessing an Access db at a remote server. (using the local machine acting as the remote server)
Dim oConn As ADODB.Connection
Dim oRS As ADODB.Recordset
Dim sConnString As String
sConnString = "Provider=MS Remote;Remote Server=http://127.0.0.1;Remote Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\db\Test.mdb;"
oConn.Open sConnString
Set oRS = oConn.Execute("SELECT * FROM TAB_CATALOG", , adCmdText)
Connection is successfully made, but the sql execution part returns an error :
RDS Server Error: The server has denied access to the default RDS Handler used to access this page. See the Server Administrator for more info about security settings.
Help.....
Thanks in Advance,
Ben
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|