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 >>
- Start ODBC Data Source Administrator,
- Run
%WinDir%\System32\odbcad32.exe
. - Run
%WinDir%\SysWoW64\odbcad32.exe
- for 32 bit TOTVS | DBAccess in 64 bit operating systems.
- Create a new database.
Use driver MySQL ODBC Driver ANSI. - Change the new datasource in accordance with its database access information and:
- Select option Allow multiple statements.
- In selection box Character Set, select latin1.
- Save the database.
Linux >>
- Create a new data source by following its driver model.
Use driver MySQL ODBC Driver ANSI. - Open file odbc.ini for editing.
- Change the new datasource in accordance with its database access information and configure the following keys:
- In charset, enter latin1.
- In MULTI_STATEMENTS, enter 67108864.
- Save the file.