FreeTDS Development Group

[jdyke <jdyke AT azimapower.com>]

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