Failing To Import From Ms Access

[arno]

I have a very annoying new problem importing data from an MS access database tot the MySQL database that’s at the back of a website. I always was able to simply update de MySQL dbase using the database Migration Toolkit. However if I try to do it now in exactly the same way I always did, I get different error messages but the most common message is that the SQL syntax is not correct. Some records do import, others import partly with strange characters and other records fail.

I’ve been trying to analyse why this is and found out the following, maybe this might help somebody to tell me what the problem is

If I run the query

UPDATE aaatest SET

testveld1 = “

Untamed Wildlife Safaris… at the end of the string I get the same kind of error messages that I get using the Mirgration Toolkit. So if I run the query:

UPDATE aaatest SET

testveld1 = “

Untamed Wildlife Safaris…

“

WHERE TEST_ID=2

I get error code

Error Code : 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '”

Untamed Wildlife Safaris…

[peterlaursen]

Please answer:

1) Did you update SQLyog in between? Or does this happen now with the same version that used to work? And what version?

2) How do you connect to MySQL? It look like a XML-related issue! Using HTTP-tunnel?

[arno]

Hi,

thanks for this quick reply

1) I didn't update SQLyog in between. It happens with the same version that used to work SQLyog Enterprise v5.01

2) I do connect ot the MySQL dbase using a HTTP-tunnel.

Arno

[peterlaursen]

I think you must ask your ISP to help with this.

Maybe they only need to restart Apache (or whatever the webserver is) to fix it.

Thy will probably tell you that they did not change anything! They usually do. It is easiest for them!

Try executing the same query from phpMyAdmin (I think you have it?) on the server!

I would like to see if you get the same error then.

BTW: you should consider upgrading SQLyog! It is a free upgrade to 5.17!

http://webyog.com/sqlyog/upgrade.html

[arno]

Hi Peter,

Problem has been solved. I usually don't like to upgrade if everything is working as it should. Because of your advise I upgraded to 5.17 which resulted in a warning that there was a compatibility problem with the old tunnel file. I uploaded the new tunnel and then everything was back to normal again.

Thanks a lot for helping me out on this.

Arno

[Author]

Posts