Error:-Could not load the DLL xpDataComm.dll, or one of the DLLs it references.Reason: 1114(A dynamic link library (DLL) initialization routine failed.).

• hemant789

  Ten Centuries

  Points: 1052

  More actions

  February 26, 2009 at 10:55 am

  #128584

  I have created "xp_TestDataComm" extended stored procedure but i am getting below mentioned error when i execute "exec xp_TestDataComm"

  extended procedure.

  Error:-Could not load the DLL xpDataComm.dll, or one of the DLLs it references.Reason: 1114(A dynamic link library (DLL) initialization routine failed.).

  Server details are mentined below:-

  OS - Window server 2003 standard x64 Edition SP2

  SQL 2005 32 bit SP2

  I have Put xpDataComm.dll in Below paths :-

  "C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xpDataComm.dll" AND

  "C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\xpDataComm.dll"

  Executed below mentioned script on master database:-

  use master

  exec sp_addextendedproc 'xp_TestDataComm', 'xpDataComm.dll'

  exec sp_addextendedproc 'xp_SendToJFD', 'xpDataComm.dll'

  exec sp_addextendedproc 'xp_SendToMSMQ', 'xpDataComm.dll'

  -- Test Running the XP_dataComm procedures.

  exec xp_TestDataComm

  exec xp_SendToMSMQ

  exec xp_SendToJFD

  Please help me to resolve above mentioned issue.

• Ronald Cartmale

  Ten Centuries

  Points: 1010

  More actions

  March 5, 2013 at 5:32 am

  #1593424

  I believe that you have to specifiy the full path in the add extended proc command

  exec sp_addextendedproc 'xp_TestDataComm', '{FULLPATH}\xpDataComm.dll'