FYI - I'm using ADO 2.5 and it works

This worked for me:

Cmd1.ActiveConnection = Conn1

Cmd1.CommandText = "sp_AdoTest"

Cmd1.CommandType = adCmdStoredProc

Cmd1.Parameters.Refresh

Cmd1.Parameters("varName").Value = 10

Set Rs1 = Cmd1.Execute()

From the following link:

http://support.microsoft.com/kb/174223

hmm yes i see - that is annoying - the only thing I can think of is to create a 'wrapper' stored procedure that's tightly coupled to the ADO code...

Instead of doing cmd.Parameters.Refresh try using:

Dim objParam as ADODB.Parameter

Set objParam = cmd.CreateParameter(Name, Type, Direction, Size)

cmd.Parameters.Append

objParam.Value = yourvalue

( ex: CreateParameter("@BatchNo", adInteger, adParamInput)

...

I'm having exactly the same issue linking 2005 to 2000 only difference is that my 2005 is 32bit and the error I get when running an OpenQuery is:

OLE DB provider...