Charly Crembil
|
| Posted: 03/25/2002, 5:16 PM |
|
Hi,
I'm generating PHP4 code with CC, that access a IBM's DB2 database with ODBC
on a Linux server.
After generate a simple grid form, when I execute it, the following error
appears:
Warning: SQL error: [IBM][CLI Driver] CLI0150E Driver not capable.
SQLSTATE=S1C00, SQL state S1C00 in SQLSetConnectOption in
/inet/modulos/www-home/www/db_odbc.inc on line 35
Looking into this file (db_odbc.inc), I've found the error appears when
calling odbc_pconnect(). The complete line looks like this:
$this->Link_ID=odbc_pconnect( $this->Database, $this->User, $this->Password,
$this->UseODBCCursor);
I don't know why, but Linux DB2's driver does not support this 4th
parameter. I've edited this function, and erased the 4th parameter, so the
line now looks like this:
$this->Link_ID=odbc_pconnect( $this->Database, $this->User,
$this->Password);
And It worked!
The problem now is that CC generates this file over and over, and I always
need to edit this file after generating.
Does anybody know how to change this in it's source CC?
Regards,
Carlos.
|
|
|
 |
Alexey Alexapolsky
|
| Posted: 03/26/2002, 2:22 AM |
|
Here goes your workaround :
1) Renamed the modified file
2) Open Modules section in CC Tree Vew
3) Select "Common" event , obtain generated code and modify the code
that includes this file to a new file name.
Enjoy ! 
--
Alex
CodeCharge Developer
"Charly Crembil" <nouser@hotmail.com> wrote in message
news:a7oi61$f1l$1@news.codecharge.com...
> Hi,
> I'm generating PHP4 code with CC, that access a IBM's DB2 database with
ODBC
> on a Linux server.
>
> After generate a simple grid form, when I execute it, the following error
> appears:
>
> Warning: SQL error: [IBM][CLI Driver] CLI0150E Driver not capable.
> SQLSTATE=S1C00, SQL state S1C00 in SQLSetConnectOption in
> /inet/modulos/www-home/www/db_odbc.inc on line 35
>
> Looking into this file (db_odbc.inc), I've found the error appears when
> calling odbc_pconnect(). The complete line looks like this:
>
> $this->Link_ID=odbc_pconnect( $this->Database, $this->User,
$this->Password,
> $this->UseODBCCursor);
>
> I don't know why, but Linux DB2's driver does not support this 4th
> parameter. I've edited this function, and erased the 4th parameter, so the
> line now looks like this:
>
> $this->Link_ID=odbc_pconnect( $this->Database, $this->User,
> $this->Password);
>
> And It worked!
>
> The problem now is that CC generates this file over and over, and I always
> need to edit this file after generating.
>
> Does anybody know how to change this in it's source CC?
>
> Regards,
> Carlos.
>
>
>
|
|
|
|
Charly Crembil
|
| Posted: 03/26/2002, 5:04 PM |
|
Thanks, Alex! Your workaround works fine.
I hope the CodeCharge developers correct this in future releases (may be
creating DB2 as a new Database Type instead of ODBC?).
Regards,
Carlos.
"Alexey Alexapolsky" <alexa@codecharge.com> escribió en el mensaje
news:a7pi5q$anr$2@news.codecharge.com...
> Here goes your workaround :
>
> 1) Renamed the modified file
> 2) Open Modules section in CC Tree Vew
> 3) Select "Common" event , obtain generated code and modify the code
> that includes this file to a new file name.
>
> Enjoy !
>
>
> --
> Alex
> CodeCharge Developer
>
>
> "Charly Crembil" <nouser@hotmail.com> wrote in message
>news:a7oi61$f1l$1@news.codecharge.com...
> > Hi,
> > I'm generating PHP4 code with CC, that access a IBM's DB2 database with
> ODBC
> > on a Linux server.
> >
> > After generate a simple grid form, when I execute it, the following
error
> > appears:
> >
> > Warning: SQL error: [IBM][CLI Driver] CLI0150E Driver not capable.
> > SQLSTATE=S1C00, SQL state S1C00 in SQLSetConnectOption in
> > /inet/modulos/www-home/www/db_odbc.inc on line 35
> >
> > Looking into this file (db_odbc.inc), I've found the error appears when
> > calling odbc_pconnect(). The complete line looks like this:
> >
> > $this->Link_ID=odbc_pconnect( $this->Database, $this->User,
> $this->Password,
> > $this->UseODBCCursor);
> >
> > I don't know why, but Linux DB2's driver does not support this 4th
> > parameter. I've edited this function, and erased the 4th parameter, so
the
> > line now looks like this:
> >
> > $this->Link_ID=odbc_pconnect( $this->Database, $this->User,
> > $this->Password);
> >
> > And It worked!
> >
> > The problem now is that CC generates this file over and over, and I
always
> > need to edit this file after generating.
> >
> > Does anybody know how to change this in it's source CC?
> >
> > Regards,
> > Carlos.
> >
> >
> >
>
>
|
|
|
|
|
