Re: FreeTDS with MSSQL 2005 Issue [NC]
"J. Bobby Lopez" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
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 <[email protected]> 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 < > [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 > > -- J. Bobby Lopez Web: http://jbldata.com/ Twitter: http://www.twitter.com/jbobbylopez