Stored Procedure & DateTime

[DKCK]

Hi,

I have a 8 bit datetime field in a SQL Server 7.0 database. What I am trying to do is use a stored procedure to update the field. Here is the sp:

CREATE PROCEDURE [sp_update_UserLeagueDraft]
(@ID [int],
@NextPick [int],
@Round [int],
@Deadline [datetime])

AS UPDATE [deadlystrikecom].[dbo].[UserLeagues]

SET [NextPick] = @NextPick,
[Round] = @Round,
[PickDeadline] = @Deadline
WHERE
( [ID] = @ID)
GO


Getting this error when the sp is run:

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

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


The main problem I think is datetime field.

[vb_dba]

Can you post your VB code where you are calling this stored procedure along with your connection string to the database?

Are you getting any errors on any other stored procedures you call?