>Hi there,
>
>What I was trying to do was use a stored procedure. I've used a straight recordset object and that's working fine, but eventually I'm gonna need to get these stored procedures working. At the moment I'm working over a LAN and the speed isn't so much of a problem but my client software will eventually work over a WAN using TCP/IP to connect. When that's up and running I'm gonna need those stored procedures.
>
>The code is :
>
>local loCM, loRST
>
>loCM = createobject("adodb.command")
>
>loCM.ActiveConnection = goCn
>loCM.CommandText = "GetExpenseCursor"
>loCM.CommandType = gnCmdStoredProc
>
>loRST = loCM.execute
>
>The error message that is returned is 'CLINIC.GetExpenseCursor is undefined'. I do have the priviledges to run this procedure.
>
>Thanks for your input.
>
>Pablo

If you set the type to adCmdStoredProc you don't need to specify the calling syntax. The provider should know how to call a stored procedure on the backend. You only need to specify the stored procedure's name. See the corrections on your code above, in bold. I took out the MCC.CLINIC. assuming that this is part of the fully qualified database name.

HTH