I've big trouble whe assigning parameters to a Command which ActiveConnection property was asigned by a Connection object whithout a DSN (that means, by manually assigning the ConnectionString).
The problem is, that when I try to access a Parameter from the Collection Parameters, it returns an Error.
Do I have to create again each parameter in VB?
for example :
MyCommand.Parameters.Refresh
number=MyCommand.Parameters.Count
number has 0 in its value.
I've tried creating a ADODB.Parameter Object, but the problem is when I simply don't know, how many parameters does the Command have.
The problem is, that when I try to access a Parameter from the Collection Parameters, it returns an Error.
Do I have to create again each parameter in VB?
for example :
MyCommand.Parameters.Refresh
number=MyCommand.Parameters.Count
number has 0 in its value.
I've tried creating a ADODB.Parameter Object, but the problem is when I simply don't know, how many parameters does the Command have.