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
