problems with SQLDMO.dll

i have a vb.net application that uses SQL-DMO. the development machine is
WinXP
when i build a setup for my application and then install this on a clean
WinXP test machine it all runs fine
but when i install it on a Win2000 test machine i get the following error -
the sqldmo.dll registers successfully - but just gives this error message.
[SQL-DMO]Invalid Paramter Type; must be string or ordinal......
i have followed all the instructions thru here:-
http://support.microsoft.com/default.aspx?scid=kb;en-us;248241
but still cannot get it to run. any ideas as to what may be causing this? is
there different versions of sqldmo.dll that i need to run for win2k?
Cheers,
Craighi Craig,
"Craig G" <craig.gamble@.yarrasoftware.com> ha scritto nel messaggio
news:%23lsbQskmEHA.3340@.TK2MSFTNGP14.phx.gbl...
> i have a vb.net application that uses SQL-DMO. the development machine is
> WinXP
> when i build a setup for my application and then install this on a clean
> WinXP test machine it all runs fine
> but when i install it on a Win2000 test machine i get the following
error -
> the sqldmo.dll registers successfully - but just gives this error message.
> [SQL-DMO]Invalid Paramter Type; must be string or ordinal......
> i have followed all the instructions thru here:-
> http://support.microsoft.com/default.aspx?scid=kb;en-us;248241
> but still cannot get it to run. any ideas as to what may be causing this?
is
> there different versions of sqldmo.dll that i need to run for win2k?
actually not that I'm aware of...
personally I've built my (InnoSetup) SQL-DMO install package on a WinXP sp1
box, and deployed with success on Win98, Win2k, XP and Win2003..
the list of files I ditribute is like following:
; not licensed by redist.txt but available after installation of MDAC2.6
..\WINDOWS\SYSTEM\odbcbcp.dll; DestDir: WinSys ; sharedfile
; not licensed by redist.txt but available after installation of MDAC2.6
..\WINDOWS\SYSTEM\sqlwoa.dll ; DestDir: WinSys
; not licensed by redist.txt but available after installation of MDAC2.6
..\WINDOWS\SYSTEM\sqlwid.dll ; DestDir: WinSys
..\Programmi\Microsoft SQL Server\80\Tools\Binn\w95scm.dll; DestDir:
DestinationFolder\Binn
..\WINDOWS\SYSTEM\sqlunirl.dll ; DestDir: WinSys
..\Programmi\Microsoft SQL Server\80\Tools\Binn\sqlresld.dll; DestDir:
DestinationFolder\Binn
..\Programmi\Microsoft SQL Server\80\Tools\Binn\sqlsvc.dll; DestDir:
DestinationFolder\Binn
; not licensed by redist.txt but available after installation of MDAC2.6
..\Programmi\Microsoft SQL Server\80\Tools\Binn\Resources\1033\sqlsvc.RLL;
DestDir: DestinationFolder\Binn\Resources\1033
; not licensed by redist.txt but available after installation of MDAC2.6
..\Programmi\Microsoft SQL Server\80\Tools\Binn\Resources\1033\Sqldmo.rll;
DestDir: DestinationFolder\Binn\Resources\1033
..\Programmi\Microsoft SQL Server\80\Tools\Binn\sqldmo.dll; DestDir:
DestinationFolder\Binn ; file to be registered via regserver
DestinationFolder can either be the installation directory of one instance
of Microsoft SqlServer 2000, like ..\Program Files\Microsoft SQL
Server\80\Tools, even if no istance of SQL Server has been installed, or the
installation directory of your application, but the first is preferred.
Please do respect the hierarchy \Binn\Resources\1033 (where 1033 specifies
the language), where needed, in order to grant correct functionality of
Ole-Automation objects.
In order to install SQL-DMO components for MSDE 2000, Microsoft Internet
Explorer 5.5 or higher is required.
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply