build report from two seperate databases?

[jpicks]

I am trying to build a single report that uses tables from two seperate db's. One is in sql server v. 6.5 and the other is in sql server 2000. I am trying to connect to both using odbc connections.


Currently I have been importing data from sql 6.5 to sql 2k and running the report off of sql 2k.

Any help or suggestions would be greatly appreciated!

 

[synapsevampire]

You can do some simple reporting in this way, but I'd likely approach this with a stored procedure.

You can also link the tables into MS Access and build a query to report off of.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com