and it works on the server. Lesson learned: Only try new things when the sun is up, the sky is blue.
On Feb 12, 2012, at 8:40 AM, Roland Dumas wrote: > wait wait…. it's a Sunday morning and the sky is clear…. and it didn't > crash…. and I can create a datasource….. > > > On Feb 12, 2012, at 8:32 AM, Roland Dumas wrote: > >> /Library/Java/Extensions/mysql-connector-java-5.1.17-bin.jar >> >> I can create a new jdbc data source, but when I try to create an ODBC data >> source, it either hangs the application or just does nothing. I never get to >> a setup screen. >> >> >> _________________________ >> >> Roland A. Dumas >> 310 W. Bellevue Ave. >> San Mateo, CA 94402 >> 415-412-9300 >> AIM: radumas >> [email protected] >> >> >> >> >> >> >> On Feb 12, 2012, at 8:22 AM, Robert Shubert wrote: >> >>> JDBC Drivers is a dialog under the Data Source menu - open it and verify >>> that your driver JARs are where the paths indicate. >>> >>> Robert >>> >>> -----Original Message----- >>> From: Roland Dumas [mailto:[email protected]] >>> Sent: Sunday, February 12, 2012 1:14 AM >>> To: [email protected] >>> Subject: Re: TeraScript-Talk: Re: Witango-Talk: MacOS 10.7 ODBC >>> >>> >>> >>> >>> >>> On Feb 11, 2012, at 8:24 PM, Robert Shubert wrote: >>> >>>> Roland, >>>> >>>> Is there any information shown in the console? >>> >>> no >>> >>>> >>>> Are your JDBC Drivers set properly? >>> >>> how do I test? pre-existing data sources work fine. Can create a JDBC data >>> source. Just can't create a new ODBC. >>> >>> >>> >>>> >>>> Robert >>>> >>>> -----Original Message----- >>>> From: Roland Dumas [mailto:[email protected]] >>>> Sent: Saturday, February 11, 2012 7:10 PM >>>> To: [email protected] >>>> Subject: TeraScript-Talk: Re: Witango-Talk: MacOS 10.7 ODBC >>>> >>>> After a break, I'm back working on some apps using the mac studio. WHat >>>> worked before is no longer working, namely, connection to a database on >>>> the same machine. >>>> >>>> Per previous messages, if I want the ODBC on the server, I use the New >>>> Data Source ODBC option, and insert jdbc information so that on the dev >>>> machine, it's using jdbc. I have two databases that were set up this way, >>>> and they work fine. >>>> >>>> I go to create a new one, and witango studio hangs. It hangs hard, because >>>> after force quitting and restarting a couple of times, it actually crashed >>>> the OS. I had witango studio 6.07, so find there is a Terascript 6.1.5, >>>> download and install it. I can still see the previously created data >>>> sources just fine, but when I go to create a new one, Terascript hangs. >>>> Must force quit. >>>> >>>> WHat am I doing wrong? >>>> >>>> >>>> >>>> >>>> On Jul 30, 2011, at 2:55 PM, Roland Dumas wrote: >>>> >>>>> ok, have jdbc running. >>>>> >>>>> Are you telling me that I can create a datasource using the ODBC option, >>>>> but connecting to the dev database using the JDBC driver, which will then >>>>> on the production server find an ODBC DSN of the same name and use it? >>>>> This is sounding possible. >>>>> >>>>> >>>>> 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:[email protected]] >>>>>> Sent: Saturday, July 30, 2011 3:48 PM >>>>>> To: [email protected] >>>>>> 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:[email protected]] >>>>>>> Sent: Saturday, July 30, 2011 3:04 PM >>>>>>> To: [email protected] >>>>>>> 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:[email protected]] >>>>>>>> Sent: Saturday, July 30, 2011 9:40 AM >>>>>>>> To: [email protected] >>>>>>>> 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 >>>>>>>>>> [email protected] with "unsubscribe witango-talk" in the body. >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> ---------------------------------------- >>>>>>>>> >>>>>>>>> To unsubscribe from this list, please send an email to >>>>>>>>> [email protected] with "unsubscribe witango-talk" in the body. >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> ---------------------------------------- >>>>>>>> >>>>>>>> To unsubscribe from this list, please send an email to >>>>>>>> [email protected] with "unsubscribe witango-talk" in the body. >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> ---------------------------------------- >>>>>>>> >>>>>>>> To unsubscribe from this list, please send an email to >>>>>>>> [email protected] with "unsubscribe witango-talk" in the body. >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> ---------------------------------------- >>>>>>> >>>>>>> To unsubscribe from this list, please send an email to >>>>>>> [email protected] with "unsubscribe witango-talk" in the body. >>>>>>> >>>>>>> >>>>>>> >>>>>>> ---------------------------------------- >>>>>>> >>>>>>> To unsubscribe from this list, please send an email to >>>>>>> [email protected] with "unsubscribe witango-talk" in the body. >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> ---------------------------------------- >>>>>> >>>>>> To unsubscribe from this list, please send an email to >>>>>> [email protected] with "unsubscribe witango-talk" in the body. >>>>>> >>>>>> >>>>>> >>>>>> ---------------------------------------- >>>>>> >>>>>> To unsubscribe from this list, please send an email to >>>>>> [email protected] with "unsubscribe witango-talk" in the body. >>>>>> >>>>> >>>>> >>>>> >>>>> ---------------------------------------- >>>>> >>>>> To unsubscribe from this list, please send an email to >>>>> [email protected] with "unsubscribe witango-talk" in the body. >>>>> >>>> >>>> >>>> >>>> ---------------------------------------- >>>> >>>> To unsubscribe from this list, please send an email to >>>> [email protected] with "unsubscribe terascript-talk" in the body. >>>> >>>> >>>> >>>> ---------------------------------------- >>>> >>>> To unsubscribe from this list, please send an email to >>>> [email protected] with "unsubscribe terascript-talk" in the body. >>>> >>> >>> >>> >>> ---------------------------------------- >>> >>> To unsubscribe from this list, please send an email to >>> [email protected] with "unsubscribe terascript-talk" in the body. >>> >>> >>> >>> ---------------------------------------- >>> >>> To unsubscribe from this list, please send an email to >>> [email protected] with "unsubscribe terascript-talk" in the body. >>> >> >> >> >> ---------------------------------------- >> >> To unsubscribe from this list, please send an email to >> [email protected] with "unsubscribe terascript-talk" in the body. >> > > > > ---------------------------------------- > > To unsubscribe from this list, please send an email to > [email protected] with "unsubscribe terascript-talk" in the body. > ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe terascript-talk" in the body.
