Is it possible to query two separate oracle databases with one call?

[burak]

Hello,

 

Is it possible to join two tables on two separate oracle databases?

 

I would like to have two connections to two databases and execute a query joining two tables in each db.

 

Dim connString1 As String = "Data Source=ds1;etc.."

Dim connString2 As String = "Data Source=ds2;etc.."

 

Dim conn As New System.Data.OracleClient.OracleConnection(connString1)

Dim conn2 As New System.Data.OracleClient.OracleConnection(connString2)

 

Is this possible?

 

Thanks,

 

Burak

[pelikan]

I presume you know the schema of these tables?

 

you create a DataAdapter for each table.

map the columns to a table you set up in your DataSet.

(different mapping for each Oracle table I suppose)

 

then Fill the same DataTable (the one mapped to the DataAdapters)

with each DataAdapter.