Using Sybase to access SQL2000?

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
I recently took over a web project that utilizes a MS SQL2000 server via
PHP. The web server itself is screwed and so I'm trying to configure another
box to act as a temporary server until i can get the current one fixed and

I looked at the phpinfo() output on the current webserver and saw the
previous guy had configured php with "--with-sybase=/usr/local/freetds". I
have no clue as to why this was done and can't for the life of me get the MS
SQL functions to work in PHP on the new server. I've used
"--with-mssql=[directory]" (with the appropriate directory of course) when
compiling PHP and "--enable-msdblib" with FreeTDS, but it still doesn't
work. I've tried everything Google results have to offer.

I guess he knew something I have yet to learn. Are there any things I should
know about by using the sybase method to connect to SQL 2k? Do you guys know
of any links that Google doesn't for setting up MS SQL via PHP?

Any help is much appreciated.


Re: Using Sybase to access SQL2000?

Quoted text here. Click to load it

Yeah, how to use google :)

Quoted text here. Click to load it

Refers to /

Download and build the freetds software, and test it by connecting to the MS
SQL Server. You should also check that the SQL Server will allow TCP/IP

Then rebuild php to use freetds library for ms sql.

Site Timeline