FreeTDS Development Group

["Pickett, David" <David.Pickett AT phlx.com>]

Pedro,

Just offhand, I'd expect "xx.xx.x.xx:1443", so I wonder if your SQL Server
host name plus port is too long for some buffer.  Did you configure it with
an IP?  If no, you might try that, just to see.

Best regards,

David

PS: Is there any move to add freeTDS support of dynamic port (which gives
auto port detection) and connection by instance name?  I saw the dialog on
truss with other SQL Server products, and it is a simple UDP packet exchange
with port 1434 on the server.

5221/1:         open(0xFE688748, 0)                             = 5
5221/1:              0xFE688748: "/dev/udp"
5221/1:         ioctl(5, 0xC00C6982, 0xFFBED31C)                = 0
5221/1:         close(5)                                        = 0
5221/1:         door(3, 0xFFBEB2A0)                             = 0
5221/1:         door(3, 0xFFBEB288)                             = 0
5221/1:         sendto(4, 0xFFBEDD70, 1, 0, 0xFFBEE170, 16)     = 1
5221/1:              0xFFBEDD70: "03"
5221/1:                 AF_INET  to = 10.112.2.128  port = 1434
5221/1:         poll(0xFFBED428, 1, 1000)                       = 1
5221/1:                 fd=4  ev=POLLRDNORM rev=POLLRDNORM
5221/1:         read(4, 0xFFBEDD70, 1024)                       = 121
5221/1:           05 v\0 S e r v e r N a m e ; P H L X S Q L 0 3 ; I n s t a
n c e
5221/1:            N a m e ; M S S Q L S E R V E R ; I s C l u s t e r e d ;
N o ;
5221/1:            V e r s i o n ; 8 . 0 0 . 1 9 4 ; t c p ; 1 4 3 3 ; n p ;
\ \ P
5221/1:            H L X S Q L 0 3 \ p i p e \ s q l \ q u e r y ; ;
5221/1:         close(4)                                        = 0

Maybe it is in there, and I did not read enough on how to turn it on!  I see
that with no port, my ODBC setup with no port defaults to 4000 not 1433 nor
the default value 5000 listed here:

http://www.freetds.org/userguide/freetdsconf.htm

Maybe that is an ODBC glitch?  Well, I wonder if the MS 1434 dynamic port
thing is even within the TDS spec. realm.  Regardless, freeTDS should not be
left behind.

-----Original Message-----
From: Pedro Barbosa [mailto:pbarbosa AT inescporto.pt]
Sent: Friday, November 04, 2005 10:06 AM
To: FreeTDS Development Group
Subject: Re: [freetds] mssql_connect : Unable to connect to server


I was just looking to the logs and i found out that appens an error 
declared in apache log:

src/tds/*login**.**c*: *tds_connect*: xx.xx.x.xx:144

I saw some threads when searching it at google, but sadly none add the 
anwser

if this helped and someone knows i can i solve this i would be apreciated.

thanks
Pedro Barbosa



Pedro Barbosa wrote:

>Hi!
>
>I've installed freetds and ran ./tsql -S server  -U user -P pass and 
>everything works fine. i can usedatabase's and do select on every table.
>
>But when it comes to using the function mssql_connect on php it gives me 
>the following error:
>    *Warning*: mssql_connect() [function.mssql-connect]: Unable to 
>connect to server: server  in */var/www/html/bd.php* on line *9
>
>*I 've followed all instructions , compiled php with the option 
>--with-mssql=/usr/local/freetds.
>
>Is there anytinhg to be changed in php.ini? or is something else?
>
>thanks
>Pedro Barbosa
>*
>*
>_______________________________________________
>FreeTDS mailing list
>FreeTDS AT lists.ibiblio.org
>http://lists.ibiblio.org/mailman/listinfo/freetds
>
>  
>

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds