By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,614 Members | 1,674 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,614 IT Pros & Developers. It's quick & easy.

Using Sybase to access SQL2000?

P: n/a
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
updated.

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.

-William
Jul 17 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"William Holroyd" <w.*******@versity-cobalt.com> wrote in message
news:cc**********@cnn.cns.ksu.edu...
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
updated.

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.
Yeah, how to use google :)
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?


http://www.php.net/manual/en/ref.mssql.php

Refers to http://www.freetds.org/

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
connections.

Then rebuild php to use freetds library for ms sql.

Jul 17 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.