FreeTDS Development Group

[Pedro Barbosa <pbarbosa AT inescporto.pt>]

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
>
>