Stored Procedures

[CecileR]

What is wrong with my stored procedures???


cmd = "Provider=MSDASQL.1;Persist Security Info=False;Data Source=OCVSTAT;"
'Establish a connection with the database
Set cn = New ADODB.Connection
With cn
.ConnectionString = cmd
.Open cmd
End With

Set comm = New ADODB.Command
Set comm.ActiveConnection = cn
comm.CommandText = "OpenTempVCP"
comm.CommandType = adCmdStoredProc

Set RS2VCP = comm.Execute

Oh HELP PLS!!!

Thanks

cecile


The more u read, the more u do not know

[pmmbala]

replace this
Set RS2VCP = comm.Execute
like
RS2VCP = comm.Execute

try this

[pmmbala_old]

replace this
Set RS2VCP = comm.Execute
like
RS2VCP = comm.Execute

try this

[CecileR]

It returns back an error saying "Invalid property.. " so word "Set" must be there


cecile

The more u read, the more u do not know