FreeTDS Development Group

["sina" <lvjin AT yeah.net>]

I met same problem several weeks ago, I can't solve it. I have to use sybase 
ct-lib to connect to MS SQLserver, and it works except the datatime type(so 
have to change to varchar type). 
I wanna know what's wrong with freetds also. It lloks strange for Integer 
type. I have debuged it, the program can't get the value in Integer from the 
result set, it returns NULL point, which cause core dumped.

And I tried freetds with PHP4rc1, but can't build it. and I follow the 
suggestions in the list to modify the login.c, not work yet. How can I do 
with freetds.

lvjin



----- Original Message ----- 
From: "J. Hatch" <zone AT your-site.com>
To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
Sent: Thursday, April 20, 2000 11:48 PM
Subject: [freetds] PHP 3.0.15 Problems: Works, sort of.


> 
> Boy, you guys love to keep us guessing! I spent all night (all night)
> getting PHP to compile with FreeTDS. I had to put the pieces together from
> the mailing list, take a guess, and basically _not_ do what the web site
> says. I'm even guessing at what address to send this message to as my
> confirmation message didn't say where to post.
> 
> Ok, enough griping :-).
> 
> I'm using .50 on Solaris 7 with PHP 3.0.15. I've compiled my FreeTDS as
> follows:
> 
> ./configure --with-tdsver=4.2 --enable-msdblib --enable-dbmfix
> 
> None of the tests worked, every one failed. I had to edit the Makefile in
> each of the src/*/unittests directory to add -lnls and -lresolv becuase
> configure didn't do it. Then I got segfaults for each test. I had the PWD
> in my top level build directory along with an "interface" file but I had
> to make my interface file /.interface because for some reason the script
> wasn't opening $SYBASE/interfaces. Finally, I got all but one test to
> pass. 
> 
> For PHP, I _had_ to use --with-sybase-ct=/usr/local/freetds and I _had_ to
> edit functions/sybase.c to rename the dbopen() calls to tdsdbopen(). I
> also had to add -R/usr/local/freetds/lib to the LIBS line of the PHP
> Makefile because I don't like cludging up LD_LIBRARY_PATH's and php
> wouldn't run without it. Another key point (thanks to this list) was to
> remove the -lcs -lcomn -lsybtcl from the MULTIPLE places it appeared in
> the PHP Makefile. Finally after trying a gazillion combinations,
> the one above worked. 
> 
> Now for my problem. I can connect to mssql via PHP3. I can retrieve large
> amounts of data (say 5cols x 575rows). However, I _cannot_ receive integer
> data. I have one column that's an integer, and it always crashes PHP and
> drops core. I've tried running it on the commandline setting TDSDUMP and
> the log file is empty every time.
> 
> Does anyone know what might fix this? Also, I've seen lots of messages in
> this list saying that upgrading to the latest snapshot fixes a lot of
> these problems, however it will NOT compile on Solaris. I get an error on
> login.c about FIONBIO (and so have many others on the list). I hear a
> mention from Brian about a patch for this, but I cannot find it. Does
> anyone know how to get the latest snapshot to compile on Solaris?
> 
> Thanks,
> 
> -Jason (tired and weary)
> 
> 
> ----------------------------------------------------------
> Jason Hatch, Owner and Network Administrator
> Your Site Virtual Server Solutions 
> (413) 499-6690 (voice) (413) 499-4504 (fax)
> Visit our Web Site at http://www.your-site.com
> We offer quality Web Hosting for as low as $5/mo!
> ----------------------------------------------------------
> 
> 
> ---
> You are currently subscribed to freetds as: [udoo AT sina.com]
> To unsubscribe, forward this message to 
> leave-freetds-102790N AT franklin.oit.unc.edu
> 
>