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.
