[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