Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
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
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