How to fetch data from other data base

[aviansh]

Hi Experts,

I am using sql server 2005. I have two database in same server i.e. DB1 and DB2. DB1 contains table1 and DB2 contains table2.

i have to run a sql query in DB2 to fetch data from table1 and to update in table2.

Please suggest.

Thanks in advance.

[deepuv04]

Hi Experts,

I am using sql server 2005. I have two database in same server i.e. DB1 and DB2. DB1 contains table1 and DB2 contains table2.

i have to run a sql query in DB2 to fetch data from table1 and to update in table2.

Please suggest.

Thanks in advance.

HI
If you have both the database on the same server

use the following query to read the data

select * from Database_Name.dbo.Table_Name

to update data

UPDATE Table_Name
SET ColName= (select Col_Name from Database_Name.dbo.Table_Name where Your_Condition)

[aviansh]

Thanks Deepu..It's working fine.

[tomalex]

i have a db in mysql and msacces for a single project and a login page also

both the db have registration details with login information

for now login is fetching values from msacces db

now i want to also check values from mysql db and ms acces db while im trying to login

how can it be done , can uprovide code for connect