FreeTDS Development Group

[Brian Bruns <camber AT umcc.ais.org>]

I downloaded the latest php and will try it; I was wanting to get the
ctlib stuff working anyway...I'll let you know tonight if I find anything
(tonight meaning EST/GMT+5 timezone that is)

In the meantime, are you using the copy from CVS or the 0.41 version? 

Brian

On Sat, 29 May 1999, Christophe VG wrote:

> Brian Bruns wrote:
> > Hmmm...Are they char/varchar fields or actually 'text' datatypes? Text
> > datatypes have a whole set of dedicated functions to access.  If they
> > are char or varchar please send me the table layout and I'll see what
> > I can do.
> > Brian
> 
> Well, I've tried the following tables :
> 
> test1
> =====
> name  type     size
> -------------------
> id    int      4
> name  varchar  255
> nick  varchar  255
> text  varchar  255
> 
> test2
> =====
> name  text     16
> fname text     16
> id    int      4
> 
> test3
> =====
> id    int      4
> name  char     255
> 
> with the following php code :
> 
> (there is some comment and a question inside :) )
> 
> <?
> 
> $cnn = sybase_connect("newton", "test", "test");
> /*
> **  When putting this on screen, it returns 1
> */
> if ($cnn == 0){
>   echo "Unable to connect to newton.<BR>\n";
>   exit;
> 
> $lnk = sybase_select_db("test", $cnn);
> /*
> **  When putting this on screen, it also returns 1
> */
> if ($lnk == 0){
>   echo "Unable to select db.<BR>\n";
>   exit;
> 
> /*
> ** Up to here everything seems to be allright.
> ** When the following command is called, I just can wait forever
> ** I noticed one strange thing, if I eg use the sql-statement :
> ** "select * from dummy",  referring to a table that does not
> ** exist, I get no error message. 
> ** Is this normal ?
> */
> 
> $resultset = sybase_query("select * from test3", $lnk);        
> if($resultset == 0){
>   echo "No resultset returned.<br>\n";
>   exit;
> 
> 
> $results = sybase_fetch_row($resultset);
> 
> for($i=0;$i<count(results);$i++)
>       echo $results[$i],' ';
> 
> sybase_close($cnn);
> 
> 
> ?>
> 
> I really think there must be some other problem, something like
> misconfiguration. I've downloaded the sybase server suite, and will be
> checking that one, some people mailed me to say it worked fine with
> them, using the same setup. Though I still hope to use freeTDS, since
> it's a lot lighter (and the problem got me intrigued).
> 
> Anyhow, thanks a lot for all the effort you're putting into this.
> 
> greetz,
> Christophe VG
>