I have been assigned to create a web form using ASP.NET/C# that pulls in information from two different databases.
The web form with be connected to MS SQL Server and I want to be able to join data from a table in MS SQL Server and a Progress DB.
I am guessing (from what I have read) that I am supposed to accomplish this by using the linked servers functionality of SQL Server. However, I am totally new to the concept.
Am I going down the right route to accomplish a joining of data in these two databases? If so, is it then a more difficult process to create these queries through my ASP.NET web form?