What version of ADO are you using?

>I am currently facing a strange problem...
>
>Check out this code...
>
>

>
>	oConnection = CreateObject("adodb.connection")
>	with oConnection
>		.Provider = "MSDAORA"
>		.ConnectionString = "Persist Security Info=False;Password=quest;User ID=quest;Data Source=TJM"
>		.Open
>	endwith
>	
>	oCommand = CreateObject("adodb.command")
>	with oCommand
>		.ActiveConnection =  oConnection
>		.commandtext = "GetStatus"
>		.CommandType = ADCMDSTOREDPROC
>		.Parameters.append(.CreateParameter("RETURN_VALUE",3,4,0))
>		.Parameters.append(.CreateParameter('p_mainkey',adVarchar,adParamInput,10,'0000000046'))
>		.Parameters.append(.CreateParameter('p_module',adInteger,adParamInput,1,1))
>		.Execute
>	endwith
>	
>	?oCommand.Parameters(0).Value
>
>

>
>The strange part is that as soon as I execute this code I get to the lines..
>.CommandType = ADCMDSTOREDPROC
>
>As soon as I do this the parameters are appended to the command automatically after a split second delay. So after the parameter appends I have 6 parameters...
>
>This only happens on Oracle but not SQL Server. I don't mind it but I need
>it to work in a consistant way if possible...
>
>Anyone know how to disable this? I find it strange since the
>parameters.refresh doesn't work?!?!
>
>
>The other problem is oracle does not like the parameters with names like
>@p_mainkey is there a different syntax I can use on SQL Server because it SUCKS
>having to hardcode two methods for each server...