Skip to Content.
Sympa Menu

freetds - Apache/PHP4/FreeTDS/unixODB/MS SQL Server7 on FreeBSD working

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Eric Liedtke" <jesus AT musinghalfwit.org>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Apache/PHP4/FreeTDS/unixODB/MS SQL Server7 on FreeBSD working
  • Date: Thu, 29 Nov 2001 16:42:26 -0500


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




Archive powered by MHonArc 2.6.24.

Top of Page