Re: SQL Stored Procedure

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Naresh Nichani MVP (nareshnichani_at_HOT)
Date: 10/16/04 

Date: Sat, 16 Oct 2004 18:52:07 +0530

Check this out --

http://www.experts-exchange.com/Databases/Q_20979251.html

Regards,

Naresh Nichani
Microsoft Access MVP

"Hubert Hoffman" <bnhcomputing@yahoo.com> wrote in message
news:00ce01c4b2e7$b320fe90$3a01280a@phx.gbl...
>
> I have SQL-Server 2000. Many stored procedures, each with
> parameters.
>
> What is the proper method for executing a SQL-Server
> stored procedure from ACCESS 2000?
>
> How do I pass the parameter values to the procedure?
>
> Thanks in advance for any information.
>
> Regards,
>
> Hubert Hoffman

Relevant Pages

  • Re: SQL Problem
    ... My Access db is distributed to one user for input and about a dozen users ... I should bone up on stored procedures. ... >>Did I mention that my Access query includes queries, ... > as stored procedures in SQL-Server. ...
    (microsoft.public.dotnet.general)
  • Re: Insert into Sonderzeichen
    ... Verwende Stored Procedures und erfreue Dich an dem vom ... dass das ganze nur mit einem SQL-Server funktioniert. ... Solltest Du aber eine ACCESS DB verwenden, ...
    (microsoft.public.de.german.entwickler.dotnet.vb)
  • Infomessage in ADO Connection
    ... I am trying to use the OnInfomessage event for TADOConnection to catch ... messages coming from stored procedures in SQL-Server. ... I am using SQLOLEDB and the connections CursorLocation is set to ...
    (borland.public.delphi.database.ado)
  • Re: Odbc connections and ADP?
    ... If you don't want to use ADO, then there is the possibility of setting up ... the connection to the Oracle Server directly on the SQL-Server and perform ... your queries to Oracle from stored procedures. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Putting stored procedures in a dll
    ... Regards, ... Soumitra ... > I have a question regarding sql server stored procedures. ...
    (microsoft.public.dotnet.faqs)