Re: FreeTDS with MSSQL 2005 Issue [NC]
Cedric ROUVRAIS <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <OF168CA2DF.F1735165-ON852575EF.0062CF77-852575EF.0062E424@us.world.socgen> |
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" | <[email protected]> | Sent by: | freetds-bounces@l | ists.ibiblio.org | | | 07/10/2009 12:32 | PM | | | Please respond to | FreeTDS | Development Group | <[email protected] | iblio.org> | | To FreeTDS Development Group <[email protected]> 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 <[email protected] > wrote: > Hi, > > I get this error when using the incorrect port for SQL Server. > > a++ Cedric > > > |------------------------------ > | "J. Bobby Lopez" > | <[email protected]> > | Sent by: > | freetds-bounces@l > | ists.ibiblio.org > | > | > | 07/10/2009 12:05 > | PM > | > | > | Please respond to > | FreeTDS > | Development Group > | <[email protected] > | iblio.org> > | > | > > > To > FreeTDS Development Group > <[email protected]> > 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 > <[email protected] > > wrote: > > > dumb question. > > > > We agree that you wrote domain\\user in order to escape the \ ? > > > > a++ Cedric > > > > > > > > |------------------------------ > > | "J. Bobby Lopez" > > | <[email protected]> > > | Sent by: > > | freetds-bounces@l > > | ists.ibiblio.org > > | > > | > > | 07/10/2009 11:55 > > | AM > > | > > | > > | Please respond to > > | FreeTDS > > | Development Group > > | <[email protected] > > | iblio.org> > > | > > | > > > > > > To > > [email protected] > > 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 <[email protected]> > 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 > > [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. > > ************************************************************************* > > > > _______________________________________________ > > FreeTDS mailing list > > [email protected] > > http://lists.ibiblio.org/mailman/listinfo/freetds > > > > > > -- > J. Bobby Lopez > Web: http://jbldata.com/ > Twitter: http://www.twitter.com/jbobbylopez > _______________________________________________ > 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. > ************************************************************************* > > _______________________________________________ > FreeTDS mailing list > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds > -- J. Bobby Lopez Web: http://jbldata.com/ Twitter: http://www.twitter.com/jbobbylopez _______________________________________________ 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. *************************************************************************