Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!

  New Posts New Posts RSS Feed - help with access to MySQL convertion
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

help with access to MySQL convertion

 Post Reply Post Reply
Author
hirschy View Drop Down
Newbie
Newbie
Avatar

Joined: 23 April 2004
Location: United States
Status: Offline
Points: 7
Post Options Post Options   Thanks (0) Thanks(0)   Quote hirschy Quote  Post ReplyReply Direct Link To This Post Topic: help with access to MySQL convertion
    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 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?
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
RAVALON View Drop Down
Groupie
Groupie
Avatar

Joined: 31 December 2003
Location: Italy
Status: Offline
Points: 132
Post Options Post Options   Thanks (0) Thanks(0)   Quote RAVALON Quote  Post ReplyReply Direct Link To This Post 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 www.mysql.com
 
Tongue
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.