I'm hoping to be able to have a two way connection to Revit - (3D architectural CAD software). Apparently it can write and read to;

Microsoft® Access

Microsoft® Excel

Microsoft® SQL Server

Does anyone have any opinion on which might ODBC Driver would offer the best conduit between the FM and Revit. We run FMServer advanced. I don't believe updates need to be live but would need to push and pull as required.

A couple of other considerations;

FMServer will be on Mac and CAD soft ware on PC.

Its possible that container fields might need connectivity but am not sure at this stage.

cheers John

I have discovered that Microsofts Query X doesn't work in Lion. Im not sure if it is needed but does this make the approach DOA?

I wonder if it would work with SQL Express, which Microsoft offers for free, or if you'd require a full-blown SQL Server installation. If it will, you might try that. Microsoft Query would not be involved, but just for reference I run on a OS X Lion system and I can use ODBC in Excel 2011, and the Microsoft Query tool, so I guess they updated it.

Getting Actual Tech's ODBC drivers on your Mac for SQL Server would (if it would work at all) talk to the SQL Express installation on the Windows computer that Revit talks to.