1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
|
# How to build iODBC for macOS (formerly known as _OS X_ and _Mac OS X_)
Copyright © 1996-2023 OpenLink Software <iodbc@openlinksw.com>
## Method 1: Using Project builder
This build method only works for Xcode 8.0 or newer.
This version of Xcode was first supported on macOS El Capitan (10.11), however the resulting binaries
are backward-compatible with OS X Mavericks (10.9) and newer.
OpenLink uses build environments on macOS Mojave (10.14) and macOS Big Sur (11.x) to produce suitable
notarized installers with graphical components.
To build iODBC components yourself, you will first need to install the latest Mac OS X Developer
Packages, which you can download from <http://developer.apple.com/tools>.
Then, execute the following commands in a terminal session, to build all the frameworks and demo applications:
```shell
$ cd mac
$ make
```
After building the iODBC libraries and applications, you have to install them on your system with the command:
```shell
$ sudo make install
```
This installs the `iODBCinst` and `iODBC` frameworks into —
```shell
/Library/Frameworks/iODBC.framework
/Library/Frameworks/iODBCinst.framework
```
— and the test applications `iodbctest` and `iodbctestw` into —
```shell
/Library/Application Support/iODBC/bin
```
— and the iODBC Administrator and iODBC Demo applications in —
```shell
/Applications/iODBC
```
### `iODBC Administrator.app`
Now that you have installed the iODBC frameworks on your system, you will be able to use ODBC applications or build your own
applications using the iODBC API.
Once you have installed an ODBC Driver, you can configure and test a new ODBC DSN, using either the 32-bit Cocoa UI, which can configure
and test any ODBC driver that is built in Universal mode —
```shell
/Applications/iODBC/iODBC Administrator.app
```
— or the 64-bit version, which can configure drivers that only support a 64-bit Cocoa UI —
```shell
/Applications/iODBC/iODBC Administrator64.app
```
### Test DSN connection
Once you have configured a DSN, you will be able to make a connection using the `iodbctest` tool which is located at —
```shell
/Library/Application Support/iODBC/bin/iodbctest
```
## Method 2: Using `configure` and `make`
The iODBC package can also be built like any other Open Source package not using any frameworks.
This build method still works with older versions of Xcode.
On OS X Yosemite (10.10) and newer, Apple removed a number of programs from their **`Xcode.app`** commandline installation, including
`autoconf`, `automake`, `libtool`, and some other tools needed to build iODBC from a newly checked out GIT tree. We suggest
using the [HomeBrew package manager](http://brew.sh/) to install these tools, according to their documentation.
To build the libraries, open up a terminal session in **`Terminal.app`** or similar, and execute the following commands:
```shell
$ sh autogen.sh
$ ./configure
$ make
```
To install the header files and libraries in `/usr/local`, execute the following command as an administrator,
and provide that user's password when prompted:
```shell
$ sudo make install
```
Note that, by default, this will build components that only run on the CPU type you are building on, so `ppc`
on very old machines, `x86` on early CoreDuo machines, `x86_64` on recent Intel models, and `arm64` on current
Apple Silicon models.
You can also build iODBC components that support multiple CPU architectures — either **Universal** components
that support `ppc`, `x86`, and/or `x86_64`; or **Universal2** components that support `x86_64` (including as
emulated by Rosetta2) and `arm64`.
### Mac OS X Leopard (10.5) and Mac OS X Snow Leopard (10.6)
The following commands will build a release of iODBC that supports Mac OS X Leopard (10.5) as well as
Mac OS X Snow Leopard (10.6), on `ppc` (including as emulated by Rosetta), `x86`, and `x86_64`:
```shell
$ CFLAGS="-O -arch ppc -arch i386 -arch x86_64"
$ CFLAGS="$CFLAGS -isysroot /Developer/SDKs/MacOSX10.5.sdk"
$ CFLAGS="$CFLAGS -mmacosx-version-min=10.5"
$ export CFLAGS
$ sh autogen.sh
$ ./configure \
--disable-dependency-tracking \
--prefix=/usr/local/iODBC.universal
$ make
$ sudo make install
```
### Mac OS X Lion (10.7) and OS X Mountain Lion (10.8)
The following commands will build a release of iODBC that works on Mac OS X Lion (10.7)
and OS X Mountain Lion (10.8):
```shell
$ CFLAGS="-O -arch i386 -arch x86_64"
$ CFLAGS="$CFLAGS -mmacosx-version-min=10.7"
$ export CFLAGS
$ sh autogen.sh
$ ./configure \
--disable-dependency-tracking \
--prefix=/usr/local/iODBC.universal
$ make
$ sudo make install
```
### OS X Mavericks (10.9) through macOS Big Sur (11.x) on `x86` or `x86_64` (including Rosetta2 emulation)
The following commands will build a release of iODBC that works on OS X Mavericks (10.9) through macOS Ventura (13.x),
supporting other components built for `x86` (through macOS Mojave (10.14), where Apple dropped support for 32-bit
components) or `x86_64` (including Rosetta2 emulation):
```shell
$ CFLAGS="-O -arch i386 -arch x86_64"
$ CFLAGS="$CFLAGS -mmacosx-version-min=10.9"
$ export CFLAGS
$ sh autogen.sh
$ ./configure \
--disable-dependency-tracking \
--prefix=/usr/local/iODBC.universal
$ make
$ sudo make install
```
### macOS Big Sur (11.x) through macOS Ventura (13.x) on `x86_64` (including Rosetta2 emulation) or `arm64` (Apple Silicon a/k/a M1 or M2)
The following commands will build a release of iODBC that works on macOS Big Sur (11.x) through macOS Ventura (13.x),
running on Intel (`x86_64`) or Apple Silicon (`arm64` a/k/a `M1` or `M2`):
```shell
$ CFLAGS="-O -arch arm64 -arch x86_64"
$ CFLAGS="$CFLAGS -mmacosx-version-min=10.9"
$ export CFLAGS
$ sh autogen.sh
$ ./configure \
--disable-dependency-tracking \
--prefix=/usr/local/iODBC.universal
$ make
$ sudo make install
```
### Test DSN connection
Once you have installed an ODBC driver and configured a DSN, you will be able to
make a connection using the `iodbctest` tool which is located at —
/usr/local/iODBC.universal/bin/iodbctest
|
