Re: Regarding MSSQL connection
"Gopalakrishnan A.N" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
Hi Robert, Thru this command I can able to see the 1> prompt, [root@localhost ~]# tsql -S egServer70 -U cims locale is "C" locale charset is "ANSI_X3.4-1968" Password: 1> help; 2> ? 3> 4> 5> 6> 7> 8> 9> use database cims; 10> select * from DLR_DIAL_DTC; 11> select * from DLR_DIAL_DTC 12> 13> 14> QUIT [root@localhost ~]# TDSVER=7.0 tsql -H 172.20.182.10 -p 1433 -U cims locale is "C" locale charset is "ANSI_X3.4-1968" Password: 1> use database cims; 2> select * from DLR_DIAL_DTC; 3> 4> quit Is it correct? but I cant able to see any ouput of this command. On Thu, Feb 26, 2009 at 1:21 PM, Gopalakrishnan A.N <[email protected]>wrote: > Hi Robert, > For me the output of the command tsql -C and I have commented in bold, > please assist me to go ahead.... Thanks in advance. > > [root@localhost ~]# tsql -C > Compile-time settings (established with the "configure" script) > Version: freetds v0.82 > freetds.conf directory: /usr/local/etc > MS db-lib source compatibility: no // here do i need this to yes to > communicate with SQL server? > Sybase binary compatibility: no > Thread safety: yes > iconv library: yes > TDS version: 5.0 //here I am using v0.82 which is > version 8 rite? > iODBC: no > unixodbc: yes //unixodbc is yes, is this > creates problem? > > > On Thu, Feb 26, 2009 at 12:56 PM, Robert Gonzalez < > [email protected]> wrote: > >> Try looking for .lib (notice the dot in front). That might be it. >> >> For the record, I don't use UnixODBC. It is only freetds >> >> >> On Thu, Feb 26, 2009 at 12:24 AM, Gopalakrishnan A.N <[email protected] >> >wrote: >> >> > Hi Robert, >> > I am using Cent OS 5.2. I gone thru the link you have provided, I found >> a >> > entry /usr/local/freetds/lib what I have downloaded is freetds stable >> > release, inside that I cant able to find any lib folder. The older >> version >> > also I cant able to find any one. Where to get the lib folder. And also >> > please let me know while installing freetds we need to enable the >> msdblib. >> > >> > On Thu, Feb 26, 2009 at 12:47 PM, Gopalakrishnan A.N <[email protected] >> > >wrote: >> > >> > > Hi Robert, >> > > Actually what is the difference between UnixODBC and FreeTDS. My >> > concern >> > > is I need to connect my linux machine with SQL server 2000. So I need >> to >> > use >> > > UnixODBC or FreeTDS? Please suggest me. >> > > >> > > >> > > On Thu, Feb 26, 2009 at 12:26 PM, Robert Gonzalez < >> > > [email protected]> wrote: >> > > >> > >> I don;t think I am using UnixODBC. I am using FreeTDS 0.82 and SQL >> > Server >> > >> 2003. >> > >> >> > >> On Wed, Feb 25, 2009 at 11:52 PM, Gopalakrishnan A.N < >> [email protected] >> > >> >wrote: >> > >> >> > >> > Hi Robert, >> > >> > Can you please let me know what version of UnixODBC, FreeTDS and >> SQL >> > >> > server you are using. I am using UnixODBC 2.2.12 ,FreeTDS 0.82 and >> SQL >> > >> > server 2000 enterprise edition. >> > >> > >> > >> > On Thu, Feb 26, 2009 at 12:06 PM, Robert Gonzalez < >> > >> > [email protected]> wrote: >> > >> > >> > >> > > Sorry, I should have said this before... what is the path to your >> > >> > > freetds.conf? On Fedora/RedHat linux it is usually >> /etc/freetds.conf >> > >> and >> > >> > on >> > >> > > Ubuntu/Debian it is /etc/freetds/freetds.conf >> > >> > > >> > >> > > Of course these paths could be based on FreeTDS versions, but I >> just >> > >> know >> > >> > > what I went through recently. I got the exact same error you got >> and >> > >> > fixed >> > >> > > it by exporting FREETDSCONF equal to the path to the FreeTDS conf >> > >> file. >> > >> > > >> > >> > > Also make sure your freetds conf file is set up properly. No >> matter >> > >> how >> > >> > > hard >> > >> > > I tried to connect by host name and port i was never able to do >> that >> > >> on >> > >> > > both >> > >> > > Fedora and Ubuntu. It was only after I made an entry in the >> > >> freetds.conf >> > >> > > and >> > >> > > tried to connect with the servername alias that it would connect. >> > >> > > >> > >> > > Here are a few links for what I have done to make it work on both >> > >> Ubuntu >> > >> > > and >> > >> > > Fedora: >> > >> > > >> > >> > > >> > >> > >> > >> >> > >> http://www.robert-gonzalez.com/2009/02/18/building-the-php-ms-sql-server-extension-from-source-on-ubuntu-810/ >> > >> > > >> > >> > > >> > >> > >> > >> >> > >> http://www.robert-gonzalez.com/2008/03/31/connecting-php-on-linux-to-mssql-on-windows/ >> > >> > > >> > >> > > Both of those are specifically geared toward getting PHP to talk >> to >> > >> SQL >> > >> > > Server using its own extension. However in order to do that you >> have >> > >> to >> > >> > be >> > >> > > able to use tsql at the command line. In both cases I was able to >> > get >> > >> > tsql >> > >> > > to connect. >> > >> > > >> > >> > > HTH, this is not really a strong suit of mine but I know it is >> very >> > >> > > frustrating when it doesn't work like you expect it to. ;) >> > >> > > >> > >> > > On Wed, Feb 25, 2009 at 11:26 PM, Gopalakrishnan A.N < >> > >> [email protected] >> > >> > > >wrote: >> > >> > > >> > >> > > > Hi Robert, >> > >> > > > Thanks for your suggestion. I tried like this to set the >> > >> environment >> > >> > > > variable export >> > >> FREETDSCONF=/usr/local/freetds-0.82/freetds.conf:$PATH >> > >> > > > >> > >> > > > and tried to connect with tsql >> > >> > > > [root@localhost freetds-0.82]# tsql -H 172.20.182.10 -p 1433 >> -U >> > >> cims >> > >> > -P >> > >> > > > $ql$wtcintra08 -D cims >> > >> > > > locale is "C" >> > >> > > > locale charset is "ANSI_X3.4-1968" >> > >> > > > Msg 20017, Level 9, State -1, Server OpenClient, Line -1 >> > >> > > > Unexpected EOF from the server >> > >> > > > Msg 20002, Level 9, State -1, Server OpenClient, Line -1 >> > >> > > > Adaptive Server connection failed >> > >> > > > There was a problem connecting to the server >> > >> > > > [root@localhost freetds-0.82]# >> > >> > > > >> > >> > > > I faced the adaptive server connection. How to go ahead from >> this >> > >> > stage? >> > >> > > > please assist me. thanks in advance >> > >> > > > >> > >> > > > On Thu, Feb 26, 2009 at 11:30 AM, Robert Gonzalez < >> > >> > > > [email protected]> wrote: >> > >> > > > >> > >> > > > > Do you have the FREETDSCONF environment variable set? I ran >> into >> > >> this >> > >> > a >> > >> > > > few >> > >> > > > > weeks ago and after adding a >> > FREETDSCONF=/etc/freetds/freetds.conf >> > >> > > > variable >> > >> > > > > it began to work. >> > >> > > > > >> > >> > > > > On Wed, Feb 25, 2009 at 10:53 PM, Gopalakrishnan A.N < >> > >> > [email protected] >> > >> > > > > >wrote: >> > >> > > > > >> > >> > > > > > Hi James, >> > >> > > > > > Again I am getting like this error when I try to use >> > >> > > > > > >> > >> > > > > > [root@localhost ~]# tsql -S 172.20.182.10 -p 1433 -U cims >> -P >> > >> > > > > > $ql$wtcintra08 >> > >> > > > > > -D cims >> > >> > > > > > locale is "C" >> > >> > > > > > locale charset is "ANSI_X3.4-1968" >> > >> > > > > > Msg 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 >> > >> > > > > > [root@localhost ~]# >> > >> > > > > > >> > >> > > > > > what could be the reason? I have changed the servername >> too. >> > >> > > > > > >> > >> > > > > > On Mon, Feb 23, 2009 at 6:27 PM, James K. Lowden < >> > >> > > [email protected] >> > >> > > > > > >wrote: >> > >> > > > > > >> > >> > > > > > > Gopalakrishnan A.N wrote: >> > >> > > > > > > > I am trying to connect MS SQL server, but it gets fails >> > with >> > >> > SQL >> > >> > > > > > connect >> > >> > > > > > > > error. ... I am attaching my >> > >> > > > > > > > freetds.conf, odbc.ini and odbcinst.ini >> > >> > > > > > > >> > >> > > > > > > > Servername = 172.20.182.10 >> > >> > > > > > > >> > >> > > > > > > should be >> > >> > > > > > > >> > >> > > > > > > Servername = egServer70 >> > >> > > > > > > >> > >> > > > > > > The ODBC Servername connection property refers to a name >> in >> > >> > > > > freetds.conf. >> > >> > > > > > > >> > >> > > > > > > >> > >> > > > > > > (The osql script is intended to report mistakes like >> this.) >> > >> > > > > > > >> > >> > > > > > > HTH. >> > >> > > > > > > >> > >> > > > > > > --jkl >> > >> > > > > > > >> > >> > > > > > > _______________________________________________ >> > >> > > > > > > FreeTDS mailing list >> > >> > > > > > > [email protected] >> > >> > > > > > > http://lists.ibiblio.org/mailman/listinfo/freetds >> > >> > > > > > > >> > >> > > > > > >> > >> > > > > > >> > >> > > > > > >> > >> > > > > > -- >> > >> > > > > > Thank you with regards, >> > >> > > > > > Gopal, >> > >> > > > > > PeopleTech Systems Private Limited >> > >> > > > > > www.peopletech.co.in >> > >> > > > > > _______________________________________________ >> > >> > > > > > FreeTDS mailing list >> > >> > > > > > [email protected] >> > >> > > > > > http://lists.ibiblio.org/mailman/listinfo/freetds >> > >> > > > > > >> > >> > > > > >> > >> > > > > >> > >> > > > > >> > >> > > > > -- >> > >> > > > > >> > >> > > > > Robert Gonzalez >> > >> > > > > http://www.robert-gonzalez.com >> > >> > > > > _______________________________________________ >> > >> > > > > FreeTDS mailing list >> > >> > > > > [email protected] >> > >> > > > > http://lists.ibiblio.org/mailman/listinfo/freetds >> > >> > > > > >> > >> > > > >> > >> > > > >> > >> > > > >> > >> > > > -- >> > >> > > > Thank you with regards, >> > >> > > > Gopal, >> > >> > > > PeopleTech Systems Private Limited >> > >> > > > www.peopletech.co.in >> > >> > > > _______________________________________________ >> > >> > > > FreeTDS mailing list >> > >> > > > [email protected] >> > >> > > > http://lists.ibiblio.org/mailman/listinfo/freetds >> > >> > > > >> > >> > > >> > >> > > >> > >> > > >> > >> > > -- >> > >> > > >> > >> > > Robert Gonzalez >> > >> > > http://www.robert-gonzalez.com >> > >> > > _______________________________________________ >> > >> > > FreeTDS mailing list >> > >> > > [email protected] >> > >> > > http://lists.ibiblio.org/mailman/listinfo/freetds >> > >> > > >> > >> > >> > >> > >> > >> > >> > >> > -- >> > >> > Thank you with regards, >> > >> > Gopal, >> > >> > PeopleTech Systems Private Limited >> > >> > www.peopletech.co.in >> > >> > _______________________________________________ >> > >> > FreeTDS mailing list >> > >> > [email protected] >> > >> > http://lists.ibiblio.org/mailman/listinfo/freetds >> > >> > >> > >> >> > >> >> > >> >> > >> -- >> > >> >> > >> Robert Gonzalez >> > >> http://www.robert-gonzalez.com >> > >> _______________________________________________ >> > >> FreeTDS mailing list >> > >> [email protected] >> > >> http://lists.ibiblio.org/mailman/listinfo/freetds >> > >> >> > > >> > > >> > > >> > > -- >> > > Thank you with regards, >> > > Gopal, >> > > PeopleTech Systems Private Limited >> > > www.peopletech.co.in >> > > >> > >> > >> > >> > -- >> > Thank you with regards, >> > Gopal, >> > PeopleTech Systems Private Limited >> > www.peopletech.co.in >> > _______________________________________________ >> > FreeTDS mailing list >> > [email protected] >> > http://lists.ibiblio.org/mailman/listinfo/freetds >> > >> >> >> >> -- >> >> Robert Gonzalez >> http://www.robert-gonzalez.com >> _______________________________________________ >> FreeTDS mailing list >> [email protected] >> http://lists.ibiblio.org/mailman/listinfo/freetds >> > > > > -- > Thank you with regards, > Gopal, > PeopleTech Systems Private Limited > www.peopletech.co.in > -- Thank you with regards, Gopal, PeopleTech Systems Private Limited www.peopletech.co.in