SEO

#1 (**permalink**) 02-27-2008, 05:42 AM

Hi,
I am trying to call SQLSetConnectAttr api but I am getting following
error:
SQLSTATE: HY024
Native: -99999
Message: [IBM][CLI Driver] CLI0191E Invalid attribute value.
SQLSTATE=HY024

I have created connection successfully but whiling setting connection
autocommit mode to false I am getting above error.

SQLUINTEGER autocommit;
autocommit = SQL_AUTOCOMMIT_OFF;
rc = SQLSetConnectAttr( hdbc, SQL_ATTR_AUTOCOMMIT, (void
*)&autocommit, 0);

Could some pls help ?

Regards
Ajay

#2 (**permalink**) 02-27-2008, 05:42 AM

ajay978@gmail.com wrote:

> Hi,
> I am trying to call SQLSetConnectAttr api but I am getting following
> error:
> SQLSTATE: HY024
> Native: -99999
> Message: [IBM][CLI Driver] CLI0191E Invalid attribute value.
> SQLSTATE=HY024
>
> I have created connection successfully but whiling setting connection
> autocommit mode to false I am getting above error.
>
> SQLUINTEGER autocommit;
> autocommit = SQL_AUTOCOMMIT_OFF;
> rc = SQLSetConnectAttr( hdbc, SQL_ATTR_AUTOCOMMIT, (void
> *)&autocommit, 0);

You are calling the function with the wrong parameters, and the explicit
casts prevent your compiler from raising an error/warning. Try this:

rc = SQLSetConnectAttr(hdbc, SQL_ATTR_AUTOCOMMIT, SQL_AUTOCOMMIT_OFF, 0);

p.s: As a general rule: if you need casts in your code, there is a high
chance that you have a problem in the code itself. (Of course, there are
exceptions to that rule.)

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

#3 (**permalink**) 02-27-2008, 05:42 AM

The third parameter is the value, not a pointer to the value. Your use of an
explicit cast to force the wrong value prevents the compiler from telling
you that your code is wrong, so you get told off at runtime.

<ajay978@gmail.com> wrote in message
news:1135931348.004449.284520@f14g2000cwb.googlegr oups.com...
> Hi,
> I am trying to call SQLSetConnectAttr api but I am getting following
> error:
> SQLSTATE: HY024
> Native: -99999
> Message: [IBM][CLI Driver] CLI0191E Invalid attribute value.
> SQLSTATE=HY024
>
> I have created connection successfully but whiling setting connection
> autocommit mode to false I am getting above error.
>
> SQLUINTEGER autocommit;
> autocommit = SQL_AUTOCOMMIT_OFF;
> rc = SQLSetConnectAttr( hdbc, SQL_ATTR_AUTOCOMMIT, (void
> *)&autocommit, 0);
>
> Could some pls help ?
>
> Regards
> Ajay
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

SetConnectAttr ODBC