[freetds] SQL error during odbc_connect in PHP using FreeTDS

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Tue Jan 10 07:24:31 EST 2006


> 
> I´m affraid I don´t understand what to do. There is not 
> stdout file and the only one information was generated on 
> stdout I think. Should I find any log file or ?
> 
> Standa
> 

Well, setting TDSDUMP environment should enable debug dumping of FreeTDS in a specified file. I suggested stdout as a special name that should output dump on standard output (usually the console you lanched your program, in this case PHP). For a short period this feature was a bit broken and setting TDSDUMP to stdout cause our library to write to "stdout" file instead of standard output. This is why I suggested to check for a "stdout" file. You can also use a command like

   TDSDUMP=log.txt php script.php

and check for "log.txt" file. If there is no log try to see if debug flags is set correctly in freetds.conf (well, freetds_mssql.conf for you).

$ cat ~/.freetds.conf | grep flag
        debug flags = 0x6fff

(this should be in global section)

freddy77


More information about the FreeTDS mailing list