Subject: RE: [ODBC] problem with CVS version
Date sent: Thu, 29 Jul 2004 08:46:02 +0100
From: "Dave Page" <dpage@vale-housing.co.uk>
To: "Antonio Pennino" <a.pennino@nocerainformatica.net>,
<pgsql-odbc@postgresql.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.pennino@nocerainformatica.net
============================================