Just some technical info for those that are interested.
> One more thing, the microsoft/data direct ODBC drivers for OS X are a > carbonized version of the older classic version. It uses old style CFM > libraries instead of unix type mach-o libraries. This is correct. We are not sure what happened here - it was a strange decision that Data Direct made. > Openlink Is installed as a true framework but hijacks the links to the Apple installed iodbc driver manager in the /usr/lib directory. This is not an Apple recommended thing to do as it modifies the OS shipped software without creating an uninstall script to restore the OS settings. Be careful installing the MySQL Openlink driver if you intend to use the free MySQL driver that comes with the Server Logistics build (a very nice build and installer) of MySQL. Installing the OpenLink driver manager will break all the automatic configurations of Witango and the Server Logistics MySQL installation. Also be careful if you are using multiple odbc drivers. > witango, and > the Apple odbc drivers are unix/mach-o with a carbon framework that > allows carbon apps to use them and run natively(unix style) with mach-o > apps like witango, but I don't think witango could use the strictly > carbon drivers/manager, nor would I think you would want to. Apple only ship the iodbc driver manager, it does not ship with odbc drivers. This is what causes most problems with setting up an odbc connection on OS X. You cannot get an installer that just installs the ODBC driver for a database. The iodbc driver manager is installed in the /usr/lib directory and does not have a framework setup for it. The Dev Studio (a carbon app), that needs to load the mach-o iodbc driver manager library, does setup a frameworks-like structure that tricks the OS into letting the Dev Studio load the mach-o library. It is not really an OS X framework it is just an alias to the macho dylib wrapped in a directory that is named the same as the library you are loading with a .framework on the end of the name. There is no code or extra files. > The $100 > one is specifically for development/single workstation use. We were in > discussions with them to resell the drivers with Witango and they > wanted at least $700/server. Make sure you factor the Server license of the driver into your budget as well as the workstation licenses as Apple do not ship odbc drivers, just the iodbc driver manager. If you are not running a site with millions of hits a day that always has a concurrent connections to the db the JDBC driver that most dbs ship with will give you more than adequate speed. >> Thanks, Robert.� I know you have quite a bit of experience doing what >> we are proposing in this thread.� Do you have any comments on the ODBC >> driver that is freely available from MS or any other part of the > setup? >> � >> Thanks in advance ... >> Ian >> -----Original Message----- >> From: Robert Garcia [mailto:[EMAIL PROTECTED] >> >> There is the openlink drivers. I use them, very fast, faster than >> JDBC, but not free. >> >> Robert. >> >> On Saturday, August 9, 2003, at 12:32 AM, Ian Daniel wrote: >> >> Ok, you've nudged us.� We're going to try it out. >> � >> Thanks, Phil .... >> Ian >> -----Original Message----- >> From: Phil Wade [mailto:[EMAIL PROTECTED] >> >> You could use the Microsoft JDBC driver. �And it is free. >> >> �------------� >> >> Hi Everyone: >> >> We standardly use MS SQL Server on Win2k. �However, we have need to >> query a SQL Server 2000 database residing on Win2k from Witango on Mac >> OS X, so we're on the hunt for the best ODBC driver for this need, to >> reside on the Mac system. >> >> Does anyone have any comment or experience with this scenario? �Just >> trying to avoid the pitfalls. >> >> tks, >> Ian Daniel >> >> >> >> -- >> >> Robert Garcia >> President - BigHead Technology >> CTO - eventpix.com >> 2781 N Carlmont Pl >> Simi Valley, Ca 93065 >> ph: 805.522.8577 - cell: 805.501.1390 >> [EMAIL PROTECTED] - [EMAIL PROTECTED] >> http://bighead.net/ - http://eventpix.com/ - http://theradmac.com/ >> ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
