[Wine] WIne, Access 97 and mysql question/problem

[wpflum]

I'm trying to get Access 97 running under wine and have it connect to a mysql server running on the linux side of the machine.  I was able to get Access 97 installed and it runs good but no matter what I do I cannot get it to connect to the mysql server through the odbc connector.

I've tried it with the wine odbc stub and while I can get isql to hit the database on the linux side no matter what I do i get the 'no default database error' on the windows side when I try to access odbc.

I've tried using the native odbc manager and mysql-odbc connector and while I can get a 'passed' test when I create the odbc source I get a 'No database selected (#1046)" error when I select the odbs source in Access.

I'm running Centos 5 and was using the wine that came in to the system through the Yum installer and got the errors so I downloaded and compilied the latest and greatest version from the web, version 1.1.16 thinking it might be some kind of 'bug' with the version I had but I still get the same errors doing either way again.

I feel like I'm so close to getting this to work but I keep pulling my hair out.

Any ideas??