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: Pedro Barbosa <pbarbosa AT inescporto.pt>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] mssql_connect : Unable to connect to server
  • Date: Fri, 04 Nov 2005 16:18:12 +0000

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







Archive powered by MHonArc 2.6.24.

Top of Page