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

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.

Thanks I will look into that!

Geoff