Re: CADORecordBinding ... adDate

That's ado ENUM reference "adDBTimeStamp". Both are ENUM value 135.

So, speaking from and OLE DB perspective, which is where I am when I do
think kind of binding ... what data type is this value? I'm using double
right now but am only guessing. And then, when OLE DB gives me this value,
what can I use to convert this to either a SYSTEMTIME or FILETIME?

I REALLY REALLY appreciate you sharing your knowledge!!!!!


> beginthreadex (beginthreadex@xxxxxxxxxxx) writes:
>> I am using RecordBinding from VC++ successfully against a SQL server
>> 2000 database. My issues revolve around getting datetimes from SQL into
>> anything readable in VC++ as a date/double/ULARGE??? variable. Right now
>> I can put this data into a double but the data is not able to be parsed.
>> There does not seem to be a clean conversion from double to a FILETIME
>> or other struct.
>>
>> How can I use CADORecordBinding and get a "getdate()" value from SQL
>> without converting to a varchar(x)?
>>
>> The sample in MSDN states using a DBDATE variable, but there's no success
>> with this. It also states that you should use ADO_FIXED in one sample and
>> then another is ADO_VARIABLE ... so I'm really confused and would really
>> welcome a solution at this point.
>
> The type indicator to use in OLE DB is DBTYPE_DBTIMESTAMP. Really how
> that translates when you drag in ADO, I don't know, as I have not
> worked with ADO from C++.

.

Relevant Pages

  • Re: Recommended data access model
    ... This is from MDAC 2.8 SDK. ... "The Role of ADO in MDAC ... The Microsoft Data Access Components provide data access that is ... easy-to-use interface to OLE DB. ...
    (comp.databases.ms-access)
  • Re: Table adapter ???
    ... ADO was a lightweight COM layer built on top of OLE DB. ... ADO and OLE DB updates came in downloads of the MDAC pack (Microsoft Data ... It also came with a OLE DB provider for ODBC which meant ...
    (microsoft.public.data.ado)
  • Re: ADO
    ... OLE DB, you need to usually use C++ as you are calling API's directly. ... Eventually, ADO will no longer be supported, and ADO.NET is the way forward ... >> Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: ADO
    ... OLE DB is a data access paradigm designed to provide an object interface to ... OLE DB data "providers". ... The original question asked which is better: ADO or OLE DB. ...
    (microsoft.public.data.ado)