FreeTDS Development Group

["Eric Liedtke" <jesus AT musinghalfwit.org>]

I just wanted to drop a note out in case anyone else has a similiar
problem. I installed unixODBC and FreeTDS per the sites, same with apache,
php4 etc. I could connect to my M$SQL7 server and do queries with isql,
however this didn't work with php. I usually just got garbage in the
results. This is what I did to fix it...

   putenv("ODBCINI=/usr/local/etc/odbc.ini");
   putenv("ODBCINSTINI=/usr/local/etc/odbcinst.ini");
   putenv("LD_LIBRARY_PATH=/usr/local/freetds/lib");

at the begining of the php script. Specifically the LD_LIBRARY_PATH did
it. Without it I get garbage. I have no idea why and would be curious if
there is any other solution, but regardless I just thought I'd point this
out. This actually came out of the example script in the iODBC php howto
page on iodbc.org.
Just and fyi
Eric Liedtke