Scenario

i have 2 databases . 



First database is contains the following tables



products

categories



Second Database contains(its in my SSL site)



customers 

orders

orderdetails(fields are product code,price etc)



the second database is situated in a secured server because it contains 

some credit cards information.

 

i want to design an asp page which will get information from both the 

databases. basically it will match the product code from teh second 

database and pull the correct name from the first database.



plz let me know of how can i achieve this. i am using sql server and i 

heard that i need to use linked server technology havent got a clue of how 

to do it.



thanks in advance

taher