Remote Database using ADO 
Author Message
 Remote Database using ADO

I'm trying to access a database that's sitting on a web server.  I can
make the connection, but I can't open a recordset.  My code for the
connection is below.


Private Sub Command1_Click()

    Dim C As ADODB.Connection
    Set C = New ADODB.Connection
    sever = ""
    Source = "c:\temp\mydb.mdb"
    cnnstr = "Provider=MS Remote; Remote Server=" & server & ";Remote
Provider=Microsoft.Jet.OLDDB.4.0;Data Source=" & Source & ";admin"
    C.Open cnnstr, admin, ""

End Sub

Tue, 16 Mar 2004 03:43:31 GMT  
 Remote Database using ADO
What happens? Do you get an error? What does it say?

Tue, 16 Mar 2004 22:16:01 GMT  
 [ 2 post ] 

 Relevant Pages 

1. Accessing remote database using ADO

2. connection string to Remote ACCESS Database in ADO

3. Ado connect remote database

4. ADO Connection to a Remote Microsoft Access Database

5. ADO connection to remote SQL-Server database refused

6. Dynamic listboxes from remote .DBF using ADO/RDS

7. Dynamic listboxes from remote .DBF using ADO/RDS

8. Problem using ADO to delete remote recordset

9. Error using ADO in a remote component.

10. Accessing Remote Oracle database using VB code.

11. adding a record to access database using

12. regarding database connectivity using ado


Powered by phpBB® Forum Software