db connection for a single command

[brettokumar]

hi i hav different database i have to link all database table in a single query. how many db-connection can i use in a single command. in asp.net+c#

[r035198x]

Which database are you using? Are the databases on the same computer? Are they on the same RDMS i.e are they all MyQL databases or one is MySQL while the other is SQL Server?

[brettokumar]

Which database are you using? Are the databases on the same computer? Are they on the same RDMS i.e are they all MyQL databases or one is MySQL while the other is SQL Server?

using oracle database server only but have different database

[r035198x]

using oracle database server only but have different database

Create the connection as a user with access to both schemas and just prepend the schema and database names to the table names in the select statements