Link to ODBC Database

[GatRed]

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 ?

[Pat Stanford]

Take a look at this thread.  

 

[GatRed]

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.

[GatRed]

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…

[ashot]

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

[ashot]

My Second Post B)

OK - for FileMaker Pro 16.3 Setup for Sharing

 

 

[ashot]

my Third Post C)

OK - ODBC Share

[ashot]

my Fourth Post D)

OK to access Database from Excel