Getting Output from Stored Procedure

[nethertoni]

I am new at coding adp and sql server. I am having trouble getting a
single output from a stored procedure.
Prodedure:
CREATE PROCEDURE dbo.spGetData (@ContactID int,
@EmpName nvarchar(100) OUTPUT)
AS
SELECT @EmpName = C.ContactName
FROM dbo.Contacts C
WHERE C.ContactID = @ContactID
GO

Code to call from adp:
Dim intTest as Integer
Dim strTest as String

intTest = 100
strTest = CurrentProject.connection.Execute ("spGetDate " & intTest)

What am I doing wrong?

 

[Sylvain Lafontaine]

The Execute method of the Connection object can only return you a recordset.
You must use a Select statement to get this value back from a Connection
object or use a Command object to get the value of your output parameter.
See the following thread to get a full explanation with an example:

http://groups.google.ca/group/micro...aramoutput+lafontaine&rnum=1#308987cda95ed87f