[freetds] mssql_connect : Unable to connect to server

Pedro Barbosa pbarbosa at inescporto.pt
Fri Nov 4 11:18:12 EST 2005


Hi!
I dont know exactly what was hapening but i changed to permissive 
SELinux reboot the system and everything started to work fine.
Thanks anyway!

By the way dows anyone knows how to solve the problem of encoding. when 
i do a select in a table i get the tipical portuguese caracters like a 
square.
how can i solve this?

thanks
Pedro Barbosa




Pickett, David wrote:

>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
>_______________________________________________
>FreeTDS mailing list
>FreeTDS at lists.ibiblio.org
>http://lists.ibiblio.org/mailman/listinfo/freetds
>
>  
>



More information about the FreeTDS mailing list