Solve ODBC issues

ODBC (Open DataBase Connectivity):

  • a parameterstring in a MS Access VBA module for MySQL databases:
    Public Const gloODBCParameters As String = “PORT=3306;SSLmode=verify-full;TextAsLongVarchar=0;UseDeclareFetch=0;LANGUAGE=us_english;INITSTMT=set wait_timeout=600;FOUND_ROWS=1”;
  • the 32 bits driver {MySQL ODBC 8.0 Unicode Driver} works on my pc in MS Access;
  • port 3306 for MySQL in the firewall for TCP In and TCP6 In;
  • in Linux in /etc/my.cnf ‘bind-address =’ to ‘#bind-address =’ and restart of the server may be needed;
  • databases are authorized for a personal IPv4;
  • in Windows 10: network/ODBC/’trace started’ slows down connectivity;
  • a provider may switch an IPv6 address all the time for privacy. This setting lets me use the IPv4 address as server name (if using IPv6: between brackets).

I can send VBA statements on request