SQL Serv Syntax Error or Access Violation

[Mike Thomas]

This one must be very simple. I am trying to run an SQL Serv 7.0 stored
proc
from a VBA module in an Access 2000 app. This stored proc runs fine when I
remove the parameters from the stored proc and from the CommandText string
below, but when I run it as is I get the error
SQL Serv Syntax Error or Access Violation

on the "Execute" line. _ContactFetchLike 'Thom%' also works when I run it
from the Query Analyser.

The connection string seems ok, it works everywhere else.

glConnCmd.CommandText = "_ContactFetchLike 'Thom%'"
glConnCmd.CommandType = adCmdStoredProc
glConnCmd.Execute '' error on this line
rs.Open glConnCmd

This is the stored proc:

CREATE procedure _ContactFetchLike
@strString varchar(30)
AS SELECT * FROM contact WHERE company like @strString

RETURN

It must be something pretty simple. Does any have any ideas.

Many thanks
MIke Thomas