Querying data across two different data sources (one SQL and the Other Oracle) RRS feed

  • Question

  • What is the proper way to create a query using the tableadapters or designer to query across multiple data sources.  In the designer it appears
    that the queries can only contain information from one datasource at a time.

    Any suggestion how to accomplish.  I would like to take a table from an SQL datasource and use some of its fields to query into an Oracle database on a different datasource and server.

    Monday, March 30, 2009 4:19 PM