Did you turn on 'Access via ODBC/JDBC' in the Extended Privileges window for the database?
Under 'Sharing', 'ODBC/JDBC' for the database, is ODBC/JDBC turned on for the host, and ODBC/JDBC access turned on for the database?
Yes I did turn it on from the client also. Not sure why the ODBC driver setup is failing. Is the error on the client software or with the ODBC driver. It seems like the ODBC driver.
Anyone? Please help... All out of options. Thank you.
To be honest, I can't remember if I ever setup FileMaker Pro as an ODBC host - I use the Server version for all hosting. According to the article in the link below, FMP as an ODBC host should work, maybe FM folks can confirm. And, just to clarify, what computer/OS did you install the ODBC drivers on?
The OS on all systems are XP. Thank you.
Thank you all for your posts, and I apologize for the late reply. This is one of those threads that was lost.
Yes, the ODBC driver that comes with FileMaker Pro allows a FileMaker database to be used as a data source.
Although you turned on the ODBC/JDBC in the extended privileges, did set access to this file to "All users"?
Since you are using FIleMaker Pro, make sure you are accessing the ODBC locally. You will not be able to do it remotely (except through FileMaker Server).
If you are able to access the file, but still get "Authorisation error", what is the SQL statement being sent?