ODBC Drivers - Optional feature not installed

[swilliams]

Hi,
I am getting the following error when I try to execute a SQL Server 7 stored procedure via ADO in an ASP page:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
[Microsoft][ODBC SQL Server Driver]Optional feature not implemented

The code that I am using is:

set cmd = Server.CreateObject("ADODB.Command&quot
Set cmd.ActiveConnection = con
cmd.CommandText = "s_Add_Article"
cmd.CommandType = adCmdStoredProc

cmd.Parameters.Append cmd.CreateParameter("Title", adVarChar, adParamInput,50)
cmd.Parameters.Append cmd.CreateParameter("Date", adDBDate, adParamInput)
cmd.Parameters.Append cmd.CreateParameter("Summary", adVarChar, adParamInput,250)
cmd.Parameters.Append cmd.CreateParameter("Main", adVarChar, adParamInput,2000)
cmd.Parameters.Append cmd.CreateParameter("Show", adInteger, adParamInput)

cmd("Title&quot = sTitle
If Len(sDate) <> 0 Then
cmd(&quot;Date&quot = CDate(sDate)
End If
cmd(&quot;Summary&quot = sSummary
cmd(&quot;Main&quot = sMain
cmd(&quot;Show&quot = iShow

cmd.Execute

and the error happens on the .Execute statement.

I have had a look at the ODBC driver and cannot see anywhere to 'instal optional features'.

Can anyone shed any light on this??

TIA [sig]<p>Simon<br>[/sig]