Board index MS SQL Server

HELP!!! Extended Stored Procedure and vb

HELP!!! Extended Stored Procedure and vb

Post by sd » Wed, 18 Jul 2001 10:33:24



Hello
Does anyone out there know where I can find an example of an extended stored
procedure calling a VB dll. Thanks
Brian


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----==  Over 80,000 Newsgroups - 16 Different Servers! =-----

 
 
 
Top

HELP!!! Extended Stored Procedure and vb

Post by Greg Linwoo » Wed, 18 Jul 2001 11:02:21


Assuming your VB .dll is a COM server, you use the sp_OAxxx set of stored
procedures, such as sp_OACreate etc. These are documented well in Books
Online and additional COM error handlers are also provided to assist.

Suggest that you consider using a VB ActiveX .exe type COM server which will
run out of process from the main SQL Server Win Process. Generally this is a
better approach, assuming that there is not a large amount of communicatoin
between SQLServer and the COM Object/s.

I think that extended stored procs cannot easily be written in VB but are
really intended for C.

Cheers,
Greg Linwood


> Hello
> Does anyone out there know where I can find an example of an extended
stored
> procedure calling a VB dll. Thanks
> Brian


> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----==  Over 80,000 Newsgroups - 16 Different Servers! =-----


 
 
 
Top

HELP!!! Extended Stored Procedure and vb

Post by Gert E.R. Draper » Wed, 18 Jul 2001 12:59:18


You can not build Extended Stored Procedures in VB.
-GertD


> Hello
> Does anyone out there know where I can find an example of an extended
stored
> procedure calling a VB dll. Thanks
> Brian


> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----==  Over 80,000 Newsgroups - 16 Different Servers! =-----

 
 
 
Top

HELP!!! Extended Stored Procedure and vb

Post by Mike » Thu, 19 Jul 2001 00:26:21


VB .DLL's are OLE Automation servers and don't exist as a C or other compiled language .DLL file.  Whatever language you have used to create your extended stored procedure in should have a mechanism to talk to "COM" objects.  The VB .DLL is one such object.

> Hello
> Does anyone out there know where I can find an example of an extended stored
> procedure calling a VB dll. Thanks
> Brian


> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----==  Over 80,000 Newsgroups - 16 Different Servers! =-----

 
 
 
Top

1. Calling extended stored procedure from stored procedure

I have problem.

When I call an extended stored procedure (in master db) from a stored
procedure (in my db on same SQL Server), I am unable to find the extended
stored procedure. Does anyone know why? Does anyone know how to correct this
problem?

Thanks in advance,
Sam

2. Parametrize Cursor declaration

3. Stored Procedures vs Extended Stored Procedures

4. SP5 Available

5. output parameters stored procedures / extended stored procedures

6. summary table with methods?

7. Extended Stored Procedures available in VB?

8. Updating a DataGrid Cell value

9. Creating Extended Stored Procedures in VB

10. Extended Stored Procedures in VB

11. Extended stored procedures in VB?

12. Extended stored procedures in VB 6

13. Good extended stored procedure reference for VB


All times are UTC
Board index