I worked on this for some time a while ago. These are the steps that I found worked for me and my clients.
First install witango server v. 5.01.065. You should do this first, cuz it can mess with your ODBC frameworks, making your frameworks point to the default apple version of iODBC.
Then, go to: http://www.opelinksw.com/ and download the latest iODBC SDK for OS X/Panther. Install the pkg. This will install the iODBC manager/framework from openlink, which is IMHO the best for OS X. Openlink makes high performance ODBC drivers, and they are costly. But since there framework/manager are based on iODBC, they are required to distribute there manager/framework freely as part of the opensource GPL.
Now install your odbc driver that is compatible with iODBC.
Create "System" dsns and test them using the test function of the odbc manager. Do not continue until you verify they work.
Now here is the key, in order for witango to see these DSNs, there are a couple of environment variables that must be set. The best place to set these variables is in a startup item, and the witango installer should have made a startup item for you with the following code in it:
# Set up environment for ODBC driver manager
#
ODBCINI=/Library/ODBC/odbc.ini
export ODBCINI
ODBCINSTINI=/Library/ODBC/odbcinst.ini
export ODBCINSTINIThis sets the env. vars so witango will see your system dsns. If for some reason you want to use User DSNs ( you shouldn't), then you would have to modify the above environment variable to point to the correct ini files.
That should be it.
If you have trouble, you may contact me off list.
--
Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 5910 Clark Rd Suite G Paradise, Ca 95969 ph: 530.645.4040 x222 fax: 530.645.4040 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ - http://theradmac.com/ On Apr 27, 2004, at 4:02 PM, John Newsom wrote:
Hi, I have looked extensively over the archive, and also tracked the
conversations about this topic (including the disagreements over what
works!), and also looked in the documentation, both the installation
guide for the 5.5 studio, (feb 2004 - where there is a brief paragraph)
and the server 5.x install (aug 2002). Is there anyplace with a clear,
functional, step by step guide for getting the studio and server working
on OS X. I realize that with each successive release of the OS, and the
moving target of Apple's support for iODBC, and the various industry
efforts, that keeping something like this up to date is difficult. But
I did have all the pieces working (using an old product from The Kompany
that was an implementation of unixODBC), but since Panther I more or
less just gave up, hoping that with the release of 5.5 studio there
would be a clear installation and troubeshooting guide. I don't relish
spending another 8-10 hours getting every thing working again by trial
and error.
I also wonder if there is anything in the works that implements something like the PHP - MySQL calls, or the FX PHP class that works with the Filemaker XML import/export API's.
Or should I just go blast Apple for not providing a solid database architecture on OSX? Windows is sooooo much easier in this area, and I am a MAC zealot from way back.
End of rant.
Sorry.
John Newsom
-----Original Message----- From: Robert Garcia [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 27, 2004 11:52 AM To: [EMAIL PROTECTED] Subject: Witango-Talk: Java Bean Docs
I have installed the trial version of the new dev studio, but I still don't see any documentation for Beans. I know how to build them, and use them in my project, and deploy, that is not the issue. The issue is that I have read in old pervasive docs, that there are built in classes that help with a cleaner interface to and from the bean. Like passing a witango array to the bean, rather than passing some type of string, or xml to be parsed by the bean.
Is there any documentation anywhere for this? I thought this was going to be supplied with 5.5. I may be missing something, so if anyone knows, please inform me.
--
Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 5910 Clark Rd Suite G Paradise, Ca 95969 ph: 530.645.4040 x222 fax: 530.645.4040 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ - http://theradmac.com/
_______________________________________________________________________ _
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
smime.p7s
Description: S/MIME cryptographic signature
