5 Replies Latest reply on Mar 2, 2015 6:55 AM by TracyBogans

ODBC Drivers for FileMaker 13

TracyBogans Feb 26, 2015 8:29 AM

Title

Post

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

1. Re: ODBC Drivers for FileMaker 13

TracyBogans Feb 26, 2015 8:30 AM (in response to TracyBogans)

Attach #2 From the Main menu... File, Import, it works
Like Show 0 Likes(0)

Actions
2. Re: ODBC Drivers for FileMaker 13

erawson Feb 26, 2015 12:55 PM (in response to TracyBogans)

It looks like you set up your DSN as a User DSN. ESS requires that you use a System DSN.
Like Show 0 Likes(0)

Actions
3. Re: ODBC Drivers for FileMaker 13

TracyBogans Mar 1, 2015 5:15 AM (in response to TracyBogans)

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
Like Show 0 Likes(0)

Actions
4. Re: ODBC Drivers for FileMaker 13

TracyBogans Mar 2, 2015 4:47 AM (in response to TracyBogans)

Any ideas, I have removed both setups and tried just the System DSN but still does not work
Like Show 0 Likes(0)

Actions
5. Re: ODBC Drivers for FileMaker 13

TracyBogans Mar 2, 2015 6:55 AM (in response to TracyBogans)

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.
Like Show 0 Likes(0)

Actions

Go to original post