Note: AugSoft also supports Classic Mac OS (System 7, 8 and 9) using a different set of procedures than described here. If you are nursing an old app, please contact Support for assistance.
Preparation
Before you start, quickly modify Apache to run in normal 32-bit mode.
NOTE: The following simple procedure may need to be performed after Software Update... installs a new Mac OS X or Mac OS X Server release.
% sudo apachectl stop
% sudo mv /usr/sbin/httpd /usr/sbin/httpd.ub
% sudo lipo -thin i386 /usr/sbin/httpd.ub -output /usr/sbin/httpd.i386
% sudo ln -s /usr/sbin/httpd.i386 /usr/sbin/httpd
% sudo reboot
Make sure that PHP is working on your Apache server before going further.
Next, verify that your network and firewall ports are configured correctly by simply TELNET-ing to port 6110 on the Windows PC (or Virtual Machine) that is hosting your ODBC Router:
% telnet xxx.xxx.xxx.xxx 6110
Connected to xxx.xxx.xxx.xxx.
Escape character is '^]'.
press [Return]
Connection closed by foreign host. <-- everything is ok
%
Installation
Step 1: Download and Install ODBC for Macintosh
Step 2: Download ODBC Administrator for Mac OS X 10.6 "Snow Leopard" from Apple
Step 3: Create your ODBC DSN
Now launch ODBC Administrator from the Utilities folder. If your Mac doesn't have such a utility, Open a Support ticket for the solution; otherwise:
click the SYSTEM tab
click the LOCK icon and authenticate as your Mac's Administrator
click the ADD button
pick the ODBCNET driver, netDBChooser will launch
enter the IP address or DNS name (eg, odbcrouter.mycompany.net) and click REFRESH icon
note: If you enter an incorrect IP address or DNS name, it can take quite a while to come back
pick the Data Source you want and move it to the column: Data Sources Available to My App
click the LIGHTSWITCH icon
click Disable Logon Prompt
click SAVE
click DONE
click Apply
quit the ODBC Administrator utility
launch the Terminal utility
now copy the per-user ODBC settings to be System-wide with:
$ sudo cp Library/ODBC/odbc*.ini /Library/ODBC/
Password:
$ chown _www Library/Preferences/odbcnet.txt
$ sudo cp Library/Preferences/odbcnet.txt /Library/Preferences/
Password:
$ chown _www Library/Preferences/odbcnet.txt
$ sudo cp Library/Preferences/odbcnet.txt /Library/Preferences/
The End