Error: -2147467259

General usage of Access to MySQL

Moderator: jr

Error: -2147467259

Postby MaxDev » Thu Jun 25, 2009 12:39 pm

When converting from an Access to MySQL database I got the following error.

- Error: -2147467259 (80004005) [MySQL][ODBC 5.1 Driver][mysqld-6.0.10-alpha-community]Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs

Out of the three tables one of them failed which led to the above error.

Can anyone point me in the right direction to solve this issue?
MaxDev
 
Posts: 2
Joined: Thu Jun 25, 2009 12:31 pm

Re: Error: -2147467259

Postby MaxDev » Mon Jun 29, 2009 4:52 pm

I have temporarily resolved this issue by firstly creating a SQL dump file and then manually altering all of the varchar(255) data types to be text data types. The original data types in Access were set to be text with a limit of 255 characters so I do not see why this should give an error if the same limits are set in Access and MySQL?

I don't want all of the data types that I have manually altered to remain with such a high upper limit on characters but I also do not want to have to manually edit all of the SQL output from my Access databases as this would be very time consuming. Are there any answers or possible solutions to this?
MaxDev
 
Posts: 2
Joined: Thu Jun 25, 2009 12:31 pm


Return to General

Who is online

Users browsing this forum: No registered users and 2 guests

cron