ODBC, MySQL & Access 2003

[Steve Farber]

I'm not especially new to databases and I have used ODBC before with
other data sources, but I cannot seem to get Access 2003 to talk to
MySQL 4.0.15.

I have MySQL running with new tables defined, but I cannot get a
connection to those tables via ODBC using MyODBC 3.51.

Can anyone point the way?

Many thanks,

Steve
Reynoldsburg, OH

[tom]

On Sun, 20 Feb 2005 02:00:20 +0000, Steve Farber wrote:

I'm not especially new to databases and I have used ODBC before with
other data sources, but I cannot seem to get Access 2003 to talk to
MySQL 4.0.15.

I have MySQL running with new tables defined, but I cannot get a
connection to those tables via ODBC using MyODBC 3.51.

Can anyone point the way?

Have you been able to get the MyODBC 3.51 [Test Connection] to report
success?
And if so -
Have you tried to create a linked table?

Thomas Bartkus

[Steve]

Hi Tom,

I have NOT been able to get MyODBC to report success, nor have I been
able to link a table.

I've followed the directions regarding the set-up of ODBC sources, but
it doesn't seem to work.

- Steve
tom wrote:

On Sun, 20 Feb 2005 02:00:20 +0000, Steve Farber wrote:

I'm not especially new to databases and I have used ODBC before with
other data sources, but I cannot seem to get Access 2003 to talk to
MySQL 4.0.15.

I have MySQL running with new tables defined, but I cannot get a
connection to those tables via ODBC using MyODBC 3.51.

Can anyone point the way?

Have you been able to get the MyODBC 3.51 [Test Connection] to report
success?
And if so -
Have you tried to create a linked table?

Thomas Bartkus

[tom]

On Sun, 20 Feb 2005 17:45:26 +0000, Steve wrote:

Hi Tom,

I have NOT been able to get MyODBC to report success, nor have I been
able to link a table.
That's important to know because your original post implied that problem
lies somewhere between Access 2003 and MySQL 4.0 . However, no version of
Access can possibly function with ODBC until you actually get ODBC working
first.
I've followed the directions regarding the set-up of ODBC sources, but
it doesn't seem to work.

This doesn't tell us much. Either your usr/pwd permissions are being
refused, or the installation was faulty, or the ODBC subsystem on Windows
is somehow broken on your machine. I suggest troubleshooting in that
order.

And if you want help, you have to give us some clues! Server or local
MySQL installation? Does ODBC work with other database systems, Access
for instance? Are you sure you have proper permissions to the specified
database and MySQL isn't simply refusing to talk to your identity?

In any case, you would be wasting your time trying to connect ODBC until
you *first* get that initial connection test to work.

Thomas Bartkus