Hi
I have a MSDE (SP 3) and SQL Server Personal Edition (SP 3 a) installed on a
Windows XP machine.

Trying to use the Import wizard I receive the following error:
"The specified module was not found".
The wizard starts up, but when I click on the Next button after choosing a
datasource nothing happens.
I have
- re-registered the files found in redist.txt with no problems
encountered.
-rebuild the registry database
-restored the logon user to LocalSystem to make sure that it is not an
access right problem
- Reinstalled MDAC 2.8
(When I search the Registry Database In
"HKEY_CURRENT_USER\Software\Microsoft\Microsof t SQL
Server\80\DTS\Enumeration\OLEDBProviders" this folder is empty)
But I still receive the error
Any suggestions?

Best regards

Jan

After many (MANY) hours of searching I found the free tool Dependency
Walker.
(http://www.dependencywalker.com/) When you press F7 and run the tool you
can dynamically detect which dlls an .exe file use (in this case dtswiz.exe)
I figured out that I have downloaded a Danish version of MDAC 2.8. Therefore
DTSWIZ tried to find files in \1030 libraries when they were actually (and
wrongly) located in \1033 (Danish locale) libraries.
So I downloaded the english version of MDAC 2.8 from Microsoft and installed
it.
Now I received a new error from the dts wizard.
Then I ran the Dependency walker again.
This time a couple of files were missing in the right libraries. So I just
copied them and guess what... It worked.

HTH someone

Jan



"Jan Nielsen" <ReplyInNewsgroup (AT) tiscali (DOT) dk> skrev i en meddelelse
news:eOCXKkNiDHA.1796 (AT) TK2MSFTNGP10 (DOT) phx.gbl...

Thanks for letting us know.

An obscure one but interesting.

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Jan Nielsen" <ReplyInNewsgroup (AT) tiscali (DOT) dk> wrote