Invalid String Or Buffer Length

[zzapper]

Hi

Trying to import an Access 2002 Database via odbc into mysql

using migration toolkit

SQLYOG gives me

The underlying database seems to be Microsoft Access. To correctly import meta-data like FKs, Indexes etc. from an

Access database you will require to give permissions on Access system tables. This can be done in MS Access through

Tools -> Options -> View Tab.

I don't know what Im supposed to do here (Dont have View Tab)

Continue anyway and get

message in sja.log Invalid string or buffer length

No tables imported

What am I doing wrong?

SQLyog Job Agent Version 5.16

Copyright © Webyog Softworks Pvt. Ltd.. All Rights Reserved.

Job started at Fri Jul 28 12:06:52 2006

DBMS Information: ACCESS

ERROR in SQL:

ERROR: [Microsoft][ODBC Driver Manager] Invalid string or buffer length

Check C:Program FilesSQLyog Enterprisesja.log for complete error details.

ERROR: Import aborted…

Check C:Program FilesSQLyog Enterprisesja.log for complete error details.

Total time taken – 0 sec(s)

[peterlaursen]

Is it this issue:

http://www.webyog.com/whitepaper/Preparing_Access__Migration.pdf

[zzapper]

peterlaursen wrote on Jul 28 2006, 01:48 PM:

Is it this issue:

http://www.webyog.com/whitepaper/Preparing_Access__Migration.pdf

Thnx Peter

That solved it, might I suggest the SQLYOG Warning Window when you have this problem should be improved

ir refer to above dOC

Cheers

[Author]

Posts