how to fetch records from two Database into one Application.

if just for join you can use JOIN with SELECT query
Selecting data from different databases[^]

If databases are in different locations or types then
use OPENROWSET[^]
or
OPENDATASOURCE[^]
or
Linked Servers[^]

'Link Server' is your answer...

you can link one server (sql|Oracle or any oledb) to your primary SQL server 2005 databse.. after you have linked it you can query your primary and secondary database as you are wotking on a single server. its very simple too!! :)

find how to setup link server in SQL server at MSDN :)

http://msdn.microsoft.com/en-us/library/ms188279.aspx[^]

mark as answer if satisfied.. it motivates :)

Hello,

Please go through below links


Tool to script Linked Servers in SQL Server 2000[^]


Download the code and use the part of code required for you.

<add name="Constring" ........ />
 <add name="Constringnew" ........../>

String conn = System.Configuration.ConfigurationManager.ConnectionStrings["Constring"].ToString();

String conn1 = System.Configuration.ConfigurationManager.ConnectionStrings["Constringnew"].ToString();

Try this