If this is going to be a popular .dll, you may just want to bite the bullet and write it in C. Any VB workarounds will take a performance hit.
Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -----Original Message----- From: John McCosker [mailto:J.McCosker@;andronics.co.uk] Sent: Friday, November 15, 2002 8:17 AM To: CF-Talk Subject: calling a dll from an sql stored proc Greetings, Has anyone called a dll from a stored procedure, I am aware you can create custom stored procs that are dll's but the sql API only understands dll's in c or c++, I want to write it in VB. The problem is with a trigger, that when an update occurrs I need it to create a recordset and loop throug it performing calculations from the recordset then inserting the results into a new table, this can be done with a Cursor, but is very slow and I have been told is very resource intensive on sql server. We don't want to do this as the trigger will be called often. An alternative would be if a stored proc could call a flat file, i.e. a cfm or asp page and then do the maipulation here. We have thought of a third alternative which will work, send an email to an INBOX via sgl server and have the inbox agent call the dll, but the result has a latency due to the email request. Would appreciate any thoughts, Respectfully, J ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
