Using Sybase to access SQL2000?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • William Holroyd
    #1

    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


    Tags: None
    • CJ Llewellyn
      #2
      Re: Using Sybase to access SQL2000?

      "William Holroyd" <w.holroyd@vers ity-cobalt.com> wrote in message
      news:ccmr31$j7v $1@cnn.cns.ksu. edu...[color=blue]
      > 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[/color]
      another[color=blue]
      > 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[/color]
      MS[color=blue]
      > 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.[/color]

      Yeah, how to use google :)
      [color=blue]
      > Are there any things I should
      > know about by using the sybase method to connect to SQL 2k? Do you guys[/color]
      know[color=blue]
      > of any links that Google doesn't for setting up MS SQL via PHP?[/color]

      404 Not Found
      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.



        Comment

        Previous template Next
        Working...