Very Computer

Hello,

First, I'm french so my english isn't very good

How to enabling SQL DMO clients without installing the client Side utilities
for SQL 2000 ?

I have created a VB program whitch use SQLDMO. I would like to create An
install package of this program
without installing all the SQL Server 2000 connectivity client

I find on microsoft website the information : Q248241 (for SQL server 7)

the only action is : regsvr32 SQLDMO.DLL et SQLDMO.RLL but it does not work.

If someone has an idea ? Thank you

--
Stphane DOUSSIERE

Package a MDAC 2.5 or 2.6 with the VB app you are distributing. Install MDAC
2.5 on the client machine before you install the VB app. And connect using
ADO and you shall be ok. That way you don't need to install the SQL client
on the other client machines, plus you are not suppose to that anyway, as
long as those clients dont need the SQL enterprise running.

Nasir Aziz

Quote:> Hello,

> First, I'm french so my english isn't very good

> How to enabling SQL DMO clients without installing the client Side
utilities
> for SQL 2000 ?

> I have created a VB program whitch use SQLDMO. I would like to create An
> install package of this program
> without installing all the SQL Server 2000 connectivity client

> I find on microsoft website the information : Q248241 (for SQL server 7)

> the only action is : regsvr32 SQLDMO.DLL et SQLDMO.RLL but it does not
work.

> If someone has an idea ? Thank you

> --
> Stphane DOUSSIERE

That was not the question and is incorrect information.
-GertD

Please read the REDIST.TXT file in the root of your SQL Server 2000 CD, it
describes what you need to do manually. In a nut shell you need MDAC 2.6
first, then copy all the required files to

C:\Program Files\Microsoft SQL Server\80\tools\binn
and
C:\Program Files\Microsoft SQL Server\80\tools\binn\Reources\1033

before you can register SQLDMO.DLL. In 2000 you only regsvr32 SQLDMO.DLL.

Also on your SQL Server 2000 CD, there is a the MSDE directory which contain
merge modules for SQL-DMO, but you will have to use Windows Installer to be
able to use them.

-GertD

Quote:> Hello,

> First, I'm french so my english isn't very good

> How to enabling SQL DMO clients without installing the client Side
utilities
> for SQL 2000 ?

> I have created a VB program whitch use SQLDMO. I would like to create An
> install package of this program
> without installing all the SQL Server 2000 connectivity client

> I find on microsoft website the information : Q248241 (for SQL server 7)

> the only action is : regsvr32 SQLDMO.DLL et SQLDMO.RLL but it does not
work.

> If someone has an idea ? Thank you

> --
> Stphane DOUSSIERE

Thank you !!!

--
Stphane DOUSSIERE