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
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

*server
Microsoft SQL Server 2000 SP3
*client computers
Microsoft Access XP SP3
Microsoft Windows XP SP2

Hi, 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. <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> Regards Hemantgiri S. Goswami [email protected] "Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami

]]>