Re: Ms sql backslash in named instance 2005 [NC]

Hi,

MS SQL server offers to routes:

1/ Hostname\instancename
2/ Hostname, port

Go down route 2 and ye shall have no issues.

a++ Cedric



|------------------------------                                            
|            <[email protected]                                             
|            o.uk>                                                         
|            Sent by:                                                      
|            freetds-bounces@l                                             
|            ists.ibiblio.org                                              
|                                                                          
|                                                                          
|            10/23/2009 12:46                                              
|            PM                                                            
|                                                                          
|                                                                          
|            Please respond to                                             
|                 FreeTDS                                                  
|            Development Group                                             
|            <[email protected]                                             
|               iblio.org>                                                 
|                                                                          
|                                                                          
                                                                           
                                                                           
                                                                        To 
                                               [email protected]   
                                                                        cc 
                                                                           
                                                                   Subject 
                                               [freetds] Ms sql backslash  
                                               in named instance 2005      
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           




Hi,
using freetds version 0.82 on solaris 10. tsql fails to connect to sql
server named instances as they contain backslashes. Ie.
tsql -S'hostname\instancename' -U joe -P bloggs
A work around is to remove the backslash in freetds.conf. However, this
worked fine in freetds 0.62.4.

The only error is
'There was a problem connecting to the server'.

Its quite important that we maintain the exisiting functionality.

Has anyone else seen this and is there a solution that would avoid using an
unstable version?



_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds



*************************************************************************
This message and any attachments (the "message") are confidential, intended 
solely for the addressee(s), and may contain legally privileged information.  
Any unauthorised use or dissemination is prohibited.  E-mails are susceptible 
to alteration.  Neither SOCIETE GENERALE nor any of its subsidiaries or 
affiliates shall be liable for the message if altered, changed or falsified.
*************************************************************************