Skip site navigation (1) Skip section navigation (2)

Re: problem with CVS version

From: "Antonio Pennino" <a(dot)pennino(at)nocerainformatica(dot)net>
To: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: problem with CVS version
Date: 2004-07-27 13:18:25
Message-ID: 41067241.26067.131E6AA@localhost (view raw or flat)
Thread:
Lists: pgsql-odbc
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
============================================


In response to

pgsql-odbc by date

Next:From: Dave PageDate: 2004-07-27 13:56:22
Subject: Re: problem with CVS version
Previous:From: Dave PageDate: 2004-07-27 12:27:30
Subject: Re: problem with CVS version

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group