FreeTDS Development Group

[edwardspl AT ita.org.mo]

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.