SQLGetTypeInfo claims that TIMESTAMP type is not supported

From: jarmo.k.makinen@xxxxxxxxx
To:   win32@xxxxxxxxxxxxxxx
Subject: SQLGetTypeInfo claims that TIMESTAMP type is not supported

Description:
      My code is trying to retrieve datatypes mysql supports. Code is here:

    if (SQLGetTypeInfo(hstmt, fSqlType) != SQL_SUCCESS)
        return(DispAllErrors(henv, hdbc, hstmt));

    // Fetch the record
    retcode = SQLFetch(hstmt);

      When I try to determinate whatever TIMESTAMP (fSqlType=11, SQL_TIMESTAMP),
      is supported SQLFecth return 100 = NO_DATA

      For numeric types this works fine. But for TIMESTAMP and DATE it does not 
work.
      But I know that mysql does support these types!!! Whats wrong?

How-To-Repeat:
      Code above

Fix:
      ...

Synopsis:   <synopsis of the problem (one line)>
Submitter-Id:     <submitter ID>
Originator: Jarmo Mäkinen
Organization:
MySQL support:  none
Severity:   serious
Priority:   medium
Category:   mysqld, MyODBC 3.51.06
Class:            sw-bug
Release:    mysql-3.23.54

Exectutable:   mysqld-nt and myODBC driver
Environment:   Fujitsu Amilo A7600 XP2200+
System:        winxp home
Compiler:      VC++ 6.0
Architecture:  i



With regards,


Jarmo Mäkinen




---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before
posting. To request this thread, e-mail win32-thread10641@xxxxxxxxxxxxxxx

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail win32-unsubscribe@xxxxxxxxxxxxxxx instead.