WxWindows, MySQL and Windows98

From: Thomas Matthews (Thomas_MatthewsSpitsOnSpamBots_at_sbcglobal.net)
Date: 10/20/04 

Date: Wed, 20 Oct 2004 16:35:13 GMT

Hi,

I'm using WxWindows to access a MySQL database on Windows98.
I'm using Cygwin with the GNU G++ compiler. I'm also using
ODBC to talk to the database. The database is on my PC.

I've built the WxWindows sample code for database. I'm
getting the following errors:
     Unable to connect to data source.

     Check the name of your data source to verify it has been
     correctly entered/spelled.

     With some databases, the user name and password must
     be created with full rights to the CONTACT table prior
     to making a connection (using tools provided by the
     database manufacturer)

After pressing OK, I get an "ODBC parameter settings" window.
I select MySQL. I leave the username, password and
directory boxes blank. Then I press Save. Same problem,
each time I execute "dbtest.exe".

MySQL ODBC 3.51 Driver DSN Configuration:
Data Source Name: MySQL
Description: MySQL ODBC 3.51 Driver DSN
Host Name: localhost
Database Name: test
User: {blank}
Password: {blank}
Port: 3306
SQL command on connect: {blank}

I've tested the data source and it connected successfully.

I've just installed MySQL and I can access it using the
"mysql" program.
     mysql> select version();
     +--------------+
     | version() |
     +--------------+
     | 4.0.21-debug |
     +--------------+
     1 row in set (0.13 sec)

I thought this problem might be with permissions, so I
issued a GRANT ALL PRIVILEGES ON test.* to ODBC; to the
mysql as root. Still, the wxwindows program can't
communicate to the MySQL database.

What steps must I perform in order to have the WxWindows
dbtest program communicate with the MySQL database?
{Please be detailed and specific because I'm a newbie
  in the arena of communicating to databases and WxWindows}.

Thanks. 

-- 
Thomas Matthews
C++ newsgroup welcome message:
          http://www.slack.net/~shiva/welcome.txt
C++ Faq: http://www.parashift.com/c++-faq-lite
C Faq:   http://www.eskimo.com/~scs/c-faq/top.html
alt.comp.lang.learn.c-c++ faq:
          http://www.comeaucomputing.com/learn/faq/
Other sites:
     http://www.josuttis.com  -- C++ STL Library book

Relevant Pages