Connector/ODBC is a standardized database driver for Windows, Linux, Mac OS X, and Unix platforms. Online Documentation: MySQL Connector/ODBC Installation.
![]()
4D v15.2
Installing an ODBC driver on OS X
To install the ODBC Driver:
[ODBC Drivers]
Note: You must create this odbcinst.ini text file if it does not already exist.
You can now launch the ODBC Manager located in the 'Applications/Utilities/' folder in order to create a Data Source Name (DSN) or you can use the one provided with the iODBC framework.
Note: Since Mac OS X 10.6 Snow Leopard, the ODBC Administration Tool is no longer provided as standard. However, it can be downloaded from here:
http://support.apple.com/kb/dl895
By clicking on the 'Drivers” tab, you can check that the 4D ODBC Driver is correctly installed:
This window provides you with the complete path name for each driver installed.
You can do the same with the iODBC Administrator:
Here you can also see the version number but only for 32-bit versions.
Note: Beginning with version 14R2, version numbers include the subversion and modification date in the form: <Version><Subversion><Year><Month+Day>
For example: '14.2.2014.0217', this indicates the 14R2 version modified on February 17, 2014.
To add a DSN using the 4D ODBC Driver:
Note: You may encounter the following anomalies when creating a DSN via the Mac OS X ODBC Administrator:
The fields of these dialog boxes need to be filled in with the following information:
Clicking on the Advanced >> button gives you access to additional options as shown here:
Timeouts (Seconds)
Favorite image formats
Pictures stored in 4D databases are retrieved by ODBC as Blobs. This setting lets you select the formats you prefer. By default, if you do not choose any favorites, 4D selects the best format available with respect to screen display.
When you choose one or more formats, 4D only provides one of those formats (in order of preference). If there are no pictures available in any of your favorite formats, 4D converts the pictures to the first format in the list.
For example, if you have selected GIF and JPEG as your favorite image formats:
4D first checks whether there are any .gif or .jpeg formats available. If neither are available, then it converts the formats to .gif since it is first in the list.
Encoding: sets the text encoding.
Cache Settings: used to modify how the network handles the cache. Generally, these settings should be left untouched.
Compatibility: settings to enable the ODBC Driver to work properly with OpenQuery and MSAccess. They should only be checked if you encounter problems with these particular applications.
The 64-bit driver is faceless but there are two ways to create a 64-bit DSN:
Using the 32-bit driver
![]()
You can use the 32-bit ODBC driver to create a 32-bit DSN and then modify this DSN directly from the /Library/ODBC folder. Just open the /Library/ODBC/odbc.ini text file in a text editor and make the following edits:
Using the ODBC Administrator or the iODBC Administrator
![]() Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |