ODBC Drivers for FileMaker 13
Trying to following the instructions from http://help.filemaker.com/app/answers/detail/a_id/7700/~/installing-odbc-and-jdbc-for-filemaker-11... but can not locate the FMODBC file or folder. I am able to import the from SQL server when I do it manually but not when I go into the Relations and try an connect directly to the SQL Source.
Atttach #1 - is from the Relationship section making a direct link to the tables.. Does not work
It looks like you set up your DSN as a User DSN. ESS requires that you use a System DSN.
Can both USER and SYSTEM DSN be configured at the same time or do I need one or the other ? Have a User DSN setup that works, I also have a System DSN but I can not see it when I try to find it in the Manage Database/Relationship tab.. as seen below .. Attach is my System DSN setup and successful test connection... Not sure what's causing me not to see it under the Manage DatabaseRelationship tab
Any ideas, I have removed both setups and tried just the System DSN but still does not work
OK.. found one solution.....went into the Windows\SysWOW64\ and reran the odbcad32.exe file... A list of all ODBC drives came up... choose the SQL ODBC ( at the bottom of the list) and setup the DSN from there... went back into filemaker Data Management/relationship ODBC option has the new ODBC connection listed.
Note: I am running Windows 7... I believe what i have done is replaced my Original ODBC with and older version.. So be careful.
Attach #2 From the Main menu... File, Import, it works