Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2003
    Location
    Cape Town
    Posts
    38

    Unanswered: Sql Dmo Dll's deployment problem

    Hi there

    I hv developed a client server application that uses Access Xp ( adp file) as front end and SQL Server 2000 as database. Inside the vba code i hv extensively made use of sql dmo library objects. For the program to work properly i am forced to install Sql server client tools especially (enterprise manager) on end users workstation which is something i am not happy with.
    Whithout SQL client tools installed Access pops up an error like "Can't create activex object".

    I googled that issue and gathered informations stating that some dll's file must be installed for SQL dmo to work smoothly in a VB application and i guess that same also stands for Access vba since they are almost quiet the same.

    In my application setup package i hv included these below dll's and they hv been set to be loaded in application directory as following but the problem still remains.

    - Windows\System32\sqlunirl.dll

    - Application directory\80\Tools\Binn\sqldmo.dll ( with registration activated)
    - Application directory\80\Tools\Binn\sqlresld.dll
    - Application directory\80\Tools\Binn\sqlsvc.dll
    - Application directory\80\Tools\Binn\w95scm.dll

    - Application directory\80\Tools\Binn\Resources\1033\sqldmo.rll
    - Application directory\80\Tools\Binn\Resources\1033\sqlsvc.rll


    Am i missing something or is something wrong with the deployment. Pls assist

    Rgds
    Benone

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Did you register the DLLs or just copy them into the directory. I would think that they would need to be registered.

    Regards,

    hmscott
    Have you hugged your backup today?

  3. #3
    Join Date
    Oct 2003
    Location
    Cape Town
    Posts
    38
    There is only one (sqldmo.dll) that need to be registered and i did it ...
    Benone

  4. #4
    Join Date
    Dec 2002
    Posts
    1,245
    [shrug /]

    Dunno, I only try to use SQL DMO from my workstation which is loaded with more cr@p than I care to think about. What about making it a web app?

    Regards,

    hmscott
    Have you hugged your backup today?

  5. #5
    Join Date
    Mar 2003
    Location
    Indiana, USA
    Posts
    100
    Have you read this KB

    http://support.microsoft.com/kb/q248241/

    http://support.microsoft.com/Default.aspx?kbid=326613

    Edit: I did not understand the following but it may help you.

    http://nsis.sourceforge.net/SQLDMO_Installer

    Tim S
    Last edited by TimS; 12-19-05 at 13:59.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •