468,758 Members | 2,050 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,758 developers. It's quick & easy.

Using Sybase to access SQL2000?

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
1 1448
"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.

Similar topics

1 post views Thread by Wellingotn Rampazo | last post: by
38 posts views Thread by Remco Groot Beumer | last post: by
2 posts views Thread by Remco Groot Beumer | last post: by
reply views Thread by Metal2You | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.