Skip to Content.
Sympa Menu

freetds - Re: [freetds] FreeTDS with MSSQL 2005 Issue [NC]

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "J. Bobby Lopez" <jbl AT jbldata.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] FreeTDS with MSSQL 2005 Issue [NC]
  • Date: Fri, 10 Jul 2009 13:47:38 -0400

Thanks for your help Cedric.

It looks like it was a port issue after all, but not that I had the
incorrect port - it seems the port was being filtered from the network I was
on.

I tried this out on another host which didn't suffer from the same problem,
and it worked.

Thanks again.

Bobby

On Fri, Jul 10, 2009 at 12:32 PM, J. Bobby Lopez <jbl AT jbldata.com> wrote:

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


--
J. Bobby Lopez
Web: http://jbldata.com/
Twitter: http://www.twitter.com/jbobbylopez




Archive powered by MHonArc 2.6.24.

Top of Page