Discussion Locked

invoking dll from a stored procedure

0 helpful

3 replies

by krisdevs Jul 7, 2001 last reply Aug 11, 2001

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

how do we call a vb or vc dll from an sp in sql server 6.5 or 7.0

3 replies

1. Place the dll in the C:\MSSQL7\BINN folder on the server.

2. Use the sp_addextendedproc procedure to register the dll and function:

sp_addextendedproc 'proc_name', 'dll_name'

ex. sp_addextendedproc 'xp_myproc', 'mydll.dll'

Thank u

This question was closed by the author

This discussion is closed to new replies.