You can, check out articles on Oracle "Linked Server" and you should find the materials you need for it.
--- Burak Gunay <[EMAIL PROTECTED]> wrote: > > The tables are not in the same database, they are > in > different databases. > > --- DJ Sampson <[EMAIL PROTECTED]> wrote: > > The connection string is for a connection to the > > database itself - if your tables are both within > the > > same databae, you'd just use a join in your sql > > statement to view items from each (related to one > > another) > > > > Burak Gunay <[EMAIL PROTECTED]> wrote: > > 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 > > > > > > > > > > __________________________________ > > Do you Yahoo!? > > Friends. Fun. Try the all-new Yahoo! Messenger. > > http://messenger.yahoo.com/ > > > > Yahoo! Groups SponsorADVERTISEMENT > > > > > > --------------------------------- > > Yahoo! Groups Links > > > > To visit your group on the web, go to: > > > http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ > > > > To unsubscribe from this group, send an email > to: > > [EMAIL PROTECTED] > > > > Your use of Yahoo! Groups is subject to the > > Yahoo! Terms of Service. > > > > > > > > > > --------------------------------- > > Do you Yahoo!? > > Friends. Fun. Try the all-new Yahoo! Messenger > > > > [Non-text portions of this message have been > > removed] > > > > > > > > > > __________________________________ > Do you Yahoo!? > Friends. Fun. Try the all-new Yahoo! Messenger. > http://messenger.yahoo.com/ > __________________________________ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/ ------------------------ Yahoo! Groups Sponsor --------------------~--> Yahoo! Domains - Claim yours for only $14.70 http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
