Description: Enter a short description of this Data Source. Configuring your DSN The fields of these dialog boxes need to be filled in with the following information: Data Source Name: Enter a unique name for this Data Source. Click OK to save any changes before you close the configuration panel window. button, this same dialog appears pre-filled with all the DSN characterics.
The 4D ODBC Driver s own configuration panel appears: Note: When you select an existing DSN and click on the Configure. Click the Add button and choose the 4D ODBC Driver from the list of configured drivers:ģ 3. OR System DSN (if you want to make this data source available to all users from this computer, including NT services) 2. This data source can only be used on the current machine). Click on one of the following tabs: User DSN (if you want to make this data source available only to the user currently logged on to this computer. Click on the "Drivers tab to check that the 4D ODBC Driver is correctly installed: To add a DSN using the 4D ODBC Driver: 1. To add a DSN, you launch the ODBC Data Source Administrator by selecting Start/Control Panel/Administrative Tools/Data Sources (ODBC). After running the ODBC Driver installer, you need to define a DSN in order to connect to the desired database. Applications such as Crystal Reports, Word and/or Excel can all be OBDC clients, and you can also write your own OBDC client using Python, PHP, C, C++ or any language that enables ODBC use. For more information about the ODBC Data Source Administrators, please refer to the following Microsoft technical note: Creating a DSN A DSN (Data Source Name) is a set of registry keys that enables an application, the ODBC client, to link to the native SQL Server of 4D or 4D Server. You can retrieve the appropriate ODBC administrator at the following locations: 32 bits: C:\WINDOWS\syswow64\odbcad32.exe 64 bits: C:\WINDOWS\system32\odbcad32.exe Warning: The 32-bit administrator is found in "syswow64" and the 64-bit one is in "system32." Since this is not intuitive, you need to make sure not to mistake one for the other.
Note: If you install the 32-bit Installer on a 64-bit OS, you must use the 32-bit ODBC Data Source Administrator instead of the default 64-bit one. Remember to uninstall any previous versions of ODBC Driver before installing a new one.
You can even install both of the drivers on the same machine. For example, if you are using a 32-bit version of Excel 2010 with a 64-bit 4D Server, then you'll need a 32-bit ODBC Driver.
You can download one (or both) of the following files from the 4D web site: 4D_ODBC_Driver_v14_(32-bit).exe 4D_ODBC_Driver_v14_(64-bit).exe You choose your driver based on the version of your ODBC client, and not that of your 4D or 4D Server.
This is similar to utf8, but its encoding allows up to four bytes per character to enable support for supplementary characters.2 Installation on Windows 4D provides two versions (a 32-bit and a 64-bit) of the ODBC Driver installer for Windows. "The utf8mb4 character set has been added."The Unicode version now uses the UTF8MB4 character set as a transport character set between the MySQL server and the ODBC driver.".MySQL Connector/ODBC 5.3.11 release notes:.However, support for the UTF8MB4 character set was not added to MySQL server until version 5.5.3, so connecting to any server version earlier than this will result in the above error.Īdditional InformationFor more information on this change, see the following MySQL documentation: CauseTableau supports MySQL 5.5 and higher.īeginning with version 5.3.11 and greater, the MySQL ODBC driver began using the UTF8MB4 character set, instead of UTF8. Use the generic ODBC connector from Tableau, and connect using the MySQL ANSI driver, instead of the default Unicode driver (please note that connections using the generic ODBC connector are not supported and may result in limited functionality). Upgrade your MySQL server to version 5.5.3 or later, where the UTF8MB4 character set is supported.ĭowngrade to an earlier MySQL driver version (pre 5.3.11). ResolutionTo avoid this error, use one of the following solutions: This error will only occur with MySQL ODBC drivers version 5.3.11 or greater.This error will only occur when connecting to MySQL server pre-version 5.5.3."Unknown character set: 'utf8mb4'".Īdditional information regarding this scenario: When connecting to MySQL, either via Tableau Desktop or Tableau Server, or via a DNS test, the MySQL Unicode driver returns the error