Re: Starting off with MySql ODBC

[PK Odendaal]

Thank you so much Peter.

I have studied your links which were very informative and I have succeeded in naming a DSN called IBSMSfreestate (see attachment).
Under mysql I have registered a user Peka with password 2462 with full authority with Workbench.

However, now I have a problem with opening the connection:

Dim wsODBC As Workspace
Dim Conn As Connection
Set wsODBC = DBEngine.CreateWorkspace("ODBCWorkspace", "admin", "", dbUseODBC)
Workspaces.Append wsODBC
Set Conn = wsODBC.OpenConnection("Conn1", , , "ODBC;DRIVER={MySQL ODBC 8.0};DATABASE=ibsms;PWD=;DSN=IBSMSfreestate")

The error is 'ODBC call failed'.

Maybe my syntax or values are not correct.