- SQL state S1C00 in SQLTransact error - help?

Hi folks,

I'm trying to set up a Solaris box to run phpBB forums software using
freetds and unixODBC to connect to an MSSql db.

All elements were installed without fanfare and only default settings.

I've managed to get the dsn working and can connect to the database for
just about everything however, at the point where I try to register a
user the following error is spat.

Warning: SQL error: [unixODBC]Option not supported, SQL state S1C00 in
SQLTransact in /WWW/FORUMS/db/mssql-odbc.php on line 195

Can anyone shed any light on this error message?  We've done some tests
and the driver can handle basic transactions which on the face of it
seems to be all that's being requested here.

Environment
phpBB 
freetds-0.61 
unixODBC-2.2.5 
php-4.3.0

the php code where the error occurs is:

                        if( $transaction == END_TRANSACTION &&
$this->in_transaction )
                        {
                                $this->in_transaction = FALSE;
                                
                                if ( !odbc_commit($this->db_connect_id)
)
                                {
                                        print("<br>QUERY:".$query);
                                        print("<br>ERR:
".odbc_errormsg($this->db_connect_id));
                                        print("<br>ERR NUMBER:
".odbc_error($this->db_connect_id));
                                
        
odbc_rollback($this->db_connect_id);
        
odbc_autocommit($this->db_connect_id, true);
                                        return false;
                                }
                                odbc_autocommit($this->db_connect_id,
true);
                        }

                        odbc_free_result($this->result);

Any help much appreciated.

Cheers

Tref



------------------------------------------------------
Tref Gare
Development Consultant
Areeba
Level 19/114 William St, Melbourne VIC 3000
email: trefg@xxxxxxxxxxxxx
phone: +61 3 9642 5553
fax: +61 3 9642 1335
website: http://www.areeba.com.au
--------------------------------------------




------------------------------------------------------
"This email is intended only for the use of the individual or entity named 
above and contains information that is confidential. No confidentiality is 
waived or lost by any mis-transmission. If you received this correspondence in 
error, please notify the sender and immediately delete it from your system. You 
must not disclose, copy or rely on any part of this correspondence if you are 
not the intended recipient. Any communication directed to clients via this 
message is subject to our Agreement and relevant Project Schedule. Any 
information that is transmitted via email which may offend may have been sent 
without knowledge or the consent of Areeba."
------------------------------------------------------