very helpful and a little hopeful. The fact that neither JDBC nor ODBC options can be used to create a DSN tells me that the JDBC drivers are hosed, also.
On Jul 30, 2011, at 1:12 PM, Robert Shubert wrote: > Roland, > > The setup in Witango 6.0 + on OS X is that the Studio uses JDBC to introspect > the database (to load it into the Studio Database tab for drag and drop). > > If you setup a Witango Data Source under the JDBC section, then the Studio > will create TAFs that expect to use JDBC on the server, however, if you setup > a Witango Data Source under the ODBC section, then the TAFs will look for > ODBC DSNs when executed by the server. > > In this way, the OS X Studio can use JDBC to load the database, but you can > still use ODBC on the server. > > Starting in 10.6 Apple has mostly dropped support for ODBC. I suspect this > trend continued in 10.7. The iODBC subsystem is still present, but the > manager is removed, JAVA support is non-existent and I'm not sure how well > they are keeping up the functionality in Cocoa. I've tested with OpenLink on > 10.6 and found that product to be a good solution. > > As things stand right now, Apple is neither supporting ODBC nor JDBC/Java, so > database connectivity is being left out in the cold. Java 7 may resolve the > JDBC issues and there's a good chance that if it does, we'll standardize on > Java 7 & JDBC for connectivity support on OSX. > > I may also build in native connectors to Oracle (OCI), MSSQL (FreeTDS) and > FileMaker (FMXML) but there are no immediate plans to do so. > > Robert > > > -----Original Message----- > From: Roland Dumas [mailto:radu...@mac.com] > Sent: Saturday, July 30, 2011 3:48 PM > To: Witango-Talk@witango.com > Subject: Re: Witango-Talk: MacOS 10.7 ODBC > > > On Jul 30, 2011, at 12:33 PM, Robert Shubert wrote: > >> Roland, >> >> Could you confirm which version of the Studio were and are now using? > 6.0.7 > >> >> I ask because the Witango 6.0 Studio and TeraScribe 6.1 don't support ODBC, >> only JDBC. > really? It has New data sources: ODBC and JDBC. > >> >> Also, the ODBC subsystem was somewhat deprecated in 10.6 and needed to be >> installed manually. This is probably the case in 10.7 as well, but I haven't >> tested it. Checkout KB: http://support.apple.com/kb/DL895 > > It was running prior to 10.6 and wasn't harmed when I upgraded to 10.7. It's > completely hosed by upgrading to 10.7 > >> >> The Server should still access the iodbc subsystem and DSNs, but driver >> loading may be different. Also note that Lion is much more interested in >> running in 64-bit, and you may be having issues with bitness and/or paths. > > I can't tell what it killed and what it just doesn't work with. On a support > call to apple and getting passed around. The "enterprise" support people > answer the question with "What is ODBC?" which tells me it might be hosed for > good. Converting applications from ODBC to JDBC will be a significant project. > >> >> Robert >> >> >> -----Original Message----- >> From: Roland Dumas [mailto:radu...@mac.com] >> Sent: Saturday, July 30, 2011 3:04 PM >> To: Witango-Talk@witango.com >> Subject: Re: Witango-Talk: MacOS 10.7 ODBC >> >> The existing DSNs don't show up in the studio, to I went to re-create, but >> there are no drivers. I go to look in the regular apple ODBC admin utility, >> and it's nowhere to be found. I find open link iodbc manager, and it has the >> drivers and DSNs listed, but they all fail when tested. Errors are >> "specified driver could not be found" and "no such file or directory" >> >> So I figured the installation of 10.7 hosed up ODBC. Looking for hints how >> to repair, reinstall, etc. >> >> >> On Jul 30, 2011, at 9:27 AM, Robert Shubert wrote: >> >>> Roland, >>> >>> Could you clarify that you are looking for ODBC in the Studio? And also, >>> which version of the Studio and/or Server are you running? >>> >>> Robert >>> >>> -----Original Message----- >>> From: Roland Dumas [mailto:radu...@mac.com] >>> Sent: Saturday, July 30, 2011 9:40 AM >>> To: Witango-Talk@witango.com >>> Subject: Re: Witango-Talk: MacOS 10.7 ODBC >>> >>> Yes, well, I have a drive with my old OS and applications while I'm >>> migrating another to the new OS. You don't know all the hiccups and >>> incompatibilities until you give it a shot. >>> >>> Installing Java is not a problem. I expected that ODBC would be natively >>> supported by the OS as it (sorta) was previously. the upgrade wiped >>> everything out. wondering what the right protocol is to re-install. >>> _________________________ >>> >>> >>> >>> >>> On Jul 30, 2011, at 12:42 AM, Wayne Irvine wrote: >>> >>>> Robert made an announcement recently about not supporting Lion yet. That >>>> said, I installed 10.7 and Lion on what of my machines that already had >>>> TeraScribe installed. I also installed Java (came up as an option when I >>>> went to run a Java app). >>>> >>>> TeraScribe runs fine on this. >>>> >>>> Wayne Irvine >>>> >>>> On 30/07/2011, at 3:18 PM, Roland Dumas wrote: >>>> >>>>> >>>>> upgraded to 10.7 and installed Witango dev studio. ODBC seems missing in >>>>> this OS release. Anyone know the proper way to install/revive? >>>>> >>>>> >>>>> ---------------------------------------- >>>>> >>>>> To unsubscribe from this list, please send an email to >>>>> lists...@witango.com with "unsubscribe witango-talk" in the body. >>>>> >>>> >>>> >>>> >>>> ---------------------------------------- >>>> >>>> To unsubscribe from this list, please send an email to >>>> lists...@witango.com with "unsubscribe witango-talk" in the body. >>>> >>> >>> >>> >>> ---------------------------------------- >>> >>> To unsubscribe from this list, please send an email to lists...@witango.com >>> with "unsubscribe witango-talk" in the body. >>> >>> >>> >>> ---------------------------------------- >>> >>> To unsubscribe from this list, please send an email to lists...@witango.com >>> with "unsubscribe witango-talk" in the body. >>> >> >> >> >> ---------------------------------------- >> >> To unsubscribe from this list, please send an email to lists...@witango.com >> with "unsubscribe witango-talk" in the body. >> >> >> >> ---------------------------------------- >> >> To unsubscribe from this list, please send an email to lists...@witango.com >> with "unsubscribe witango-talk" in the body. >> > > > > ---------------------------------------- > > To unsubscribe from this list, please send an email to lists...@witango.com > with "unsubscribe witango-talk" in the body. > > > > ---------------------------------------- > > To unsubscribe from this list, please send an email to lists...@witango.com > with "unsubscribe witango-talk" in the body. > ---------------------------------------- To unsubscribe from this list, please send an email to lists...@witango.com with "unsubscribe witango-talk" in the body.