DBAccess - How to create a data source to use with MySQL

• DBAccess - How to create a data source to use with MySQL - Linux
• DBAccess - How to create a data source to use with MySQL - Windows

An operating system peculiarity makes the steps vary in the procedure to create a ODBC data source, but its parameter settings (sessions and keys) are usually the same, regardless of system type.

Windows >>

1. Start ODBC Data Source Administrator,
1. Run %WinDir%\System32\odbcad32.exe.
2. Run %WinDir%\SysWoW64\odbcad32.exe - for 32 bit TOTVS | DBAccess in 64 bit operating systems.
2. Create a new database.
   Use driver MySQL ODBC Driver ANSI.
3. Change the new datasource in accordance with its database access information and:
1. Select option Allow multiple statements.
2. In selection box Character Set, select latin1.
4. Save the database.

Linux >>

1. Create a new data source by following its driver model.
   Use driver MySQL ODBC Driver ANSI.
2. Open file odbc.ini for editing.
3. Change the new datasource in accordance with its database access information and configure the following keys:
1. In charset, enter latin1.
2. In MULTI_STATEMENTS, enter 67108864.
4. Save the file.