FreeTDS Development Group

[Bob Kline <bkline AT rksystems.com>]

On Tue, 4 Jul 2000, Andrius Lokotash wrote:

> 
> Hi all.
> 
> We hawe still problems with it, ....

One more suggestion ...

> (we are using php 4)
> freetds:
> ./configure --with-tdsver=4.2
> php:
> ./configure --with-mysql --with-apache=
> (path) --enable-sigchild --enable-ttf --with-sybase=/usr/local/freetds/
> 
> php is compiled with apache (both from sources)
> 
> script part: (test.php)
> 
> mssql_connect("hostip","username","password"); as usual :)
> mssql_select_db("dbname");
> $sql="select * from table";
> $res=mssql_query($sql);
> $row=mssql_fetch_row($res);
> echo $row[0];
> 

You should match up the functions you're using with the configuration
you specified at build time.  You're currently invoking mssql_xxx()
functions but you built with mysql and sybase support.  I would guess
that it will be more likely to work if you invoke the sybase_xxx()
functions.  NB: mysql and mssql are *not* the same thing. :->}

HTH.

Bob