How do I execute a stored procedure

Tech-Archive recommends: Fix windows errors by optimizing your registry

I have an Access Data Project (Access 2000) that links up to a SQL Server
on the backend. I have a stored procedure on the SQL server that accepts
two paramaters and then executes an update command. My question is how do I
reference the stored procedure and pass it the two paramaters in my Visual
Basic code. From what I understand I have to use ADO and create a public
subroutine and then call that routine when I want to execute the stored
procedure. Is there an easier method???? Any help is appeciated. Thanks,

--
Message posted via http://www.accessmonster.com
.

Relevant Pages

  • Re: Tracing user & permissions (triggers and stored p)
    ... To solve my problem I chosed to configure the SQL ... > from xp_cmdshell executes under the security context of the SQL Server ... >> sql Trigger executes a Stored Procedure passing it some variables. ...
    (microsoft.public.sqlserver.security)
  • slowing/halting stored procedure from ado.net
    ... When I execute the stored procedure from within SQL Server Management Studio ... it always executes fast, ... When the slowdown appears, restarting the application does not help. ...
    (microsoft.public.dotnet.framework.adonet)
  • SQL SERVER
    ... I have a scheduled job in sql server. ... This job is a executes a stored procedure. ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL server 2005 Express - Vista - Invalid object name #spdbdesc
    ... If you need to post the same question to multiple groups, post the message once to all groups in order to avoid duplication of effort. ... me with SQL Server Developer Edition under Vista. ... my application executes the stored procedure "sp_helpdb" ...
    (comp.databases.ms-sqlserver)
  • Setting size for a parameter for a varchar(max) field
    ... I am writing an application using VS2008 and SQL Server 2005. ... code that executes a stored procedure for a table that has a field ...
    (microsoft.public.vb.database.ado)