Skip to Content.
Sympa Menu

freetds - Re: [freetds] PHP or Apache problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: jdyke <jdyke AT azimapower.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] PHP or Apache problem
  • Date: Fri, 08 Oct 2004 08:16:28 -0400

william van der wee wrote:

Jeff,

Thanks for your reply. But how do I find out the
path to unixODBC? The problem with SuSe is when
you install with yast you can not give any configure
options to the programm you want to install. Or is
this possible? PHP and unixODBC are allready
installed. Do I have to reinstall PHP and unixODBC
or can I change the configuration?
I installed freeTDS like this:


./configure --prefix=/usr/local/freetds
--disable-libiconv --enable-msdblib

I'm pretty sure you'll need to recompile freetds and let it know about unixODBC, which should be in /usr/local. if you run a `which isql' and `which odbcinst' they *should* share a directory which in my case, but i compiled from source, is /usr/local. Another option is to look at phpinfo() and see if YAST provided a path in its php configure argument --with-unixODBC if not, i would assume /usr/local, although assuming anything like that with a Yast install is tough.

of course when you do this, you may have to compile php again, as you'll have changed a linked binary....but maybe not.

HTH
Jeff


When I use isql -v etc etc, I connect to MS SQL and
make queries. No problem at all.

I hope you can help me.

Thanks.

William


--- Jeff <jdyke AT azimapower.com> wrote:


william van der wee wrote:


Hi all,

I'am using SuSe 9.1 with Apache and PHP. In order

to
get access to MS SQL server I installed freeTDS

ODBC
driver. Everything ok, except I can't get it in a

PHP
webpage. I use in my PHP scripts odbc_connect.
ISGL is working. When I look in apache error_log

it
say:
/usr/sbin/httpd2-prefork: error while loading

shared
libraries: /usr/lib/php/extensions/unixODBC.so: undefined symbol: SQLAllocEnv script not found or unable to stat

i would think its a compile problem with how this is
built into php

from this i assume you also built unixODBC then
compiled freetds with --with-unixODBC=/path/to/unixODBC? did that compile
go okay?

is ISGL ISQL? if not can you connect and execute
queries via isql on your Suse box.

how did you build php? do you not want to use the
built in mssql functions, using configure options
--with-mssql=/usr/local/freetds, of course compiling freetds with --with-msdlib.

Jeff





I'am not sure this is a PHP or an Apache problem.

Anybody have any experience with this.

Appreciate your help.

Thanks

William





Archive powered by MHonArc 2.6.24.

Top of Page