FileMaker Pro 7.5, Windows 7 Pro 64 bit and ODBC

I am new to FileMaker.

I would like to be able to access several FileMaker Pro 7.5 databases from an application using ODBC.

I have FileMaker Pro 7.5 installed on the PC with the databases. The OS is Win 7 Pro 64 bit.

Has anyone managed to get FileMaker Pro 7.5 ODBC working with Win 7 Pro 64 bit?

How can I do it?
LVL 13
akbAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Will LovingPresidentCommented:
To restate, you are wanting to use FileMaker as an ODBC source for other applications. I don't know if you'll succeed in doing this because both FileMaker and the ODBC drivers are 32-bit, but you can certainly try. The best resource for this is the FileMaker ODBC/JDBC guide, a version of which can be found here:

http://www.filemaker.com/support/product/docs/11/fmp/fm11_odbc_jdbc_guide_en.pdf

This is the FileMaker 11 version. If you look in the FileMaker Server 7.5 application folder, Documentation folder, you may find and earlier version of this guide but it certainly won't address 64-bit issues.
0
Lieven EmbrechtsSenior IT ConsultantCommented:
Using 32-bit odbc drivers in a 64-bit environment is quite common.

To configure your 32-bit drivers a small trick is required:
in your windows explorer, navigate to the folder Windows / SysWOW64
double-click odbcad32.exe
now you can configure your 32-bit odbc driver.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
akbAuthor Commented:
Thanks for the replies. I will try Lieven's "trick" and report back.
0
akbAuthor Commented:
Lieven's "trick" did the job. Thanks so much. It's a shame that filemaker has to be running with the required file open for ODBC to work but I can live with that.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
FileMaker Pro

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.