Skip to Content.
Sympa Menu

freetds - Re: [freetds] Unable to connect to MS SQL 2000

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: edwardspl AT ita.org.mo
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Unable to connect to MS SQL 2000
  • Date: Thu, 25 Mar 2004 09:51:10 +0800

rconner AT commspeed.net wrote:

> Now I do get an error message �Couldn't connect to SQL Server on
> myserver�, so I know that it is carrying the Variable�and is attempting
> the $s = mssql_connect. Before I had FreeTDS installed it would not show
> anything, just a blank page.
>
> Also in my phpinfo() page I see �./configure'
> '--with-apxs2=/usr/local/apache2/bin/apxs' '--with-mysql'
> '--with-sybase=/usr/local/freetds/' , so that looks good.

1, The configure commands seem are ok !
2, which version of php are you using ?
http://www.php.net/manual/en/ref.mssql.php
--- cut --->
To enable mssql in php 4.3.3 and above on linux/unix boxes, you must put this
line in php.ini
extension=mssql.so
--- cut --->

> I edited the /usr/local/freetds/etc/freetds.conf as follows:
>
> # This is a Sybase hosted database server, if you are directly on the
> # net you can use it to test.
> [JDBC]
> host = 192.138.151.39
> port = 4444
> tds version = 5.0
>
> # The same server, using TDS 4.2. Used in configuration examples for the
> # pool server, since the pool server supports only TDS 4.2.
> [JDBC_42]
> host = 192.138.151.39
> port = 4444
> tds version = 4.2
>
> # The client connecting to the pool server will use this to find its
> # listening socket. This entry assumes that the client is on the same
> # system as the pool server.
> [mypool]
> host = 127.0.0.1
> port = 5000
> tds version = 4.2
>
> # A typical Microsoft SQL Server 7.0 configuration
> [MyServer70]
> host = myserver
> port = 1433
> tds version = 4.2
>
> # A typical Microsoft SQL Server 2000 configuration
> [MyServer2k]
> host = myserver
> port = 1433
> tds version = 4.2
>
> # A typical Microsoft SQL Server 6.x configuration
> ;[MyServer65]
> ; host = ntmachine.domain.com
> ; port = 1433
> ; tds version = 4.2

Which name of the computer machine do you want to connect ?
About the tds version, please visit
http://www.freetds.org/userguide/choosingtdsprotocol.htm for more detail...

Edward.






Archive powered by MHonArc 2.6.24.

Top of Page