[freetds] FreeTDS with MSSQL 2005 Issue [NC]

Cedric ROUVRAIS cedric.rouvrais at sgcib.com
Fri Jul 10 14:12:45 EDT 2009


No problem, the important part of life is to make things work.  :o)

So next is to get isql to work :o)

a++ Cedric




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




Yeah, thats how I figured out it the port was filtered :\  Unfortunately it
was after I posted to the list.

On Fri, Jul 10, 2009 at 2:00 PM, Cedric ROUVRAIS
<cedric.rouvrais at sgcib.com>wrote:

> second dumb question of the day, from the client machine where TDS is not
> connecting did you try a simple telnet to the server on the port?
>
> a++ Cedric
>
>
>
> |------------------------------
> |            "J. Bobby Lopez"
> |            <jbl at jbldata.com>
> |            Sent by:
> |            freetds-bounces at l
> |            ists.ibiblio.org
> |
> |
> |            07/10/2009 12:32
> |            PM
> |
> |
> |            Please respond to
> |                 FreeTDS
> |            Development Group
> |            <freetds at lists.ib
> |               iblio.org>
> |
> |
>
>
>                                                                        To
>                                               FreeTDS Development Group
>                                               <freetds at lists.ibiblio.org>
>                                                                        cc
>
>                                                                   Subject
>                                               Re: [freetds] FreeTDS with
>                                               MSSQL 2005 Issue [NC]
>
>
>
>
>
>
>
>
>
>
> I just confirmed with the DB admin that the database is indeed running on
> port 1433.  Also, I did a 'netstat -an' on the system that the RazorSQL
> client was running, and it's destination port was 1433.  There must be
> something else I'm missing.
>
>
> On Fri, Jul 10, 2009 at 12:09 PM, Cedric ROUVRAIS
> <cedric.rouvrais at sgcib.com
> > wrote:
>
> > Hi,
> >
> > I get this error when using the incorrect port for SQL Server.
> >
> > a++ Cedric
> >
> >
> > |------------------------------
> > |            "J. Bobby Lopez"
> > |            <jbl at jbldata.com>
> > |            Sent by:
> > |            freetds-bounces at l
> > |            ists.ibiblio.org
> > |
> > |
> > |            07/10/2009 12:05
> > |            PM
> > |
> > |
> > |            Please respond to
> > |                 FreeTDS
> > |            Development Group
> > |            <freetds at lists.ib
> > |               iblio.org>
> > |
> > |
> >
> >
> >
To
> >                                               FreeTDS Development Group
> >
> <freetds at lists.ibiblio.org>
> >
cc
> >
> >
Subject
> >                                               Re: [freetds] FreeTDS
with
> >                                                MSSQL 2005 Issue [NC]
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > I hadn't before (thanks for reminding me), but I got the same error:
> >
> > root at DEVTEST01:/usr/local/freetds/etc# tsql -S Reporting -U
> > "domain\\username"
> > locale is "en_CA.UTF-8"
> > locale charset is "UTF-8"
> > Password:
> > 189Msg 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
> >
> >
> > On Fri, Jul 10, 2009 at 11:58 AM, Cedric ROUVRAIS
> > <cedric.rouvrais at sgcib.com
> > > wrote:
> >
> > > 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.
> > >
> *************************************************************************
> > >
> > > _______________________________________________
> > > FreeTDS mailing list
> > > FreeTDS at lists.ibiblio.org
> > > http://lists.ibiblio.org/mailman/listinfo/freetds
> > >
> >
> >
> >
> > --
> > 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.
> >
*************************************************************************
> >
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS at lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> >
>
>
>
> --
> 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.
> *************************************************************************
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



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