4 replies to this topic

[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]

peterlaursen, on Mar 6 2006, 03:40 PM, said:

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-downl...asp?shell32.zip

try replace (make a backup of your existing file)