[freetds] FreeTDS with MSSQL 2005 Issue [NC]

Cedric ROUVRAIS cedric.rouvrais at sgcib.com
Fri Jul 10 11:58:19 EDT 2009


dumb question.

We agree that you wrote domain\\user in order to escape the \ ?

a++ Cedric



|------------------------------                                            
|            "J. Bobby Lopez"                                              
|            <jbl at jbldata.com>                                             
|            Sent by:                                                      
|            freetds-bounces at l                                             
|            ists.ibiblio.org                                              
|                                                                          
|                                                                          
|            07/10/2009 11:55                                              
|            AM                                                            
|                                                                          
|                                                                          
|            Please respond to                                             
|                 FreeTDS                                                  
|            Development Group                                             
|            <freetds at lists.ib                                             
|               iblio.org>                                                 
|                                                                          
|                                                                          
                                                                           
                                                                           
                                                                        To 
                                               freetds at lists.ibiblio.org   
                                                                        cc 
                                                                           
                                                                   Subject 
                                               Re: [freetds] FreeTDS with  
                                               MSSQL 2005 Issue            
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           




Also, I tried connecting without the configuration file in this way:

TDSVER=7.0 tsql -H P reporting.domain.com -p 1433 -U "domain\username"

Which is why I got the "Server name not found in configuration files" error
below.  But still nothing.



On Fri, Jul 10, 2009 at 11:47 AM, J. Bobby Lopez <jbl at jbldata.com> wrote:

> Hello All,
>
> I'm trying to get FreeTDS working against an MS SQL 2005 (v.9.00.4035.00,
> Enterprise Edition, SP3).
>
> I've compiled freetds in the following way:
>
> ./configure --prefix=/usr/local/freetds
> make
> make install
>
> My '/usr/local/freetds/etc/freetds.conf' includes the following entry
>
> # A typical Microsoft server
> [Reporting]
>         host = 1.2.3.4
>         port = 1433
>         tds version = 7.0
>
> I use the tsql command as follows:
>
> tsql -S Reporting -U "domain\username"
>
> I use the domain because the database requires "windows authentication".
> It seems like it is about to connect.  I get prompted for a password, and
> then I get the counter seconds climbing (0,1,2,3...)
>
> Eventually it does and throws this error:
>
> Msg 20012, Level 2, State -1, Server OpenClient, Line -1
> Server name not found in configuration files.
> 188Msg 20009, Level 9, State -1, Server OpenClient, Line -1
> Unable to connect: Adaptive Server is unavailable or does not exist
> There was a problem connecting to the server
>
>
> After several attempts I figured that there just must be something
> incompatible with freetds and this particular server.  But then I went
and
> tried to connect to the database with my linux-based database query
program
> (RazorSQL), and it connects just fine with JDBC:JTDS.
>
> So what am I doing wrong with FreeTDS?
>
> Thanks in advance.
>
> Bobby
>
>
> --
> J. Bobby Lopez
> Web: http://jbldata.com/
> Twitter: http://www.twitter.com/jbobbylopez
>
>


--
J. Bobby Lopez
Web: http://jbldata.com/
Twitter: http://www.twitter.com/jbobbylopez
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
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.
*************************************************************************



More information about the FreeTDS mailing list