4D v15.2

Odbc Administrator Tool For Mac Os X High Sierra
Odbc Administrator Tool For Mac Os X

Installing an ODBC driver on OS X

ODBC Administrator Tool for Mac OS X enables database administration of ODBC-compliant data sources. Features include connection pooling, trace log creation, and ODBC driver management, among other administration features.

The MySQL Connector/ODBC 2.5.6 for Mac OS X comes only in versions for 10.6 (Snow Leopard) and 10.7 (Lion). I don't know about any official support from MySQL for Mac OS X versions 10.8 (Mountain Lion) or even 10.9 (Mavericks)! Paid licensed solutions put more effort on supporting the latest Mac OS X versions.
The Mac OS X environment has a GUI interface for creating and configuring an IBM Informix ODBC data source name (DSN). This utility is the ODBC Administrator. This utility is the ODBC Administrator. Connection string keywords that make a connection.
Essential Mac tools Nos. 16, 17, and 18: OS X Server, Apple's Open Directory, and Profile Manager. OS X may support Active Directory, but Apple's native directory is an LDAP-based solution called.

To install the ODBC Driver:

Odbc Administrator Tool For Mac Os X High Sierra

Copy the 4D ODBC x64.bundle and/or the 4D ODBC x32.bundle into the {Library}/ODBC/ folder
Open the odbcinst.ini text file found in the /Library/ODBC/ folder with a text editor and modify it as follows:

[ODBC Drivers] 
4D ODBC Driver 64-bit = Installed
4D ODBC Driver 32-bit = Installed
[4D ODBC Driver 64-bit]
Driver = /Library/ODBC/4D ODBC x64.bundle/Contents/MacOS/4D ODBC x64
Setup = /Library/ODBC/4D ODBC x64.bundle/Contents/MacOS/4D ODBC x64
APILevel = 2
ConnectFunctions = YYN
DriverODBCVer = 3.52
FileUsage = 0
SQLLevel = 3
[4D ODBC Driver 32-bit]
Driver = /Library/ODBC/4D ODBC x32.bundle/Contents/MacOS/4D ODBC x32
Setup = /Library/ODBC/4D ODBC x32.bundle/Contents/MacOS/4D ODBC x32
APILevel = 2
ConnectFunctions = YYN
DriverODBCVer = 3.52
FileUsage = 0
SQLLevel = 3

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:

Click on the System DSN tab
Note: On Mac OS X, we recommend that you use a System DSN and not a User DSN.
Click the Add button and choose the 32-bit 4D ODBC Driver from the list of configured drivers:
Click OK.
The 4D ODBC Driver’s own configuration panel appears:
Click OK to save any changes before you close the configuration panel window.

Note: You may encounter the following anomalies when creating a DSN via the Mac OS X ODBC Administrator:

When you create a new DSN, you may not see it right away and may need to quit and restart the Mac OS X Administrator in order for it to appear.
Even if you add a new ODBC User data source, the ODBC Driver will create it as a System DSN.
These anomalies are both due to bugs in the Mac OS X ODBC Administrator and have nothing to do with the 4D ODBC Driver or Installer.

The fields of these dialog boxes need to be filled in with the following information:

Odbc administrator tool for mac os x el capitan

Data Source Name:
Enter a unique name for this Data Source.
Default: '.
This field is mandatory.
Description:
Enter a short description of this Data Source.
Default: '.
This field is optional.

Server Address:
Examples:

'localhost'	The 4D application is located on the local machine.
'PC-1'	The 4D application is located on the PC-1 machine, published on port 19812 (default port).
'148.1.2.3'	The 4D application has the IP address 148.1.2.3.

Default: 'localhost'.
This field is mandatory.

Port:
Enter the 4D access port.
Default: '19812'.
This field is optional.
SSL checkbox:
Checking this option enables connection to the 4D Server if the “Enable SSL” option has been set on the SQL/Configuration page of the Database Settings.
User:
Enter the user name used to test the connection with 4D.
Default: '.
This field is optional.
Password:
Enter the password used (in conjunction with the user name) to test the connection with 4D.
Default: '.
This field is optional.
Test button
Tests the connection with the current parameters.
Uses “User Name” and “Password” fields to login.

Clicking on the Advanced >> button gives you access to additional options as shown here:

Timeouts (Seconds)

Connection:
Enter the timeout in seconds to be used (0 means no timeout) after you log in for the driver to connect to a socket on the server:port address.
Default: '.
This field is optional.
Login:
Enter the timeout in seconds to be used (0 means no timeout) when the driver sends a request and receives the status from the server.
Default: '.
This field is optional.
Query:
Enter the timeout in seconds to be used (0 means no timeout) when waiting for a response after a query to the server.
Default: '.
This field is optional.

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.

UTF-8 (Unicode) (recommended)
System (depends on the settings of your OS)

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, or
using the ODBC Administrator.

Using the 32-bit driver

You can use the 32-bit ODBC driver to create a 32-bit DSN and then modify