changing port (again)

Jan Simek jsimek at i-network.com
Wed Sep 19 14:30:18 EDT 2001


Hi all,

> >no, everything from the internal network. Telnet to 1433 / 7433 works
> >fine... i.e.: 1433 yes before change (and no 7433), and 1433 no after
> >change (and 7433 yes).
> >
> >Anything else I should check for? I do not want to recompile everything
> >(FreeTDS and PHP just for this...).
> >
> >??
> 
> Not quite sure how you do it for PHP, but did you specify the new port 
> number? It defaults to 1433...
> for the JDBC you should be using this for the connection string : 
> jdbc:freetds:sqlserver://servername:port/database

I'm using PHP:

mssql_connect ("serverx","usersql","passwd") or die ("No... sorry\n")



serverx is defined in /etc/hosts (responds to pings, and telnet to 7433)

in interfaces I have:

serverx
        query tcp tds4.2 smalldog 7433


Again, telnet to 7433 works fine...

If I change it back (in the interface file to 1433 and change the port on
the NT machine (MS SQL) back to 1433), it works just fine...

So the PHP function mssql_connect doesn't know that I want it to connect
to port 7433 instead of the deafult 1433... 

Any other ideas?


Thanks,

--Jan







More information about the FreeTDS mailing list