Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2007
    Posts
    2

    Unanswered: Query Multiple SQL databases

    Hi

    I want to link a field from an MSSQL db with a field from a MySQL db then perform a query to produce a report.

    I can do this no problem with a single database with PHP but with two db's on different platforms I cant do it.

    Is there any free reporting software that will do this?

    I've looked into LogiXML which is free but found that too difficult to understand plus there is not much support for what I want to do.

    Thanks

    Geoff

  2. #2
    Join Date
    Mar 2005
    Location
    Netherlands
    Posts
    280
    An option could be a linked server (see http://dbforums.com/showthread.php?t=1204962 for some info). The query should be run from SQL Server.

  3. #3
    Join Date
    Jan 2007
    Posts
    2
    Thanks I will look into that!

    Geoff

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •