[freetds] PHP or Apache problem

jdyke jdyke at azimapower.com
Fri Oct 8 08:16:28 EDT 2004


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



More information about the FreeTDS mailing list