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(at)vale-housing(dot)co(dot)uk>
To: "Antonio Pennino" <a(dot)pennino(at)nocerainformatica(dot)net>
Copies to: <pgsql-odbc(at)postgresql(dot)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(dot)pennino(at)nocerainformatica(dot)net
============================================