GatRed Posted October 11, 2022 Share Posted October 11, 2022 Hi, 1rst question : Do anybody manage to use the "link to database" via ODBC on a Mac ?. Is there any precise tutorial ? the help is not complete. 2nd question : Can the database be a Synology hosted mariaDB one ? Quote Link to comment
Pat Stanford Posted October 11, 2022 Share Posted October 11, 2022 Take a look at this thread. Quote Link to comment
GatRed Posted October 11, 2022 Author Share Posted October 11, 2022 35 minutes ago, Pat Stanford said: Take a look at this thread. Hi Pat, I’ve got to look at closer this question of mysql. Thanks Pat. I’ll post an update to say whether it is the same on macOS or not. Quote Link to comment
GatRed Posted October 11, 2022 Author Share Posted October 11, 2022 I confirm that there a difference between mac and PC at this point : the help says : But I managed to install the MySQL drivers on my mac… Quote Link to comment
ashot Posted April 5, 2023 Share Posted April 5, 2023 (edited) About "link to database" via ODBC on a Mac Using 64-bit ODBC Manager 1.0.2.2 on a Mac I can see, test, access to my Filemaker PRO v19.6.3 Database from other applications such as Excel. But I am getting the Driver Error all the time when I try to do this using Vectorworks. Any help will be greatly appreciated. DRIVER ERROR IM004 SQLAllocEnv () FAILED (by the way SQL AllocEnv should not be used by the Driver, since it is depreciated after 2016, and replaced with SQLAllocHandle () https://learn.microsoft.com/en-us/sql/odbc/reference/syntax/sqlallocenv-function?view=sql-server-ver16 In a backward sequence I will make four posts starting with this first post message to show: A - Error Vectorworks NOT GOOD B - FileMaker OK C - ODBC Share OK D - Excel OK Below is the first A - Post with Screenshots: Edited April 5, 2023 by ashot Quote Link to comment
ashot Posted April 5, 2023 Share Posted April 5, 2023 My Second Post B) OK - for FileMaker Pro 16.3 Setup for Sharing 1 Quote Link to comment
ashot Posted April 5, 2023 Share Posted April 5, 2023 my Third Post C) OK - ODBC Share 1 Quote Link to comment
ashot Posted April 5, 2023 Share Posted April 5, 2023 my Fourth Post D) OK to access Database from Excel 2 Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.