/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.
