MySQL driver failing to connect

[carltown]

I was using the MySQL driver 3.51 to upload an ACCESS table to a MySQL table on
my host. Then I world read the table with ColdFusion MX. Evreything was working
until I upgraded my Windows 2000 on my workstation here from SP3 to SP4 and
also did the security patches. Now, however, the SQL driver no longer works. I
uninstalled the driver, Uninstalled Access, then reinstalled Access and then
the driver. Doesn't work and I get the message:
ODBC - call failed
[MySQL][OBDC 3.51 Driver] User canceled (#0)

The message is from Access.

Any clues? Disabling the Firewall doesn't help. My host says everything looks
good there, and my ColdFusion programs that read other MySQL database tables
still active in the databaSe seem to work. They don't, however, use that
driver.

[BKBK]

It seems like the myODBC configuration wasn't successful. I would reinstall, and then follow closely the [url]http://dev.mysql.com/doc/refman/5.0/en/dsn-on-windows.html[/url].

[carltown]

On the Connector ODBC panel of Control Panel, when I do a Test the connection
works without an error. Access won't upload, however.

More info: I installed the 3.51 on a laptop that is SP3 and get the same error
message when attempting to upload a fresh database.

The connectior now is 3.51.12. The connector I use to use is 3.51.06. I can't
find the old connector on the MySQL site any more. Is there an archives with it
somewhere? Maybe I should try it.

[BKBK]

I can't find the old connector on the MySQL site any more. Is there an archives
with it somewhere? Maybe I should try it.
I wouldn't bother about it, really. As a general rule, newer versions of MySQL
products contain substantial hotfixes. It is therefore advisable to stay with
the current version.

There is a tool that could do the job, perhaps even better:
[url]http://dev.mysql.com/downloads/migration-toolkit/1.0.html[/url].

[carltown]

Thanks for the tip. I loaded the migration toolkit 1.0.21 and exploring it.

Moving an Access table to MySQL on the host. I did the settings on the Access
database the tookkit suggests, then tried the migration. On the creation
results page I get:
Access denied for user 'newworld@24.20.76.253' for database 'stopspam'

That IP is for my Comcast access - my host is 65.109.144.53 .

There were no error message until then, but two things puzzled me. On the
soucre (Access) database, it asked for User and Password. There is none for the
Access database source. Second, on the object type select I though I should be
selecting a table. The screen is blank, however.

Other than that, it acted like it worked until the Creation Results page.
Any clues?

[BKBK]

You indeed have to specify the username/password for the source database(Access) and then again for the destination database(MySQL).