| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 948.1 | | CONSUL::KREISLER | Oracle Austria | Fri May 12 1995 14:24 | 7 |
| 948.2 | just check before IPMT. | ORAREP::GIDDAY::CHANM | | Mon Oct 16 1995 03:46 | 6 |
| 948.3 | | atxap1.at.oracle.com::EKREISLE | Oracle Austria | Tue Oct 31 1995 13:37 | 17 |
| 948.4 | Another one | CHSR38::ROHR | The Packers did it! | Wed Mar 26 1997 12:11 | 17 |
| My customer has the latest ODBC driver form the Rdb7 kit. Scanning
through the other notes for -7776, I checked his SQLSRV_GENERALIZED
DATE and in the log there is a space between the data and the time
whereas in the book client API there is no space in the table on 8-5.
Would following be regarded as normal:
------------[5].SQLTYPE: SQLSRV_GENERALIZED_DATE, SQLIND: 0
----------------len: 16, value: 19960910 0752300
------------[6].SQLTYPE: SQLSRV_GENERALIZED_DATE, SQLIND: 0
----------------len: 16, value: 19960910 0752300
If yes, are there other things I can have him check?
Thanks,
Regina
|
| 948.5 | Rdb/SQLSRV version? | M5::JBALOGH | | Wed Mar 26 1997 12:44 | 19 |
| What version of Rdb? SQLServices? I think there were changes to this
sometime in 6.1-x Rdb. Date ANSI, Date VMS or Timestamp?
To validate this from an ODBC point of view, you need to see what the
ODBC driver is sending to the application (I assume Access). The
SQLSRV_GENERALIZED_DATE is converted to an ODBC format in the ODBC
driver.
TO see actual values returned by the ODBC driver, you will need
ODBCTEST from the Microsoft ODBC SDK, a ODBC spy log (also microsoft),
or write the code in C and retrieve the date into the proper date
structure and look to see how it looks. Last I heard, you could
download the MS ODBC SDK 3.0 from Microsoft @ www.microsoft.com/odbc.
This was for a limited time so...
John
PS: MS Access is the only product I have heard of that returns this
error...
|
| 948.6 | .. | CHSR38::ROHR | The Packers did it! | Wed Mar 26 1997 13:46 | 9 |
| Rdb 6.1.1.0 SQl Service 6.1 (asked him to at least install ECO2).
Yes it is beloved MS Access...
>>>structure and look to see how it looks. Last I heard, you could
>>>download the MS ODBC SDK 3.0 from Microsoft @ www.microsoft.com/odbc.
Downloading like hell... ;-)
/Regina
|
| 948.7 | VMS upgrade and intermittent | CHSR38::ROHR | The Packers did it! | Wed Apr 02 1997 14:28 | 12 |
| Re .6:
Customer claims the problem started after an upgrade to VMS 6.2 (from
6.1). He now also told me that the problem is intermittent, means some-
times a table can be imported and sometimes it can not. Doesn't really
sound like an ODBC or SQl Services problem.
I also asked him to get in touch with MS.
Thanks for any further ideas.
Regina
|
| 948.8 | 6.1.0.2 installed and ok | CHSR38::RROHR | The Packers did it! | Fri Apr 04 1997 12:37 | 7 |
| Getting desperate, the customer finally installed SQS 6.1.0.2 (as
suggested a long time ago, sigh) and the error went away.
I couldn't find a reference in the release notes that are related to
an upgrade to VMS 6.2, though.
/Regina
|