Re: problem with CVS version

Subject:            RE: [ODBC] problem with CVS version
Date sent:          Tue, 27 Jul 2004 13:27:30 +0100
From:               "Dave Page" <dpage@vale-housing.co.uk>
To:                 "Antonio Pennino" <a.pennino@nocerainformatica.net>
Copies to:          <pgsql-odbc@postgresql.org>

> Hmm, there's nothing in there that looks odd to me, but then I've never
> dug quite this deep into the driver before. I assume '#eliminato'
> translates to '#deleted'?

Yes, but is NOT only a MS-ACCESS 97 problem because
with my dump utility a see m_nSQLType (MFC) = -9 !!!

This variabile is obtained from ::SQLDescribeCol(), this  MFC
fragment show who MFC use this API:

AFX_ODBC_CALL(::SQLDescribeCol(m_hstmt,
                 n,
            (UCHAR*)lpszFieldName,
                 MAX_FNAME_LEN,
                 &nActualLen,
            &m_rgODBCFieldInfos[n - 1].m_nSQLType,
            &m_rgODBCFieldInfos[n - 1].m_nPrecision,
            &m_rgODBCFieldInfos[n - 1].m_nScale,
            &m_rgODBCFieldInfos[n - 1].m_nNullability));


I may send the source of my utility if someone want it.
It require Microsoft Visual Studio 6.

Perhaps the ::SQLDescribeCol() is deprecated for psql but MFC
use it and i CAN NOT write my code without the MFC framework.

If, instead of the CVS version and/or the beta version from
Dave, i use an older (7.1.2004) version of psqlodbc.dll,
m_nSQLType is = 12.

The server is the 7.2.1

Thanks for any help.


============================================
Antonio Pennino
Nocera Informatica s.r.l.

telefono: 035/4219033
telefax : 035/4219050

e-mail  : a.pennino@nocerainformatica.net
============================================