Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post May 02, 2012 08:59 AM by dotnetpree
Member
431 Points
232 Posts
May 01, 2012 04:35 PM|LINK
How do i query into multiple database and return results based on SSN? I am using visual studio and i have connection string for SQL and Access in webconfig.
Access: Database Name: User data.mdb table: UserInformation field: SSN field: Dept SQL: Database name: sql2.UserTracking.dbo table: User_Info field:SSNO field: FIRST NAME
Contributor
3970 Points
1096 Posts
May 01, 2012 04:47 PM|LINK
Set up linked tables to the sql db in your access db.
164 Points
41 Posts
May 02, 2012 08:59 AM|LINK
select * from User data.dbo.UserInformation as t1 inner join sql2.UserTracking.dbo.User_Info as t2 on t1.SSN = t2.SSNO
spyxdaxworld
Member
431 Points
232 Posts
query on multiple databases
May 01, 2012 04:35 PM|LINK
How do i query into multiple database and return results based on SSN? I am using visual studio and i have connection string for SQL and Access in webconfig.
Access:
Database Name: User data.mdb
table: UserInformation
field: SSN
field: Dept
SQL:
Database name: sql2.UserTracking.dbo
table: User_Info
field:SSNO
field: FIRST NAME
Dan Bracuk
Contributor
3970 Points
1096 Posts
Re: query on multiple databases
May 01, 2012 04:47 PM|LINK
Set up linked tables to the sql db in your access db.
dotnetpree
Member
164 Points
41 Posts
Re: query on multiple databases
May 02, 2012 08:59 AM|LINK
select *
from User data.dbo.UserInformation as t1
inner join
sql2.UserTracking.dbo.User_Info as t2
on t1.SSN = t2.SSNO