FreeTDS Development Group

[Peter Harvey <pharvey AT codebydesign.com>]

Turn on ODBC trace and send resulting output (from running under PHP as 
Apache module) to me and I will see what I can do.

Peter

BTW: It may be that cursor support *must* be implemented for this to 
work and I am not prepared to do that - at least not right now. 
Hopefully the solution is much simpler than that. :)


Helio Cavichiolo Jr wrote:

> I'm still waiting that a God's soon can help me on this.
> I've identified the problem, but don't know how to correct it.
> I have PHP compiled as cgi and as Apache module. Both with same compiling 
> options (except for cgi option).
> Using PHP as CGI I can run a script that connects to a SQLServer via unixODBC 
> + freetds without problems, but when I try it with PHP as Apache module, it 
> crashes because during a select preparation, PHP calls a freetds function 
> called SQLSetStmtAttr with SQL_CURSOR_TYPE option, still not implemented.
> It looks that just returning the supported one to PHP would be enough, but I 
> don't know how to do this.
> I tried just placing this inside the case:
>
> SQL_CURSOR_TYPE:
>  break;
>
> But then, nothing is returned.
>
> The freetds SQLSetStmtAttr is:
>
> SQLRETURN SQL_API SQLSetStmtOption(
>                                 SQLHSTMT           hstmt,
>                                 SQLUSMALLINT       fOption,
>                                 SQLUINTEGER        vParam)
> {
>   CHECK_HSTMT;
>   switch (fOption)
>   {
>   case SQL_ROWSET_SIZE:
>       /* Always 1 */
>       break;
>   default:
>       tdsdump_log(TDS_DBG_INFO1, "odbc:SQLSetStmtOption: Statement option %d 
> not implemented\n", fOption);
>       odbc_LogError ("Statement option not implemented");
>       return SQL_ERROR;
>   }
>   return SQL_SUCCESS;
> }
>
>
> ---
> You are currently subscribed to freetds as: [pharvey AT codebydesign.com]
> To unsubscribe, forward this message to $subst('Email.Unsub')
>
>
>