Skip to Content.
Sympa Menu

freetds - RE: Statement option not implemented, SQL state 08001 i n SQLSetStmtOption

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: ZIGLIO Frediano <Frediano.Ziglio AT vodafoneomnitel.it>
  • To: "'TDS Development Group'" <freetds AT franklin.metalab.unc.edu>
  • Subject: RE: Statement option not implemented, SQL state 08001 i n SQLSetStmtOption
  • Date: Mon, 16 Sep 2002 10:05:25 +0200


>
> I have a problem with accessing from PHP client to server MSSQL2000
> (Windows 2000 Server)
> Configuration is RedHat Linux 7.2, PHP4.2 on Apache (1.3.26), mod SSL
> (2.8), mod UnixODBC, FreeTDS (0.53 or 0.60)
> Every call "$result = ODBC_exec($ODBCdns,$query);" causes an error
> "Warning: SQL error: [unixODBC]Statement option not
> implemented, SQL state
> 08001 in SQLSetStmtOption on line...." and there are no data
> returned, in
> $result: "Supplied argument is not a valid ODBC result resource in"
> isql utility works fine, every query is succesfully executed
> and return
> data.
> I compiled FreeTDS with ./configure --with-tdsver=4.2 --enable-msdblib
> --enable-dbmfix --with-gnu-ld --enable-shared --enable-static,
> also try --with-ssl.
> This happen on both TDS version 4.2 and 7.0, I used various queries
> (SELECT , INSERT, SET,...), same result.
> I think the problem is beetween Apache, UnixODBC and FreeTDS, so isql
> utility works fine on the same DNS source, I try access to
> PHP thru both
> HTTP:// and HTTPS://, same result.
> I search the web, but I don't find any hint that anybody has the same
> problem.
>
>
> Thanks for fast response
> Miroslav Eder
>
ODBC is not much completed...
Best result with php is using --with-sybase-ct=/... and mssql_* api.

freddy77

=================================
"STRICTLY PERSONAL AND CONFIDENTIAL

This message may contain confidential and proprietary material for the sole
use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient please contact
the sender and delete all copies.
The contents of this message that do not relate to the official business of
our company shall be understood as neither given nor endorsed by it."

=================================



  • RE: Statement option not implemented, SQL state 08001 i n SQLSetStmtOption, ZIGLIO Frediano, 09/16/2002

Archive powered by MHonArc 2.6.24.

Top of Page