Extending Transact-SQL with external call to VB 
Author Message
 Extending Transact-SQL with external call to VB

I am extending a packaged application which can only be changed in the
Transact-SQL.
I know of no way for Transact-SQL to interact with the user (even a
Message Box function would be helpful).  Therefore I'm interested
calling a VB5 procedure to get any user input and return it to
Transact-SQL.
I've read various ways to do this, but they all seem to require the
installation of Open Data Services, which seems like overkill (if it is
really the right solution)
Is there an easy way to call an external procedure from Transaction-SQL
and return some data?

Please reply to my email address. Thanks - Andrew



Fri, 03 Mar 2000 03:00:00 GMT
 Extending Transact-SQL with external call to VB

Andrew,

Would the sp_OA... procedures (in 6.5) help you? They make SQL Server
become an OLE Automation Controller.
--

MCSE, MCSD, MCT, SQL Server MVP
Cornerstone Sweden AB



Quote:
> I am extending a packaged application which can only be changed in the
> Transact-SQL.
> I know of no way for Transact-SQL to interact with the user (even a
> Message Box function would be helpful).  Therefore I'm interested
> calling a VB5 procedure to get any user input and return it to
> Transact-SQL.
> I've read various ways to do this, but they all seem to require the
> installation of Open Data Services, which seems like overkill (if it is
> really the right solution)
> Is there an easy way to call an external procedure from Transaction-SQL
> and return some data?

> Please reply to my email address. Thanks - Andrew




Sat, 04 Mar 2000 03:00:00 GMT
 Extending Transact-SQL with external call to VB

This would probally work, but not if the user needs interaction with the
client. Anything that the OLE proc pops up will appear on the server, not
the client...

--
Brian Moran
Chief Architect
Spectrum Techology Group
SQLServer MVP, MCSE, MCSD, MCT

Check out my monthly SQL column
in Windows NT Magazine!



Quote:
> Andrew,

> Would the sp_OA... procedures (in 6.5) help you? They make SQL Server
> become an OLE Automation Controller.
> --

> MCSE, MCSD, MCT, SQL Server MVP
> Cornerstone Sweden AB



> > I am extending a packaged application which can only be changed in the
> > Transact-SQL.
> > I know of no way for Transact-SQL to interact with the user (even a
> > Message Box function would be helpful).  Therefore I'm interested
> > calling a VB5 procedure to get any user input and return it to
> > Transact-SQL.
> > I've read various ways to do this, but they all seem to require the
> > installation of Open Data Services, which seems like overkill (if it is
> > really the right solution)
> > Is there an easy way to call an external procedure from Transaction-SQL
> > and return some data?

> > Please reply to my email address. Thanks - Andrew




Mon, 06 Mar 2000 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Extending Transact-SQL?

2. Call external function in .LIB from VB

3. Calling an external batch file or executable from VB

4. Calling an external batch file or executable from VB

5. calling an extended stored procedure from VB

6. Calling Corba Servers through Transact-SQL

7. Calling COM object from Transact-SQL stored procedure

8. Calling Corba Servers through Transact-SQL

9. Calling .NET Classes from Transact SQL

10. Calling Transact SQL Function

11. Calling Corba Servers through Transact-SQL code

12. Calling C-functions from transact SQL


 
Powered by phpBB® Forum Software