Re: problem with CVS version

Subject: RE: [ODBC] problem with CVS version
Date sent: Thu, 29 Jul 2004 08:46:02 +0100
From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Antonio Pennino" <a(dot)pennino(at)nocerainformatica(dot)net>,
<pgsql-odbc(at)postgresql(dot)org>

> Yes, I think it is the DM.

the solution *should* be the SQLSetConnectAttr().
No, it not work... my code is this:

_______________________________________________________________

long numero = SQL_AA_TRUE;
int valore = 0;
short shval = 0;
long native = 0;
SQLRETURN r = 0;
int n = 0;

char state[8] ; memset(state,0,sizeof(state));
char text[99] ; memset( text,0,sizeof(text));

/**/ r = SQLSetConnectAttr(hdbc,SQL_ATTR_ANSI_APP, // <<-!
(SQLPOINTER)&numero,
valore);

if (r)
{
r = SQLGetDiagRec(SQL_HANDLE_DBC,hdbc,1 ,
(unsigned char *) state,
&native,
(unsigned char *) text,
sizeof(text),&shval);
}

_______________________________________________________________

The result are:

a) the SQLSetConnectAttr() return -1

b) the SQLGetDiagRec() return:

. state = "S1092"
. text = "[...][...] Option type out of range"

Identical result i have with ms-access, perhaps are wrong the
arguments? I have take the idea from here:

http://publib.boulder.ibm.com/infocenter/db2v8luw/
index.jsp?topic=/com.ibm.db2.udb.doc/ad/c0008616.htm

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

telefono: 035/4219033
telefax : 035/4219050

e-mail : a(dot)pennino(at)nocerainformatica(dot)net
============================================