Re: Unable to pass DBDATE to stored-proc using ADO/C++

From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
Date: Thu, 8 Nov 2007 18:22:57 -0500

asnowfall@xxxxxxxxx wrote:

I am trying to pass DBDATE to a stored procedure but raw_Execute() is
failing with DB_E_ERRORSOCCURRED.

pParameter = pCmd->CreateParameter(_bstr_t("@e_date"),
adDate,adParamInput,sizeof(double));

The correct datatype for datetime parameters is adDBTimestamp, not adDate
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

.

References:
- Unable to pass DBDATE to stored-proc using ADO/C++
  - From: asnowfall@xxxxxxxxx

Prev by Date: Unable to pass DBDATE to stored-proc using ADO/C++
Next by Date: Re: AbsolutePosition
Previous by thread: Unable to pass DBDATE to stored-proc using ADO/C++
Index(es):
- Date
- Thread

Relevant Pages

Re: Data Project - Running SP via ADO
... Microsoft MVP -- ASP/ASP.NET ... Please reply to the newsgroup. ... This email account is my spam trap so I ...
(microsoft.public.data.ado)
Re: Updating column property on table gives error
... in code instead of when the append happens. ... Please reply to the newsgroup. ... This email account is my spam trap so I ...
(microsoft.public.data.ado)
Re: Writing a GUID to a SQL table
... I strongly suspect that it is SQL Server, ... >> Please reply to the newsgroup. ... This email account is my spam trap so I ...
(microsoft.public.inetserver.asp.db)
Re: VBSCript execute MS SQL Stored Procedure Return Value
... Microsoft MVP -- ASP/ASP.NET ... Please reply to the newsgroup. ... This email account is my spam trap so I ...
(microsoft.public.scripting.vbscript)
Re: using ado drivers with 64 bits software
... experts in one of the Access groups. ... Microsoft MVP -- ASP/ASP.NET ... Please reply to the newsgroup. ... This email account is my spam trap so I ...
(microsoft.public.data.ado)