Okay, I gave up on trying to get WiTango to support MySQL via ODBC
in either Dev Studio 5.0 or in Dev Studio 5.5.
I installed Oracle 9i Personal Server (the download is a gigabyte,
so this is not trivial) and converted the MySql "create" and "insert"
scripts for the Music tutorial to work correctly in Oracle.
And now, at last, I can continue with the Witango tutorial using
the Music database through Oracle and ODBC.
(SUGGESTION to Witango: include the create and insert scripts both
in MySql and in Oracle format. The conversion from MySql to Oracle
format is NOT trivial: there are a lot of syntax differences).
Again I ask, has ANYONE been able to get the MySql version of the
Music database to work under Windows XP with Service pack 2 in either
Developer Studio 5.0 or 5.5? For that matter, has anyone been able to
get MySql to work at all via ODBC in Witango Dev Studio under WinXP
sp2?
It seems from what I've seen so far the Witango is used almost
exclusively on MAC and Linix??? Does that mean the Windows support is
the most buggy of the three OS's Witango supports?
Robert
....................
--- Robert D Glover Jr <[EMAIL PROTECTED]> wrote:
> I uninstalled Witango Dev Studio 5.5 and installed Witanto Dev
> Studio 5.0. Still, when I try to expand the "Music" ODBC connection
> in
> the Dev Studio workspace (where "Music" represents a MySql database
> created as per the Witango tutorial), Dev Studio 5 shuts down with
> the
> same error message as in Dev Studio 5.0:
>
> Product: Witango Studio
> Version: 5.5.08
> License Key: LX7N8-Q2CUZ-RU6EB-3ZENJ-DJ00
> Operating System: Windows NT, 5.1, 2600, Service Pack 2
> Unhandled exception: 0xc0000005
> Address:0x2e789f3
>
> Is there ANYONE running Windows XP with Service pack 2 that has
> been
> able to get part "B" of the Witango tutorial to work, i.e., to
> successfully create a datasource for the MySql "music" database?
> I worked professionally with Tango 2000 a few years ago at a
> company
> that used MS Sql Server. I never had problems like this. Is Witango
> 5
> and 5.0 on Windows XP buggy? Any suggestion appreciated.
> I also tried a connection to the Music database with Witango 5.5
> using the jdbc support, but that did not work either even though I
> verifed I had things correct by writing a standalone java program
> that
> was able to use jdbc to access the mySql "Music" database. Dev
> Studio
> 5.5 did not crash but it insisted the username and password were
> wrong
> even though they weren't.
>
> Robert
>
>
>
>
> --- Robert D Glover Jr <[EMAIL PROTECTED]> wrote:
>
> > I cannot complete Witango Tutorial "B" which requires use of a
> > database. Please advise me how to proceed.
> >
> > Here are the details. I am using Windows XP with Service Pack 2.
> > I downloaded the 30 day trial version of WiTango Dev Studio 5.5 and
> > Witango Server 5.5. I Have Witango Server running properly as an
> NT
> > Service. I also have MySql 4.0.21 running properly as an NT
> service.
> > I am using Apache 2 as my http server.
> >
> > I can successfully run all of the WiTango Tutorial "A", which
> does
> > not require a database. That proves Witango Dev Studio and Server
> > are
> > working properly with Apache 2 http server.
> >
> > I properly and correctly defined and loaded the "music" as
> > required
> > by Witango Tutorial "B".
> >
> > My problem is that although I have correctly set an ODBC database
> > connection for the "Music" database required by Tutorial "B" and
> it
> > tests correctly using the ODBC test facility and appears correctly
> in
> > the ODBC listing of the Dev Studio 5.5 workspace, when I click on
> > the > plus sign to show the tables it contains in Dev Studio 5.5 it
> > asks
> > for a username and then when I give the username I get the
> following
> > fatal error that shuts down Dev Studio 5.5:
> >
> > Date: Fri Jan 28 14:05:06 2005
> >
> > Product: Witango Studio
> > Version: 5.5.08
> > License Key: LX7N8-Q2CUZ-RU6EB-3ZENJ-DJ00
> > Operating System: Windows NT, 5.1, 2600, Service Pack 2
> > Unhandled exception: 0xc0000005
> > Address:0x2e789f3
> >
> > Please advise me how to proceed. I absolutely must complete
> the
> > Witango tutorial but I am absolutely stopped from doing so until
> > this
> > problem is resolved. Thank you.
> >
> >
>
________________________________________________________________________
> > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
> >
>
>
________________________________________________________________________
> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
>
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
