DMO distribution

  • Hi all,

    Is there a way to distribute DMO into the destination PC in which without installing SQL Server or SQL Server's client tool.

    I have one program which using DMO to retrive all active SQL Server in LAN.

    From my development PC, it can be used properly since the development having the SQL client tool installed, but when i just deploy and install into another PC, the error occur indicating that the SQLDMO.dll cannot be registered.

    However, i have included all the dependancy dll for sqldmo.dll (base on what i saw from the dependancy viewer.

    Please help

    Thanks

  • Thanks a lot Allen_Cui

  • Please help again

    I've followed the MS support info but still failed.

    When register the sqldmo.dll, i have received nothing ,even no message popup to show whether it is success or failed, then running my program receive an error as

    Automation Error. The operating system cannot run %1

    Thank

  • Create the following stucture ( if not already avaible) under Program Files on your client machine :

    Microsoft SQL Server> 80 > Tools>Binn > Resources> 1033

    In Binn copy the following files:

    sqldmo.dll

    sqlresld.dll

    sqlsvc.dll

    w95scm.dll

    In 1033 copy files:

    sqldmo.rll

    sqlsvc.rll

    In winNT/System32 copy files:

    sqlwid.dll

    sqlwoa.dll

    Register sqldmo.dll in the Binn folder.

    We use this in all our projects that require SQLDMO and it works OK.

    quote:


    Please help again

    I've followed the MS support info but still failed.

    When register the sqldmo.dll, i have received nothing ,even no message popup to show whether it is success or failed, then running my program receive an error as

    Automation Error. The operating system cannot run %1

    Thank


Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply