SQL Server 7 sp_adduser StoredProc

Article View: borland.public.cppbuilder.database.ado

Article #3145

Back to borland.public.cppbuilder.database.ado Previous Next

#3145

From: Stephane Baillargeon
Date: Wed, 20 Nov 2002 15:59

22 lines
1711 bytes

I would Like to know how to use a stored procedure with the TADOStoredProc
Component.  I am familliar with the use of TADOQuery and TADOConnection but
the thing that eludes me is the actual binding of parameters within the
stored proc at runtime.

This stored proc has 4 params:
RETURN_VALUE
@loginame
@name_in_db
@grpname

I can't quite understand how to work with this stored proc although I have
read the help files that come with the software (BCB 6 Ent).

If someone would have examples or papers on using this component for sql
server internal (master) stored procedures, please let me know.

Regards,

Stephane Baillargeon
Video Game Programmer
Microids Canada

Technical Details

Message-ID: <3ddbb1b4@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-04!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!nntp.infostrada.it!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,337a479e55153b3c,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-11-20 08:10:05 PST
From: "Stephane Baillargeon" <sbaillargeon@microids.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: SQL Server 7 sp_adduser StoredProc
Date: Wed, 20 Nov 2002 10:59:59 -0500
Lines: 24
Organization: Microids Canada Inc.
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: 216.208.130.66
Message-ID: <3ddbb1b4@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1037808052 216.208.130.66 (20 Nov 2002 08:00:52 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-04!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!nntp.infostrada.it!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail