VBA call store procedure



Can someone provide me with a snippet of code that allows me to call a
store procedure that resides in a SQL Server?
.



Relevant Pages

  • Re: dbrpcparam datalen problem
    ... I tried to use it for the store procedure call: ... and which the version of SQL Server following SQL 2008 will not support. ... not support features added in later versions. ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • ADOConnection TimeOut 30 second, no way to change it ???
    ... i use ADOConnection component to connect to SQL Server and using TQuey to ... When i execute the store procedure, it look like the setting is no effect ...
    (borland.public.delphi.database.ado)
  • Cant print Crystal Report from SQL
    ... My store procedure call sp_OACreate and sp_OAMethod to a DLLname.DLLclass ... which is a wrap around Crystal Report CRAXDRT object. ... Here is an error message from SQL server store procedure. ...
    (microsoft.public.sqlserver.security)
  • Re: how can i send mail by using sql server
    ... paramater to be pass to this store procedure if i want to send mail ... msg in query analyzer... ... don't understand how sql server communicates with email. ... notification email in the job scheduler! ...
    (comp.databases.ms-sqlserver)
  • Re: Troubles with Locks and insolation leves
    ... I've been having problems with the locks in SQL Server. ... > a visual basic aplication that runs a store procedure. ... I don't know how to control it. ...
    (microsoft.public.sqlserver.programming)

Loading