Results 1 to 2 of 2

Thread: How do you call a SQL Server from VB using ADO

  1. Aug 18th, 2000, 04:08 PM #1
    666539
    666539 is offline

    Thread Starter
    Member
    Join Date
    Aug 2000
    Posts
    51

    Question

    How do you call a stored procedure from Visual Basic using ADO? How do you pass the parameters to the Stored Procedure?
    Reply With Quote Reply With Quote
  2. Aug 18th, 2000, 05:15 PM #2
    JHausmann
    JHausmann is offline
    Frenzied Member
    Join Date
    Aug 1999
    Location
    Santa Clara, Ca , 95058
    Posts
    1,105
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width