Need solution for PHP 4/Linux/SQL Server

Anon

I have been using PHP 3/SQL Server with FreeTDS - dblib for over a year with great success!!!

I am trying to upgrade to PHP 4 and have run into some problems. I need a way to access
my database, I have tried:

FreeTDS dblib, Problem: Unstable crashes every 20 or so queries.

FreeTDS ctlib, Problem: Does not support varchar fields over 255.

What should I try next?

Thanks
Ben

neuromancer

Why don't you use the sybase driver?

Anon

I should have mentioned my database is MS SQL 2000.

I downloaded the ASE common and openclient installed them. Tested... Apache Seg faults when I try to connect to the database.

So I tried on one of our old MS SQL 6.5 servers and it works fine.

I looked around, it appears I need to install a patch to make the sybase-ct use TDS 4.2 instead of the default 5.0? I downloaded the patch for 4.0.2 and applied it by hand to my 4.0.5 release. I am still getting the Seg. fault in Apache when I try to connect with PHP.

What should I try now?

Thanks
Ben

neuromancer

You should consider using Merants ODBC driver.

www.merant.com

Thats what I use on ALL my Linux systems connecting to SQL Server 2000.

Anon

If I read the website correctly it is about $4K per CPU. We have a number of dual processor boxes = WAY to much $$$.

PHP 3 works. There is a lot of new stuff in PHP 4 I would like to use, but I need a reasonable solution.

Thanks
Ben