Skip to Content.
Sympa Menu

freetds - Re: [freetds] mssql_connect : Unable to connect to server

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Pickett, David" <David.Pickett AT phlx.com>
  • To: 'FreeTDS Development Group' <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] mssql_connect : Unable to connect to server
  • Date: Fri, 4 Nov 2005 10:47:50 -0500

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




Archive powered by MHonArc 2.6.24.

Top of Page