<div>
<div class="content wysiwyg-content">
I have been assigned to create a web form using ASP.NET/C# that pulls in information from two different databases.<br />
<br />
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.<br />
<br />
I am guessing (from what I have read) that I am supposed to accomplish this by using the linked servers functionality of SQL Server. &nbsp;However, I am totally new to the concept.<br />
<br />
Am I going down the right route to accomplish a joining of data in these two databases? &nbsp;If so, is it then a more difficult process to create these queries through my ASP.NET web form?
</div>
</div>


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?

Displaying data from MS SQL Server and Progress Query

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications