Printable View
hi
i was wondering if we could connect two diff. databases and then link them thr. two diff fields from diff. tables and databases....e.g.
datbase1
tableA
fld1 fld2 fld2
database2
table B
fld4 fld5 fld6
so connect thr. 2 diff. recordset....
fld1 to fld5
and then add this output in combo box .... like
combo1.additem rs1!fld1, rs1!fld2, rs2!fld4 , rs2!fld6
Depends.
SQL server 6.5 on same server - yes
SQL server 6.5 on different servers - no
Sql server 7.0 - appears to be yes
Access (any version) without attached tables - no
Access with attached tables - yes
The two tables will need to have a field in common (name does't have to be but the data type and content need to be).
You'll only need one ADO connection to do it, if you can do it.
Great to know. But how
To open two databases in one ADO connection?
And what is attacted table?
lupus
Quote:
Depends.
SQL server 6.5 on same server - yes
SQL server 6.5 on different servers - no
Sql server 7.0 - appears to be yes
Access (any version) without attached tables - no
Access with attached tables - yes
The two tables will need to have a field in common (name does't have to be but the data type and content need to be).
You'll only need one ADO connection to do it, if you can do it.
If you have your tables attached (MS ACCESS), your SQL syntax is the same as joining two tables native to that database
example:
Select * from Customers, Orders where Orders.CustID = Customers.CustID
Customers could be an attached table from another database, or it could be a regular table in the same DB
HTH
Tom