Using SQLDMO

[Setya]

Hi all,
I'm using SQLDMO to access SQL Server database. When I install my app
in my client's workstation, it won't run until I also install SQL Server.
I try to manually register sqldmo.dll, but it won't register. Installing
SQL Server on every workstation doesn't seem to be the best solution. Any
advice would be greatly appreciated.

Thank you


Setya

[G. Allen]

I've noticed that with VB the Package and Deployment Wizard doesn't include
all of SQLDMO's dependencies. Use a program like Depends (part of the Visual
Studio Tools) to determine all of the SQLDMO object library's dependencies.
You can then add them manually during the creation of the setup program.

"Setya" <jsetya@yahoo.com> wrote:
>
>Hi all,
> I'm using SQLDMO to access SQL Server database. When I install my app
>in my client's workstation, it won't run until I also install SQL Server.
>I try to manually register sqldmo.dll, but it won't register. Installing
>SQL Server on every workstation doesn't seem to be the best solution. Any
>advice would be greatly appreciated.
>
>Thank you
>
>
>Setya

[Euan Garden]

read the redist.txt on the SQL Server Cd to find out what DMO's dependencies
are.

-Euan

"Setya" <jsetya@yahoo.com> wrote in message news:3acc7ec7$1@news.devx.com...
>
> Hi all,
> I'm using SQLDMO to access SQL Server database. When I install my app
> in my client's workstation, it won't run until I also install SQL Server.
> I try to manually register sqldmo.dll, but it won't register. Installing
> SQL Server on every workstation doesn't seem to be the best solution. Any
> advice would be greatly appreciated.
>
> Thank you
>
>
> Setya

[Setya]

"G. Allen" <gallenspam@worldnet.att.net> wrote:
>
>I've noticed that with VB the Package and Deployment Wizard doesn't include
>all of SQLDMO's dependencies. Use a program like Depends (part of the Visual
>Studio Tools) to determine all of the SQLDMO object library's dependencies.
> You can then add them manually during the creation of the setup program.
>
>"Setya" <jsetya@yahoo.com> wrote:
>>
>>Hi all,
>> I'm using SQLDMO to access SQL Server database. When I install my
app
>>in my client's workstation, it won't run until I also install SQL Server.
>>I try to manually register sqldmo.dll, but it won't register. Installing
>>SQL Server on every workstation doesn't seem to be the best solution. Any
>>advice would be greatly appreciated.
>>
>>Thank you
>>
>>
>>Setya

I use InstallShield to create setup application and when I run it, a message
comes up that indicates that the sqldmo.dll/sqldmo.rll is not self-registered
files. (I manually include the sqldmo.dll in the InstallShield project).
I'm afraid that installing SQL Server is a must (I'd be very happy if it
is not).

Thanks


Setya

[Setya]

"Euan Garden" <euan.garden@spicedham.usa.net> wrote:
>read the redist.txt on the SQL Server Cd to find out what DMO's dependencies
>are.
>
>-Euan
>
>"Setya" <jsetya@yahoo.com> wrote in message news:3acc7ec7$1@news.devx.com...
>>
>> Hi all,
>> I'm using SQLDMO to access SQL Server database. When I install my
app
>> in my client's workstation, it won't run until I also install SQL Server.
>> I try to manually register sqldmo.dll, but it won't register. Installing
>> SQL Server on every workstation doesn't seem to be the best solution.
Any
>> advice would be greatly appreciated.
>>
>> Thank you
>>
>>
>> Setya
>
Thanks Euan

I just want to be sure that using SQLDMO in my apps won't require SQL Server
installation on my client's workstation. I read the SQL Server Books Online
which says that sqldmo.dll only comes from the installation of SQL Server
(no other means).

Setya

[Gert E.R. Drapers]

Not true. SQL-DMO is installed as part of a server install or as part of a
client install only. Besides that you can redist it your self, that is what
is described in the REDIST.TXT document. SQL-DMO depends on MDAC being
installed correctly and IE (depending on which version of SQL Server you use
IE4 or IE5).
-GertD

"Setya" <jsetya@yahoo.com> wrote in message news:3acd832f$1@news.devx.com...
>
> "Euan Garden" <euan.garden@spicedham.usa.net> wrote:
> >read the redist.txt on the SQL Server Cd to find out what DMO's
dependencies
> >are.
> >
> >-Euan
> >
> >"Setya" <jsetya@yahoo.com> wrote in message
news:3acc7ec7$1@news.devx.com...
> >>
> >> Hi all,
> >> I'm using SQLDMO to access SQL Server database. When I install my
> app
> >> in my client's workstation, it won't run until I also install SQL
Server.
> >> I try to manually register sqldmo.dll, but it won't register.
Installing
> >> SQL Server on every workstation doesn't seem to be the best solution.
> Any
> >> advice would be greatly appreciated.
> >>
> >> Thank you
> >>
> >>
> >> Setya
> >
> Thanks Euan
>
> I just want to be sure that using SQLDMO in my apps won't require SQL
Server
> installation on my client's workstation. I read the SQL Server Books
Online
> which says that sqldmo.dll only comes from the installation of SQL Server
> (no other means).
>
> Setya