Help - Search - Members - Calendar
Full Version: Error Access Import
Webyog Forums > SQLyog > Migration to MySQL with SQLyog (ODBC Import)
jaybill
Running Enterprise Edition 30 day trail

I'm trying to upload via tunnel ms access I get as far as the table then get the error message:

"The SJA.EXE file is linked to missing export SHELL32.DLL:SHGetFolderPathA."

Any thoughts would be helpful.


Jaybill
peterlaursen
This
QUOTE
I'm trying to upload via tunnel ms access I
is a little bit unclear! But I understand that you are migration as Access database to a MySQL database and you connect to this MySQL with HTTP-tunnel?
Right?

Which Windows version? Which SQLyog version?? Which Ms-Access version?
Do you have the shell32.dll file (in \windows\system or \windows\system32 folder)?
Is the ODBC-driver the correct version for this Access database file ?

This error message: could you describe it more precisely? Is it a Windows popup Messagebox?
Did you read this: www.webyog.com/whitepaper/Preparing_Access__Migration.pdf

Can you use SQLyog normally (interactively)?
Can you import this Access database to anywhere else using the same ODBC-driver?


Lots of questions that you will have to answer if anybody else should be able to have an idea of what is wrong.
jaybill
QUOTE (peterlaursen @ Mar 6 2006, 03:40 PM) *
This is a little bit unclear! But I understand that you are migration as Access database to a MySQL database and you connect to this MySQL with HTTP-tunnel?
Right?

Which Windows version? Which SQLyog version?? Which Ms-Access version?
Do you have the shell32.dll file (in \windows\system or \windows\system32 folder)?
Is the ODBC-driver the correct version for this Access database file ?

This error message: could you describe it more precisely? Is it a Windows popup Messagebox?
Did you read this: www.webyog.com/whitepaper/Preparing_Access__Migration.pdf

Can you use SQLyog normally (interactively)?
Can you import this Access database to anywhere else using the same ODBC-driver?
Lots of questions that you will have to answer if anybody else should be able to have an idea of what is wrong.


Thanks for responding, answered questions below:

Which Windows version? Windows 98se
Which SQLyog version?? SQLyog Enterprise Trial - MySQL GUI v5.02
Which Ms-Access version? Access 2000 v9.0.3821 SR-1

Do you have the shell32.dll file (in \windows\system or \windows\system32 folder)? Yes C:/WINDOWS/SYSTEM

Is the ODBC-driver the correct version for this Access database file ? Not Sure

This error message: could you describe it more precisely? Is it a Windows popup Messagebox? Windows popup box "Error Starting Program"
"The SJA.EXE file is linked to missing export SHELL32.DLL:SHGetFolderPathA."

Did you read this: www.webyog.com/whitepaper/Preparing_Access__Migration.pdf Yes

Can you use SQLyog normally (interactively)? Yes, I can change a value in the table via

Can you import this Access database to anywhere else using the same ODBC-driver? No


Thanks again for your help.
Jaybill
peterlaursen
QUOTE
Can you import this Access database to anywhere else using the same ODBC-driver? No


What do you mean? Where did you try to import to/read with? If the ODBC-driver cannot read the Access file then SQLyog can't either! SQLyog does not read the Access file itself. If I understand you right then you must start fixing that problem then. Somehow.

W98 .. I don't have any chance to try this.

Some google links here. Seems to be a lot of problems with that shell32.dll. Anything you can use? There are links to downloadable versions, but have a copy of the one you have ... But ritesh probably cal give a better explabation of ther error msag than I can.
peterlaursen
this one should be a shell32.dll for W98SE
http://www.dll-downloads.com/hosts.asp?shell32.zip

try replace (make a backup of your existing file)
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2008 Invision Power Services, Inc.