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
============================================