If you do need 32-bit, run:Ĭopy to Clipboard EXEC = 'Microsoft OLE DB Provider for = 'Driver= Server=lloyds_se Database=/data/soldata/mwheel '
Other changes are required for full functionality.Ĭreate data sources next (you only need one for multiple SE databases on the same host) using:.Errors result unless “Allow inprocess” is set.Start up the SQL Server Management Studio, and find “Linked Servers” in the Object Explorer. OLE DB is not available for Informix SE databases, so you have to use ODBC. Windows 32-bit (4.10.TC5DE) or 64-bit (4.10.FC5DE) matching your SQL Server product.Informix Client Software Development Kit (CSDK).
Contentįirstly, download and install the latest Informix drivers for Windows: This article reveals how to make Microsoft SQL Linked Server and Informix Standard Engine work together.
However, the settings are not obvious that are required to make this work with Informix Standard Engine (SE) – the legacy version of Informix that uses C-ISAM to store tables (*.dat) and indexes (*.idx) in individual files (whereas Dynamic Server manages storage within its own “dbspaces”).
If you where reading about connecting FileMaker Pro to MySQL database with MySQL ODBC driver, you can now go back to the article and proceed with instructions.Microsoft SQL Server is a popular choice for consolidation of report data from multiple database products, as its Linked Server feature – which is included in the base product – makes it possible to access tables in heterogeneous databases within T-SQL via OLE DB or ODBC. By defauld, the 32bit ODBC driver will be installed in: C:\Program Files (x86)\MySQL\Connector ODBC 5.1, while the 64bit ODBC driver will install inside:C:\Program Files\MySQL\Connector ODBC 5.1, and you should be able to configure it using your Control Panel\Administrative Tools\Data Source (ODBC) path. The two drivers will not be installed in the same directory so you could use automatic install feature for both of them.
Please notice that 64 bit applications WILL NOT be able to use the 32 bit driver, so if you are connecting some other, 64 bit application, for example MS Access 2010, you will need to install a 64 bit driver as well, and configure it via the usual path: Control Panel\All Control Panel Items\Administrative Tools\Data Sources (ODBC) In this way, FileMaker Pro as a 32 bit application will be able to recognise and use the ODBC driver installed on a 64 bit Operating System. Here you will be able to see your 32 bit ODBC driver and configure it to connect with the MySQL database, in the same way as you would do on a 32 bit system.