Many Pies

Many Pies

Friday, September 21, 2007

ODBC aaargh!

I came across an ODBC error:

PHP Warning: odbc_exec(): SQL error: [unixODBC][Driver Manager]Driver
does not support this function, SQL state IM001 in SQLSetStmtOption

If you're googling looking for the solution, like I did, and you came here, the best I can say is that SQLSetStmtOption appears to be deprecated. So the php/odbc code is calling something the driver doesn't support.

Even after upgrading from PHP4 to PHP5, and MySql4 to 5, it still occurs. The most frustrating thing is that I haven't found out a way of finding which version of ODBC is being used in the php/odbc component/rpm/package thingy.

Any ideas?
Post a Comment