Showing posts with label involve. Show all posts
Showing posts with label involve. Show all posts

Wednesday, March 28, 2012

Link SQL2000 and Oracle

hi, does anyone know how to link SQL2000 to Oracle? because i need to use a sql statement which involve both the SQL2000 table and an Oracle table.

Thanks in advance.You have two choices here:

either you create two connections and retrieve from each database what is needed into datasets and use that data then (works without a problem), or you set up a linked database in SQL server that points to the Oracle database ...
If you do not know how to do that second one, go for the first solution ...|||thanks for the solutions..