Filemaker Pro ODBC

[ChuckS]

I wanted to connect to ODBC in Filemaker. When going to add DSN "Filemaker ODBC" did not show up. I had to download  "FM18_xDBC_18.0.1.exe". When I ran this program it flashed and disappeared. Apparently is justed unzip to the same directory and made a folder "FileMaker 18 xDBC\ODBC Client Driver Installer" in that folder is 2 installers, FMODBC_Installer_Win32, FMODBC_Installer_Win64. The both need to be install appartently according to "https://www.youtube.com/watch?v=8T_M8lDwGg0"  here is a guide to finishing. "https://fmhelp.filemaker.com/docs/edition/en/fm_odbc_jdbc_guide.pdf"

more later

[ChuckS]

After running the two exe's, I was able to see the "Filemaker ODBC" file in the DSN and was able to create a DSN. The problem after creating a DSN is it isnt a file. It use to be a file but no longer is. IT is in the registry. So to use a DSN, you need to use a ADO string command. Not useful for the Labview database VI's. the ADO connection string was "DSN=AssetTest;UID=admin;(for those using LAbSQL)" I configured AssetTest to point to my database in the setup for "Filemaker ODBC". To make this useful for Labview, I had to make a UDL link. This is done by going into Tools menu in labview and selecting "create datalink ...". Once you have done this, use the path to that link to access the database. The connection information will be like this "C:\Program Files (x86)\National Instruments\LabVIEW 2015\Database\AssetTest.Udl"

Now you should be on your way !

~Chuck

[ChuckS]

Dont forget to register in C:\Windows\SysWOW64\odbcad32.exe for 32bit applications

and

Control Panel>Administrative Tools> Data Sources(ODBC) for 64bit

[ChuckS]

image of labview database connection

[ChuckS]

Another example image

[wiebe@CARYA]

I tossed you some kudos.

I don't think I'll ever use it (but who knows). I do appreciate when people share their efforts and knowledge.

And they're free.