AnsweredAssumed Answered

How To Connect to multiple FM Projects via ODBC

Question asked by akselsoft on Oct 8, 2012
Latest reply on Oct 8, 2012 by akselsoft

Hey all,

 

I'm new here but have worked with DBs for a while and am trying to see if this is even possible. We have two databases (projects) - both are set up for sharing. If I create a single ODBC connection, can I connect between both databases?

 

For example, in SQL Server, I would do something like:

SELECT * FROM database.dbo.customers join database2.dbo.orders on customers.cust_id=orders.cust_id

 

Is that possible or do I need to create two separate ODBC connections and then join the two solutions together?

 

 

Thanks in advance.

Outcomes