Using SQLDMO


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 6 of 6

Thread: Using SQLDMO

  1. #1
    Setya Guest

    Using SQLDMO


    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

  2. #2
    G. Allen Guest

    Re: Using SQLDMO


    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



  3. #3
    Euan Garden Guest

    Re: Using SQLDMO

    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




  4. #4
    Setya Guest

    Re: Using SQLDMO


    "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

  5. #5
    Setya Guest

    Re: Using SQLDMO


    "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

  6. #6
    Gert E.R. Drapers Guest

    Re: Using SQLDMO

    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




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center