|
In my experience problems with MySQL and ODBC are usually related to a
problem granting access to the database. Be sure you know what you're
doing with respect to granting access to the MySQL database. Make sure
you can connect to it using the MySQL control center before attempting
to connect from the Witango Dev studio. /John Ben Johansen wrote: As for connecting to MySql via odbc from Dev. Studio I have done it with 5 and 5.5 on XP to Win2003 Server no problem.I would have to question the ODBC DSN configuration. When you setup the ODBC on the XP Client did you perform the connection test under ODBC Admin? Ben Johansen - http://www.pcforge.com Authorized MDaemon Reseller Available for Web App. Developement -----Original Message----- From: Robert D Glover Jr [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 30, 2005 8:45 PM To: [email protected] Subject: Re: Witango-Talk: ODBC problem with MySql on Dev Studio 5.5 on WinXP 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: ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf |
