Filemaker ODBC (802) Unable to open file

[FMPierce]

I am doing the FileMaker Training series and am stuck at ODBC sharing with FileMaker.

Upon testing the FileMaker DSN in ODBC Administrator and entering the correct login info it gives me this error:

[FileMaker][FileMaker ODBC] (802): Unable to open file



Test failed.

In addition, the DSN doesn't connect to localhost, 127.0.0.1, or the IP address of my computer to obtain names of available databases.



Here are my DSN settings:

FileMaker ODBC Driver 11.0.58



Data Source Name: bonsai

Description: bonsai

Host: localhost

Database: 11b_Bonsai.fp7

Auto-detect Language Settings: Yes

Log Long Running Queries: No

[mr_vodka]

Did you turn on Sharing -> ODBC/JDBC and also make sure that the user account that you are using has access via ODBC? If not try turning it on for all users.

[FMPierce]

Yes. ODBC/JDBC sharing is on and all users have access to ODBC.

[FMPierce]

I have a previous instill of FileMaker server 11 trial that is expired if that makes a difference.

[mr_vodka]

I dont have a mac at this moment and I dont know if it is a platform specific issue. That being said, a few more questions.

You have FileMakerPro running on your machine with the file open at the time that you are trying to ODBC connect locally on the same computer correct?

Are you patched up?

You may also want to read this as to see if you missed anything.

http://help.filemaker.com/app/answers/detail/a_id/7866/kw/odbc%20vista

[FMPierce]

Yes FileMaker is running while i am accessing the file via ODBC.

What do you mean by "patched up"?

[mr_vodka]

The latest update version.

http://www.filemaker.com/support/downloads/

[FMPierce]

I updated filemaker and still can't open the file, also whenever i open a file in filemaker it comes up with a dialog box that says:

FileMaker cannot share files because another user is already sharing files using FileMaker Pro on this computer.

[FMPierce]

I also have a VirtualBox VM with filemaker installed on my computer if that could make a difference.