July 17, 2000 04:53 PM

Extend SQL Server with COM Automation

Rating: (0)
SQL Server Magazine
InstantDoc ID #9153
Automate COM objects from within seven SQL Server stored procedures
SQL Server's T-SQL programming language provides powerful facilities for data storage and retrieval, but T-SQL is weak when it tries to interact with systems outside the database. You can overcome this limitation, however, by using SQL Server's built-in COM automation environment, which lets you automate COM objects from within stored procedures. SQL Server 7.0 and SQL Server 6.5 provide seven extended ...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

sp_OAMethod parameters appear to have a maximum length of 255 characters (in the case of passing varchars). Is there a workaround to this to allow larger strings to be passed to a COM object's method?

Blake6/5/2001 8:04:30 PM


You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS