I am looking how to join two different tables from two different databases into one datagrid view. To make things more clear I am using two different connection strings to get the data.I perfer VB but if I need to use c# I can adapt.

Re: Join SQL Databases from different servers 80 80

Are they linked servers? SQL Server or MySQL?

If linked, you can do as suggested here:
http://stackoverflow.com/questions/1144051/selecting-data-from-two-different-servers-in-sql-server

That link also gives examples on how to set them up, but it looks like its MSSQL specific.

Short of it, make a linked server, and then use the full linked path when joining against it from the "local" server.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.