anneg2
asked on
ADO and Join of two tables located on different servers
Using VB6 - ADO 2.7 - SQL Server:
Need to retrieve data from a join of two tables located on separate servers. I know how
to open and retrieve from a single server ... but not from multiple servers. Please provide the syntax for opening a recordset
from more than one server.
Need to retrieve data from a join of two tables located on separate servers. I know how
to open and retrieve from a single server ... but not from multiple servers. Please provide the syntax for opening a recordset
from more than one server.
ASKER
The issue is that table1 is on server1 and table2 is on server 2 and the sql stmt (if the servers were linked) would be select server1.dbname.tablename T1, server2.dbname.tablename T2 where T1.xx = T2.xx......
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
<%
set conn=Server.CreateObject("
conn.Provider="Microsoft.J
conn.Open "c:/webdata/northwind.mdb"
set rs = Server.CreateObject("ADODB
rs.Open "Customers", conn
%>Open an ADO SQL Recordset:
<%
set conn=Server.CreateObject("
conn.Provider="Microsoft.J
conn.Open "c:/webdata/northwind.mdb"
set rs = Server.CreateObject("ADODB
rs.Open "Select * from Customers", conn
%>
just create two connections--one for each server and just called the correct one when you need the data.