Manage External Data Sources and missing System DSN (FM Pro 12)
I have been unable to link a SQL Server db to FileMaker using the Manage External Data Sources. Below are the steps I take:
3. External Data Sources
5. Type: ODBC
When I click Specify, there are no data sources listed.
I am running Windows 7 and when I check the ODBC Data Source Administrator, the SQL Server driver is listed as a System DSN.
What's interesting is that I am able to import a record using an ODBC Data Source.
2. Import Records
3. ODBC Data Source
At this point I am able to select any of my User DSN.
4. SQL Server driver
6. Enter my SQL server login info
7. My tables and other objects are available for me to select in forming an SQL query statement.
Is there something further I must do to have my SQL Server database appear in the Manage External Data Sources section?
I found an earlier post: http://forums.filemaker.com/posts/c30809257e
The issue was that I needed to install the 32 bit ODBC driver using the 32 bit version of the ODBC app.
"\windows\SysWOW64 directory and run 'odbcad32.exe'"