Calling Stored Procedures
Written by Eric Smith, Northstar Computer Systems LLC
You can use your stored procedures with ASP and ADO Connection objects; however, you don't need to use the word 'call' to do it. Just do like this, assuming the name of your stored procedure was 'updaterecord'.
Dim dcnDB ' As ADODB.Connection
dcnDB.Open ' connection string, whatever it is
dcnDB.Execute "updaterecord"
Putting the word 'call' or 'exec' will confuse ADO and you'll get an error.
Keywords: [
Data Access
]
Publication Date: 9/1/1999, Last Update: 3/24/2010
|