Accessing Components within Stored Procedures

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Accessing Components within Stored Procedures

Author

Topic

augustin_p
Starting Member

21 Posts

Posted - 2002-04-26 : 00:38:32

i need to call a function of a component (ActiveX DLL built using Visual Basic). can anybody post a sample script for the same.

For E.g i have a component. prjSample.GenRowId. In that, i have a method, GenerateRowId(tblName as string). i need to call the method from within my stored procedure and pass the table name as parameter.

Thanks,
prasanna

khalik
Constraint Violating Yak Guru

443 Posts

Posted - 2002-04-26 : 01:42:10

i read about this in bol but not clear may be use ful to u

sp_addextendedproc
Registers the name of a new extended stored procedure to SQL

Syntax
sp_addextendedproc [ @functname = ] 'procedure' ,
[ @dllname = ] 'dll'

Programmers using Microsoft Open Data Services can create extended stored procedures. After an extended stored procedure is created, it must be added to SQL Server using sp_addextendedproc. For more information, see Creating Extended Stored Procedures.

======================================
Ask to your self before u ask someone

augustin_p
Starting Member

21 Posts

Posted - 2002-04-26 : 04:57:48

Hi khalik,
Thanks for your post. I have found a solution to my query. Objects can be created using SP_OACreate and can be accessed from within a stored procedure. sample scripts are available in SQL Books Online.

Thanks,
prasanna

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources