Sql Dmo Dll's deployment problem | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

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. – WindowsSystem32sqlunirl.dll – Application directory80ToolsBinnsqldmo.dll ( with registration activated)
– Application directory80ToolsBinnsqlresld.dll
– Application directory80ToolsBinnsqlsvc.dll
– Application directory80ToolsBinnw95scm.dll – Application directory80ToolsBinnResources1033sqldmo.rll
– Application directory80ToolsBinnResources1033sqlsvc.rll
Am i missing something or is something wrong with the deployment ? Pls assist Rgds

Confirm the level of service pack on SQL SErver & Windows including access. Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Microsoft SQL Server 2000 SP3
*client computers
Microsoft Access XP SP3
Microsoft Windows XP SP2
Hi,<br />is all library registered successfull !? install client tools only and deploy your package at client side and ensure mdac version are same at client and server side. <br /><br /><br /><img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /><br />Regards<br /><br /><br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami<br />