use parameter from VB

[lovalles]

i have on SQL defined the terminos store procedure that has one parameter tipos.
on my VB 6 form i have 2 objects, a textbox ( Text1 ) and a Adodc (adodc1) i have the following command:

Adodc1.ConnectionString = "Provider=SQEDB.1;Integrated Security=SSPI;" & _
"Persist Security Info=False;Initial Catalog=data;Data Source=SERVIDOR4"
Adodc1.CommandType = adCmdStoredProc
Adodc1.RecordSource = "terminos;1"
Set Text1.DataSource = Adodc1

i get the message that the terminos sp does not has the value for the @tipos parameter, How can i specify the value of the parameter?

 

[tlbroadbent]

Read the knowledgebase article at Microsoft. It explains how to pass parameters to a SP from ADO.

Missing Parameter Error Running Stored Procedure from ADO

http://support.microsoft.com/support/kb/articles/Q193/3/48.ASP

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.