Web Wiz Forums - help with access to MySQL convertion

Print Page | Close Window

help with access to MySQL convertion

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=19275
Printed Date: 12 April 2026 at 9:42am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: help with access to MySQL convertion

Posted By: hirschy
Subject: help with access to MySQL convertion
Date Posted: 13 April 2006 at 1:10am

I get this error:

Server Error in Forum Application
An error has occured while executing SQL query on database.
Please contact the forum administrator.

Support Error Code:- err_mySQL_get_forum_data
File Name:- default.asp

Error details:-
Microsoft OLE DB Provider for ODBC Drivers
[MySQL][ODBC 3.51 Driver][mysqld-5.0.19-nt]Table 'hirschy10.tblforum' doesn't exist

after attempting a convert from access to MySQL.

I used http://www.bullzip.com/download.php - http://www.bullzip.com/download.php access to mysql converter, but I cant get the tblforums to convert..

I get this error:

Incorrect table definition; there can be only one auto column and it must be defined as a key

I have tried many things, exporting from within Access (it crashes) and cannot find the converter that was listed here. (the website seems blank, forget the guys name, too many searches...)

any one have any idea?

Replies:

Posted By: WebWiz-Bruce
Date Posted: 13 April 2006 at 10:28am

Some one else is trying to attempt this using the Access to mySQL converter tool from mySQL site.

I think they have had more success than you, so have a look for their posts, I gave a reply to them yesterday.

Posted By: RAVALON
Date Posted: 13 April 2006 at 4:23pm

yes.....i convert database on mysql some month ago.....with good results...

i used DB Tools Manager Professional (Free) ...

you could use also MySQL Migration toolkit distributed by http://www.mysql.com - www.mysql.com