943,734 Members | Top Members by Rank

Ad:
  • VB.NET Discussion Thread
  • Unsolved
  • Views: 4588
  • VB.NET RSS
Nov 28th, 2008
0

Call exe or dll from MS SQL SERVER 2005

Expand Post »
Hi Friends,
I am trying to Call a exe or DLL from sql server trigger using xp_cmdshell. Trigger is for an external application and for inserting a record. exe is executed successfully but trigger is not completed succefully and my external application is also not complted and it sows some error msg -"Description: Vendor. Database error (operation=GET, error=0). [Microsoft][SQL Native Client]Connection is busy with results for another command Please refer this error to your database administrator or see your database documentation for further assistance." Please provide some solution... Provide me alternative for xp_cmdshell to call a exe or dll.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
deepukng is offline Offline
18 posts
since May 2008
Jan 12th, 2009
0

Re: Call exe or dll from MS SQL SERVER 2005

I created one dll which talk with SharePoint Web Service and Return DataSet to crystal Report & also it fetch update Database with new Data.


dll is run when crystal report loded first time. all methods are called and DB Updated.


Now i want to call this dll from SQL 2005 is it Posible?

if Yes? then How............


Thanks & Regards,
Vibhuti Singh
INDIA
Reputation Points: 10
Solved Threads: 0
Newbie Poster
vibhuti_vrs is offline Offline
1 posts
since Aug 2008
Jan 12th, 2009
0

Re: Call exe or dll from MS SQL SERVER 2005

See OLE Automation Stored Procedures from MSDN Library.
Reputation Points: 218
Solved Threads: 201
Veteran Poster
Teme64 is offline Offline
1,024 posts
since Aug 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in VB.NET Forum Timeline: list xml files residing in another web server
Next Thread in VB.NET Forum Timeline: Export Data to Notepad





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC