Re: Sybase/MSSQL

Richard Lynch wrote: > But attempting to connect to a remote MS SQLserver (in either isql or PHP) > yields: > > CT-LIBRARY error: > ct_connect(): network packet layer: internal net library error: > Net-Library operation terminated due to disconnect Grrrr. The dba had *NOT* installed service pack 2, as earlier reported... So *this* is taken care of... Alas, I'm now able to isql, but get a segfault from Apache: http://bugs.php.net/?id=14074 The *WEIRD* thing is that I now cannot even use PHP to talk to the ASE server, which I *DID* have working yesterday. Sigh. This all remains unanswered: > Trying FreeTDS, I get an error from make about not finding -lsybtcl. I > can "fix" that by editing the Makefile by hand and adding /opt/sybase to > the library path, since that's the only place I can find any libsybtcl.so > file on the entire system, but that just makes Apache segfault... And > isql is not at all happy about trying to use the FreeTDS directory for its > SYBASE setting... Some error message about a missing directory... Sorry, > I got so frustrated at this point with FreeTDS, since Sybase at least let > me talk to ASE that I gave up on FreeTDS. > > Is FreeTDS supposed to make its own libsybtcl or what? > > I used the FreeTDS configure line from the PHPBuilder article: > /configure --with-tdsver=4.2 --enable-msdblib --enable-dbmfix > --with-gnu-ld --enable-shared --enable-static > http://phpbuilder.com/columns/alberto20000919.php3?page=3 > > I did not apply the patch because (A) I couldn't find it, and (B) it was > for 4.0.2, so I was hoping 4.0.6 would already have had it applied... But > I followed all the other instructions in the article, almost for sure. > I'm not 100% certain it's SQL 7.0 Service Pack 2 -- The MS dba just left. > They reassured me very early in this process that they were running the > latest and greatest MS SQL Server, though. > > Please help -- I'm at my wit's end to make PHP talk to SQL Server. This > should not be this tricky. -- Like music? http://l-i-e.com/artists.htm