Optional feature not implemented

[derren]

Hi

I have been testing and running a SQL server 2000 web application using stored procedures, and it is running a treat. However, now that the database and application is posted onto the web I get this error when executing a stored procedure with any parameters:

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

[Microsoft][ODBC SQL Server Driver]Optional feature not implemented

I can query data, update data and delete records no problem using normal ADO methods, but when it comes to the SPs it falls down. There is executable rights for the user on the SP and all rights on the table.

There is plenty of advice regarding the datestamp parameter type, but I am not using these. I have tried the parameters.refresh routine to get the params list and it matches my code to a tee. Surely if it was my code or the database then it would fail locally as well.

I am tearing my hair out - any ideas

Thanks Derren
[Mediocre talent - spread really thin]

 

[derren]

Well, obviously it has stumped you as well

In the end I needed to change all of my input parameters to varchar and then convert them to bigint or int within the stored procedure, and this worked.

I can't help but think that this is not right or proper though Derren
[Mediocre talent - spread really thin]