
July 5th, 2001, 07:54 PM
|
|
Contributing User
|
|
Join Date: Dec 2002
Posts: 14,575
  
Time spent in forums: < 1 sec
Reputation Power: 22
|
|
|
Combine two DB/RS
<i><b>Originally posted by : Raphel (raphel.girma@foveon.net)</b></i><br /><br />I have MS Access and SQL Server databases both have to track Employees inf for various uses.I have employees table in both DB that have identical EmpID. Based on this how can I write ASP code that access both databases and do SELECT from this two DBs to display employee inf.<br />How to setup two ODBC connections, two recordsets and do joins.<br /><br />ex. select * from EmployeeAccessTable, EmployeeSqlServerTable where EmployeeAccessTable.empid = EmployeeSqlServerTable.empid
|