How do you call a SQL Server from VB using ADO [Archive]

Click to See Complete Forum and Search --> : How do you call a SQL Server from VB using ADO

666539

Aug 18th, 2000, 04:08 PM

How do you call a stored procedure from Visual Basic using ADO? How do you pass the parameters to the Stored Procedure?

JHausmann

Aug 18th, 2000, 05:15 PM

Use a command object. Use the parameters.append method to add the input (and output) parms.

I advise you to get the book:

HitchHiker's Guide to Visual Basic and SQL Server by William Vaughn (at least the sixth edition. Any earlier than sixth has little or no information on ADO) - ISBN 1-57231-848-1