It is actually CoCreateInstance not GoCreateInstance ...
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@tiscali.dk> skrev i en meddelelse
news:e5OCtG5hDHA.1640@tk2msftngp13.phx.gbl...
[quoted text, click to view] > Hi
> I have a local computer with a MSDE and a SQL Server PE installed. They
both
> have SP 3 installed.
> I would like to import an Access database to my MSDE (or the PE if MSDE
> import is impossible).
> I use SQL Server Enterprise Manager
> When I rightclick on a database and select All Tasks-->Import Data
> I get an error: (It is Danish but is something like "Module not found")
> The headline of the Messagebox is DTS Import/Export Wizard Error:
> GoCreateInstance
>
> I have tried to reinstall the SQL Server client tools but that did not
help.
>
> Then I tried to open the Access database in Access XP and select
> Tools-->Database Utilities-->Upsizing Wizard.
> Then I receive the error
> "Provider cannot be found. It may not be properly installed"
>
> If I make an .UDL file in windows Explorer the Microsoft OLEDB Provider
for
> SQL Server is installed.
>
> Can anyone help me?
>
> Best regards
>
> Jan Nielsen
>
>
>
