An issue while connecting to the MS SQL Server
Joseph boshra <[email protected]> Wed, 5 Oct 2016 13:07:06 +0200
| Newsgroups | gmane.comp.db.unixodbc.devel |
|---|---|
| Message-ID | <CAJoZ0gUdiCW6_y9fXLxn9fj2W2qpzb5+03wiQgSy0a+PjbLJzA@mail.gmail.com> |
--===============0615112872== Content-Type: multipart/alternative; boundary=001a114ccd327ba2c5053e1c2df5 --001a114ccd327ba2c5053e1c2df5 Content-Type: text/plain; charset=UTF-8 Hello Brain I'm Joseph a developer I have a project where I need to connect to the MS SQL from Linux so after searching I found that I need to install 1- unixODBC 2- unixODBC 3- freetds-dev 4- freetds-bin 5- freetds-common 6- tdsodbc and here is my configuration /etc/odbcinst.ini [FreeTDS] Description = ODBC for MSSQL Driver = /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so Setup = /usr/lib/x86_64-linux-gnu/odbc/libtdsS.so UsageCount = 1 Fileusage = 1 Threading = 2 /etc/odbc.ini [MSSQL] Description = MSSQL Database Driver = FreeTDSDatabase = asterisk Server = 192.168.14.193 Username = sa Password = iti Trace = no TDS_Version = 8.0 Port = 1433 when I use this statement echo "select 1" | isql -v MSSQL I got [s1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source[s1000][unixODBC][FreeTDS][SQL Server]Login failed for user ''.[ISQL]ERROR: Could not SQLConnect but when I used this echo "select 1" | isql -v MSSQL sa iti it worked I also Modified Freetds.conf /etc/freetds/freetds.conf [MSSQL] Server = 192.168.14.193 TDS_Version = 8.0 Port = 1433 the question is, why isql failed to connect to SQL Server and was not able to read the user name and password from the odbc.ini file ? and what is the solution for this problem ? Thanks in advance Best Regards, Joseph --001a114ccd327ba2c5053e1c2df5 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr"><span style=3D"font-size:12.8px">Hello Brain</span><div st= yle=3D"font-size:12.8px"><br></div><div style=3D"font-size:12.8px">I'm = Joseph a developer=C2=A0<br><br>I have a project where I need to connect to= the MS SQL from Linux so after searching I found that I need to install=C2= =A0<br>1- unixODBC</div><div style=3D"font-size:12.8px">2- unixODBC</div><d= iv style=3D"font-size:12.8px">3- freetds-dev</div><div style=3D"font-size:1= 2.8px">4- freetds-bin</div><div style=3D"font-size:12.8px">5- freetds-commo= n</div><div style=3D"font-size:12.8px">6- tdsodbc</div><div style=3D"font-s= ize:12.8px"><br></div><div style=3D"font-size:12.8px">and here is my config= uration=C2=A0<br><br><p style=3D"margin:0px 0px 1em;padding:0px;border:0px;= font-size:15px;clear:both;color:rgb(36,39,41);font-family:arial,"helve= tica neue",helvetica,sans-serif">/etc/odbcinst.ini</p><pre class=3D"gm= ail-m_-5547042600921511845gmail-lang-sql gmail-m_-5547042600921511845gmail-= prettyprint gmail-m_-5547042600921511845gmail-prettyprinted" style=3D"white= -space:pre-wrap;margin-top:0px;margin-bottom:1em;padding:5px;border:0px;fon= t-size:13px;width:auto;max-height:600px;overflow:auto;font-family:consolas,= menlo,monaco,"lucida console","liberation mono","d= ejavu sans mono","bitstream vera sans mono","courier ne= w",monospace,sans-serif;background-color:rgb(239,240,241);color:rgb(57= ,51,24);word-wrap:normal"><code style=3D"margin:0px;padding:0px;border:0px;= font-family:consolas,menlo,monaco,"lucida console","liberati= on mono","dejavu sans mono","bitstream vera sans mono&q= uot;,"courier new",monospace,sans-serif;white-space:inherit"><spa= n class=3D"gmail-m_-5547042600921511845gmail-pun" style=3D"margin:0px;paddi= ng:0px;border:0px;color:rgb(48,51,54)">[</span><span class=3D"gmail-m_-5547= 042600921511845gmail-pln" style=3D"margin:0px;padding:0px;border:0px;color:= rgb(48,51,54)">FreeTDS</span><span class=3D"gmail-m_-5547042600921511845gma= il-pun" style=3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)">]</= span><span class=3D"gmail-m_-5547042600921511845gmail-pln" style=3D"margin:= 0px;padding:0px;border:0px;color:rgb(48,51,54)"> Description </span><span class=3D"gmail-m_-5547042600921511845gmail-pun" st= yle=3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)">=3D</span><sp= an class=3D"gmail-m_-5547042600921511845gmail-pln" style=3D"margin:0px;padd= ing:0px;border:0px;color:rgb(48,51,54)"> ODBC </span><span class=3D"gmail-m= _-5547042600921511845gmail-kwd" style=3D"margin:0px;padding:0px;border:0px;= color:rgb(16,16,148)">for</span><span class=3D"gmail-m_-5547042600921511845= gmail-pln" style=3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)">= MSSQL Driver </span><span class=3D"gmail-m_-5547042600921511845gmail-pun" style= =3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)">=3D</span><span = class=3D"gmail-m_-5547042600921511845gmail-pln" style=3D"margin:0px;padding= :0px;border:0px;color:rgb(48,51,54)"> </span><span class=3D"gmail-m_-554704= 2600921511845gmail-pun" style=3D"margin:0px;padding:0px;border:0px;color:rg= b(48,51,54)">/</span><span class=3D"gmail-m_-5547042600921511845gmail-pln" = style=3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)">usr</span><= span class=3D"gmail-m_-5547042600921511845gmail-pun" style=3D"margin:0px;pa= dding:0px;border:0px;color:rgb(48,51,54)">/</span><span class=3D"gmail-m_-5= 547042600921511845gmail-pln" style=3D"margin:0px;padding:0px;border:0px;col= or:rgb(48,51,54)">lib</span><span class=3D"gmail-m_-5547042600921511845gmai= l-pun" style=3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)">/</s= pan><span class=3D"gmail-m_-5547042600921511845gmail-pln" style=3D"margin:0= px;padding:0px;border:0px;color:rgb(48,51,54)">x86_64-linux-gnu</span><span= class=3D"gmail-m_-5547042600921511845gmail-pun" style=3D"margin:0px;paddin= g:0px;border:0px;color:rgb(48,51,54)">/</span><span class=3D"gmail-m_-55470= 42600921511845gmail-pln" style=3D"margin:0px;padding:0px;border:0px;color:r= gb(48,51,54)">odbc</span><span class=3D"gmail-m_-5547042600921511845gmail-p= un" style=3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)"><wbr>/<= /span><span class=3D"gmail-m_-5547042600921511845gmail-pln" style=3D"margin= :0px;padding:0px;border:0px;color:rgb(48,51,54)">libtdsodbc</span><span cla= ss=3D"gmail-m_-5547042600921511845gmail-pun" style=3D"margin:0px;padding:0p= x;border:0px;color:rgb(48,51,54)">.</span><span class=3D"gmail-m_-554704260= 0921511845gmail-pln" style=3D"margin:0px;padding:0px;border:0px;color:rgb(4= 8,51,54)">so Setup </span><span class=3D"gmail-m_-5547042600921511845gmail-pun" style=3D= "margin:0px;padding:0px;border:0px;color:rgb(48,51,54)">=3D</span><span cla= ss=3D"gmail-m_-5547042600921511845gmail-pln" style=3D"margin:0px;padding:0p= x;border:0px;color:rgb(48,51,54)"> </span><span class=3D"gmail-m_-554704260= 0921511845gmail-pun" style=3D"margin:0px;padding:0px;border:0px;color:rgb(4= 8,51,54)">/</span><span class=3D"gmail-m_-5547042600921511845gmail-pln" sty= le=3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)">usr</span><spa= n class=3D"gmail-m_-5547042600921511845gmail-pun" style=3D"margin:0px;paddi= ng:0px;border:0px;color:rgb(48,51,54)">/</span><span class=3D"gmail-m_-5547= 042600921511845gmail-pln" style=3D"margin:0px;padding:0px;border:0px;color:= rgb(48,51,54)">lib</span><span class=3D"gmail-m_-5547042600921511845gmail-p= un" style=3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)">/</span= ><span class=3D"gmail-m_-5547042600921511845gmail-pln" style=3D"margin:0px;= padding:0px;border:0px;color:rgb(48,51,54)">x86_64-linux-gnu</span><span cl= ass=3D"gmail-m_-5547042600921511845gmail-pun" style=3D"margin:0px;padding:0= px;border:0px;color:rgb(48,51,54)">/</span><span class=3D"gmail-m_-55470426= 00921511845gmail-pln" style=3D"margin:0px;padding:0px;border:0px;color:rgb(= 48,51,54)">odbc</span><span class=3D"gmail-m_-5547042600921511845gmail-pun"= style=3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)"><wbr>/</sp= an><span class=3D"gmail-m_-5547042600921511845gmail-pln" style=3D"margin:0p= x;padding:0px;border:0px;color:rgb(48,51,54)">libtdsS</span><span class=3D"= gmail-m_-5547042600921511845gmail-pun" style=3D"margin:0px;padding:0px;bord= er:0px;color:rgb(48,51,54)">.</span><span class=3D"gmail-m_-554704260092151= 1845gmail-pln" style=3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,5= 4)">so UsageCount </span><span class=3D"gmail-m_-5547042600921511845gmail-pun" sty= le=3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)">=3D</span><spa= n class=3D"gmail-m_-5547042600921511845gmail-pln" style=3D"margin:0px;paddi= ng:0px;border:0px;color:rgb(48,51,54)"> </span><span class=3D"gmail-m_-5547= 042600921511845gmail-lit" style=3D"margin:0px;padding:0px;border:0px;color:= rgb(125,39,39)">1</span><span class=3D"gmail-m_-5547042600921511845gmail-pl= n" style=3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)"> Fileusage </span><span class=3D"gmail-m_-5547042600921511845gmail-pun" styl= e=3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)">=3D</span><span= class=3D"gmail-m_-5547042600921511845gmail-pln" style=3D"margin:0px;paddin= g:0px;border:0px;color:rgb(48,51,54)"> </span><span class=3D"gmail-m_-55470= 42600921511845gmail-lit" style=3D"margin:0px;padding:0px;border:0px;color:r= gb(125,39,39)">1</span><span class=3D"gmail-m_-5547042600921511845gmail-pln= " style=3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)"> Threading </span><span class=3D"gmail-m_-5547042600921511845gmail-pun" styl= e=3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)">=3D</span><span= class=3D"gmail-m_-5547042600921511845gmail-pln" style=3D"margin:0px;paddin= g:0px;border:0px;color:rgb(48,51,54)"> </span><span class=3D"gmail-m_-55470= 42600921511845gmail-lit" style=3D"margin:0px;padding:0px;border:0px;color:r= gb(125,39,39)">2</span></code></pre><p style=3D"margin:0px 0px 1em;padding:= 0px;border:0px;font-size:15px;clear:both;color:rgb(36,39,41);font-family:ar= ial,"helvetica neue",helvetica,sans-serif">/etc/odbc.ini</p><pre = class=3D"gmail-m_-5547042600921511845gmail-lang-sql gmail-m_-55470426009215= 11845gmail-prettyprint gmail-m_-5547042600921511845gmail-prettyprinted" sty= le=3D"white-space:pre-wrap;margin-top:0px;margin-bottom:1em;padding:5px;bor= der:0px;font-size:13px;width:auto;max-height:600px;overflow:auto;font-famil= y:consolas,menlo,monaco,"lucida console","liberation mono&qu= ot;,"dejavu sans mono","bitstream vera sans mono","= ;courier new",monospace,sans-serif;background-color:rgb(239,240,241);c= olor:rgb(57,51,24);word-wrap:normal"><code style=3D"margin:0px;padding:0px;= border:0px;font-family:consolas,menlo,monaco,"lucida console",&qu= ot;liberation mono","dejavu sans mono","bitstream vera = sans mono","courier new",monospace,sans-serif;white-space:in= herit"><span class=3D"gmail-m_-5547042600921511845gmail-pun" style=3D"margi= n:0px;padding:0px;border:0px;color:rgb(48,51,54)">[</span><span class=3D"gm= ail-m_-5547042600921511845gmail-pln" style=3D"margin:0px;padding:0px;border= :0px;color:rgb(48,51,54)">MSSQL</span><span class=3D"gmail-m_-5547042600921= 511845gmail-pun" style=3D"margin:0px;padding:0px;border:0px;color:rgb(48,51= ,54)">]</span><span class=3D"gmail-m_-5547042600921511845gmail-pln" style= =3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)"> Description </span><span class=3D"gmail-m_-5547042600921511845gmail-pun" s= tyle=3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)">=3D</span><s= pan class=3D"gmail-m_-5547042600921511845gmail-pln" style=3D"margin:0px;pad= ding:0px;border:0px;color:rgb(48,51,54)"> MSSQL </span><span class=3D"gmail= -m_-5547042600921511845gmail-kwd" style=3D"margin:0px;padding:0px;border:0p= x;color:rgb(16,16,148)">Database</span><span class=3D"gmail-m_-554704260092= 1511845gmail-pln" style=3D"margin:0px;padding:0px;border:0px;color:rgb(48,5= 1,54)"> Driver </span><span class=3D"gmail-m_-5547042600921511845gmail-pun" style= =3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)">=3D</span><span = class=3D"gmail-m_-5547042600921511845gmail-pln" style=3D"margin:0px;padding= :0px;border:0px;color:rgb(48,51,54)"> FreeTDS </span><span class=3D"gmail-m_-5547042600921511845gmail-kwd" style=3D"margi= n:0px;padding:0px;border:0px;color:rgb(16,16,148)">Database</span><span cla= ss=3D"gmail-m_-5547042600921511845gmail-pln" style=3D"margin:0px;padding:0p= x;border:0px;color:rgb(48,51,54)"> </span><span class=3D"gmail-m_-554704260= 0921511845gmail-pun" style=3D"margin:0px;padding:0px;border:0px;color:rgb(4= 8,51,54)">=3D</span><span class=3D"gmail-m_-5547042600921511845gmail-pln" s= tyle=3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)"> asterisk Server </span><span class=3D"gmail-m_-5547042600921511845gmail-pun" style= =3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)">=3D</span><span = class=3D"gmail-m_-5547042600921511845gmail-pln" style=3D"margin:0px;padding= :0px;border:0px;color:rgb(48,51,54)"> </span><span class=3D"gmail-m_-554704= 2600921511845gmail-lit" style=3D"margin:0px;padding:0px;border:0px;color:rg= b(125,39,39)">192.168.14.193</span><span class=3D"gmail-m_-5547042600921511= 845gmail-pln" style=3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54= )"> Username </span><span class=3D"gmail-m_-5547042600921511845gmail-pun" style= =3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)">=3D</span><span = class=3D"gmail-m_-5547042600921511845gmail-pln" style=3D"margin:0px;padding= :0px;border:0px;color:rgb(48,51,54)"> sa Password </span><span class=3D"gmail-m_-5547042600921511845gmail-pun" style= =3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)">=3D</span><span = class=3D"gmail-m_-5547042600921511845gmail-pln" style=3D"margin:0px;padding= :0px;border:0px;color:rgb(48,51,54)"> iti Trace </span><span class=3D"gmail-m_-5547042600921511845gmail-pun" style=3D= "margin:0px;padding:0px;border:0px;color:rgb(48,51,54)">=3D</span><span cla= ss=3D"gmail-m_-5547042600921511845gmail-pln" style=3D"margin:0px;padding:0p= x;border:0px;color:rgb(48,51,54)"> no TDS_Version </span><span class=3D"gmail-m_-5547042600921511845gmail-pun" st= yle=3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)">=3D</span><sp= an class=3D"gmail-m_-5547042600921511845gmail-pln" style=3D"margin:0px;padd= ing:0px;border:0px;color:rgb(48,51,54)"> </span><span class=3D"gmail-m_-554= 7042600921511845gmail-lit" style=3D"margin:0px;padding:0px;border:0px;color= :rgb(125,39,39)">8.0</span><span class=3D"gmail-m_-5547042600921511845gmail= -pln" style=3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)"> Port </span><span class=3D"gmail-m_-5547042600921511845gmail-pun" style=3D"= margin:0px;padding:0px;border:0px;color:rgb(48,51,54)">=3D</span><span clas= s=3D"gmail-m_-5547042600921511845gmail-pln" style=3D"margin:0px;padding:0px= ;border:0px;color:rgb(48,51,54)"> </span><span class=3D"gmail-m_-5547042600= 921511845gmail-lit" style=3D"margin:0px;padding:0px;border:0px;color:rgb(12= 5,39,39)">1433</span></code></pre><p style=3D"margin:0px 0px 1em;padding:0p= x;border:0px;font-size:15px;clear:both;color:rgb(36,39,41);font-family:aria= l,"helvetica neue",helvetica,sans-serif">when I use this statemen= t</p><pre class=3D"gmail-m_-5547042600921511845gmail-lang-sql gmail-m_-5547= 042600921511845gmail-prettyprint gmail-m_-5547042600921511845gmail-prettypr= inted" style=3D"white-space:pre-wrap;margin-top:0px;margin-bottom:1em;paddi= ng:5px;border:0px;font-size:13px;width:auto;max-height:600px;overflow:auto;= font-family:consolas,menlo,monaco,"lucida console","liberati= on mono","dejavu sans mono","bitstream vera sans mono&q= uot;,"courier new",monospace,sans-serif;background-color:rgb(239,= 240,241);color:rgb(57,51,24);word-wrap:normal"><code style=3D"margin:0px;pa= dding:0px;border:0px;font-family:consolas,menlo,monaco,"lucida console= ","liberation mono","dejavu sans mono","bitst= ream vera sans mono","courier new",monospace,sans-serif;whit= e-space:inherit"><span class=3D"gmail-m_-5547042600921511845gmail-pln" styl= e=3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)">echo </span><sp= an class=3D"gmail-m_-5547042600921511845gmail-str" style=3D"margin:0px;padd= ing:0px;border:0px;color:rgb(125,39,39)">"select 1"</span><span c= lass=3D"gmail-m_-5547042600921511845gmail-pln" style=3D"margin:0px;padding:= 0px;border:0px;color:rgb(48,51,54)"> </span><span class=3D"gmail-m_-5547042= 600921511845gmail-pun" style=3D"margin:0px;padding:0px;border:0px;color:rgb= (48,51,54)">|</span><span class=3D"gmail-m_-5547042600921511845gmail-pln" s= tyle=3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)"> isql </span= ><span class=3D"gmail-m_-5547042600921511845gmail-pun" style=3D"margin:0px;= padding:0px;border:0px;color:rgb(48,51,54)">-</span><span class=3D"gmail-m_= -5547042600921511845gmail-pln" style=3D"margin:0px;padding:0px;border:0px;c= olor:rgb(48,51,54)">v MSSQL</span></code></pre><p style=3D"margin:0px 0px 1= em;padding:0px;border:0px;font-size:15px;clear:both;color:rgb(36,39,41);fon= t-family:arial,"helvetica neue",helvetica,sans-serif">I got</p><p= re class=3D"gmail-m_-5547042600921511845gmail-lang-sql gmail-m_-55470426009= 21511845gmail-prettyprint gmail-m_-5547042600921511845gmail-prettyprinted" = style=3D"white-space:pre-wrap;margin-top:0px;margin-bottom:1em;padding:5px;= border:0px;font-size:13px;width:auto;max-height:600px;overflow:auto;font-fa= mily:consolas,menlo,monaco,"lucida console","liberation mono= ","dejavu sans mono","bitstream vera sans mono",&q= uot;courier new",monospace,sans-serif;background-color:rgb(239,240,241= );color:rgb(57,51,24);word-wrap:normal"><code style=3D"margin:0px;padding:0= px;border:0px;font-family:consolas,menlo,monaco,"lucida console",= "liberation mono","dejavu sans mono","bitstream ve= ra sans mono","courier new",monospace,sans-serif;white-space= :inherit"><span class=3D"gmail-m_-5547042600921511845gmail-pun" style=3D"ma= rgin:0px;padding:0px;border:0px;color:rgb(48,51,54)">[</span><span class=3D= "gmail-m_-5547042600921511845gmail-pln" style=3D"margin:0px;padding:0px;bor= der:0px;color:rgb(48,51,54)">s1000</span><span class=3D"gmail-m_-5547042600= 921511845gmail-pun" style=3D"margin:0px;padding:0px;border:0px;color:rgb(48= ,51,54)">][</span><span class=3D"gmail-m_-5547042600921511845gmail-pln" sty= le=3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)">unixODBC</span= ><span class=3D"gmail-m_-5547042600921511845gmail-pun" style=3D"margin:0px;= padding:0px;border:0px;color:rgb(48,51,54)">][</span><span class=3D"gmail-m= _-5547042600921511845gmail-pln" style=3D"margin:0px;padding:0px;border:0px;= color:rgb(48,51,54)">FreeTDS</span><span class=3D"gmail-m_-5547042600921511= 845gmail-pun" style=3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54= )">][</span><span class=3D"gmail-m_-5547042600921511845gmail-pln" style=3D"= margin:0px;padding:0px;border:0px;color:rgb(48,51,54)">SQL Server</span><sp= an class=3D"gmail-m_-5547042600921511845gmail-pun" style=3D"margin:0px;padd= ing:0px;border:0px;color:rgb(48,51,54)">]</span><span class=3D"gmail-m_-554= 7042600921511845gmail-pln" style=3D"margin:0px;padding:0px;border:0px;color= :rgb(48,51,54)">Unable </span><span class=3D"gmail-m_-5547042600921511845gm= ail-kwd" style=3D"margin:0px;padding:0px;border:0px;color:rgb(16,16,148)">t= o</span><span class=3D"gmail-m_-5547042600921511845gmail-pln" style=3D"marg= in:0px;padding:0px;border:0px;color:rgb(48,51,54)"> </span><span class=3D"g= mail-m_-5547042600921511845gmail-kwd" style=3D"margin:0px;padding:0px;borde= r:0px;color:rgb(16,16,148)">connect</span><span class=3D"gmail-m_-554704260= 0921511845gmail-pln" style=3D"margin:0px;padding:0px;border:0px;color:rgb(4= 8,51,54)"> </span><span class=3D"gmail-m_-5547042600921511845gmail-kwd" sty= le=3D"margin:0px;padding:0px;border:0px;color:rgb(16,16,148)">to</span><spa= n class=3D"gmail-m_-5547042600921511845gmail-pln" style=3D"margin:0px;paddi= ng:0px;border:0px;color:rgb(48,51,54)"> data source </span><span class=3D"gmail-m_-5547042600921511845gmail-pun" style=3D"margi= n:0px;padding:0px;border:0px;color:rgb(48,51,54)">[</span><span class=3D"gm= ail-m_-5547042600921511845gmail-pln" style=3D"margin:0px;padding:0px;border= :0px;color:rgb(48,51,54)">s1000</span><span class=3D"gmail-m_-5547042600921= 511845gmail-pun" style=3D"margin:0px;padding:0px;border:0px;color:rgb(48,51= ,54)">][</span><span class=3D"gmail-m_-5547042600921511845gmail-pln" style= =3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)">unixODBC</span><= span class=3D"gmail-m_-5547042600921511845gmail-pun" style=3D"margin:0px;pa= dding:0px;border:0px;color:rgb(48,51,54)">][</span><span class=3D"gmail-m_-= 5547042600921511845gmail-pln" style=3D"margin:0px;padding:0px;border:0px;co= lor:rgb(48,51,54)">FreeTDS</span><span class=3D"gmail-m_-554704260092151184= 5gmail-pun" style=3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)"= >][</span><span class=3D"gmail-m_-5547042600921511845gmail-pln" style=3D"ma= rgin:0px;padding:0px;border:0px;color:rgb(48,51,54)">SQL Server</span><span= class=3D"gmail-m_-5547042600921511845gmail-pun" style=3D"margin:0px;paddin= g:0px;border:0px;color:rgb(48,51,54)">]</span><span class=3D"gmail-m_-55470= 42600921511845gmail-pln" style=3D"margin:0px;padding:0px;border:0px;color:r= gb(48,51,54)">Login failed </span><span class=3D"gmail-m_-55470426009215118= 45gmail-kwd" style=3D"margin:0px;padding:0px;border:0px;color:rgb(16,16,148= )">for</span><span class=3D"gmail-m_-5547042600921511845gmail-pln" style=3D= "margin:0px;padding:0px;border:0px;color:rgb(48,51,54)"> </span><span class= =3D"gmail-m_-5547042600921511845gmail-kwd" style=3D"margin:0px;padding:0px;= border:0px;color:rgb(16,16,148)">user</span><span class=3D"gmail-m_-5547042= 600921511845gmail-pln" style=3D"margin:0px;padding:0px;border:0px;color:rgb= (48,51,54)"> </span><span class=3D"gmail-m_-5547042600921511845gmail-str" s= tyle=3D"margin:0px;padding:0px;border:0px;color:rgb(125,39,39)">''<= /span><span class=3D"gmail-m_-5547042600921511845gmail-pun" style=3D"margin= :0px;padding:0px;border:0px;color:rgb(48,51,54)">.</span><span class=3D"gma= il-m_-5547042600921511845gmail-pln" style=3D"margin:0px;padding:0px;border:= 0px;color:rgb(48,51,54)"> </span><span class=3D"gmail-m_-5547042600921511845gmail-pun" style=3D"margi= n:0px;padding:0px;border:0px;color:rgb(48,51,54)">[</span><span class=3D"gm= ail-m_-5547042600921511845gmail-pln" style=3D"margin:0px;padding:0px;border= :0px;color:rgb(48,51,54)">ISQL</span><span class=3D"gmail-m_-55470426009215= 11845gmail-pun" style=3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,= 54)">]</span><span class=3D"gmail-m_-5547042600921511845gmail-pln" style=3D= "margin:0px;padding:0px;border:0px;color:rgb(48,51,54)">ERROR</span><span c= lass=3D"gmail-m_-5547042600921511845gmail-pun" style=3D"margin:0px;padding:= 0px;border:0px;color:rgb(48,51,54)">:</span><span class=3D"gmail-m_-5547042= 600921511845gmail-pln" style=3D"margin:0px;padding:0px;border:0px;color:rgb= (48,51,54)"> Could </span><span class=3D"gmail-m_-5547042600921511845gmail-= kwd" style=3D"margin:0px;padding:0px;border:0px;color:rgb(16,16,148)">not</= span><span class=3D"gmail-m_-5547042600921511845gmail-pln" style=3D"margin:= 0px;padding:0px;border:0px;color:rgb(48,51,54)"> SQLConnect</span></code></= pre><p style=3D"margin:0px 0px 1em;padding:0px;border:0px;font-size:15px;cl= ear:both;color:rgb(36,39,41);font-family:arial,"helvetica neue",h= elvetica,sans-serif">but when I used this=C2=A0<code style=3D"margin:0px;pa= dding:1px 5px;border:0px;font-size:13px;font-family:consolas,menlo,monaco,&= quot;lucida console","liberation mono","dejavu sans mon= o","bitstream vera sans mono","courier new",monosp= ace,sans-serif;background-color:rgb(239,240,241);white-space:pre-wrap">echo= "select 1" | isql -v MSSQL sa iti</code>=C2=A0it worked</p><p st= yle=3D"margin:0px 0px 1em;padding:0px;border:0px;font-size:15px;clear:both;= color:rgb(36,39,41);font-family:arial,"helvetica neue",helvetica,= sans-serif">I also Modified Freetds.conf</p><p style=3D"margin:0px 0px 1em;= padding:0px;border:0px;font-size:15px;clear:both;color:rgb(36,39,41);font-f= amily:arial,"helvetica neue",helvetica,sans-serif">/etc/freetds/f= reetds.conf</p><pre class=3D"gmail-m_-5547042600921511845gmail-lang-sql gma= il-m_-5547042600921511845gmail-prettyprint gmail-m_-5547042600921511845gmai= l-prettyprinted" style=3D"white-space:pre-wrap;margin-top:0px;margin-bottom= :1em;padding:5px;border:0px;font-size:13px;width:auto;max-height:600px;over= flow:auto;font-family:consolas,menlo,monaco,"lucida console",&quo= t;liberation mono","dejavu sans mono","bitstream vera s= ans mono","courier new",monospace,sans-serif;background-colo= r:rgb(239,240,241);color:rgb(57,51,24);word-wrap:normal"><code style=3D"mar= gin:0px;padding:0px;border:0px;font-family:consolas,menlo,monaco,"luci= da console","liberation mono","dejavu sans mono",&= quot;bitstream vera sans mono","courier new",monospace,sans-= serif;white-space:inherit"><span class=3D"gmail-m_-5547042600921511845gmail= -pun" style=3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)">[</sp= an><span class=3D"gmail-m_-5547042600921511845gmail-pln" style=3D"margin:0p= x;padding:0px;border:0px;color:rgb(48,51,54)">MSSQL</span><span class=3D"gm= ail-m_-5547042600921511845gmail-pun" style=3D"margin:0px;padding:0px;border= :0px;color:rgb(48,51,54)">]</span><span class=3D"gmail-m_-55470426009215118= 45gmail-pln" style=3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)= "> Server </span><span class=3D"gmail-m_-5547042600921511845gmail-pun" style= =3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)">=3D</span><span = class=3D"gmail-m_-5547042600921511845gmail-pln" style=3D"margin:0px;padding= :0px;border:0px;color:rgb(48,51,54)"> </span><span class=3D"gmail-m_-554704= 2600921511845gmail-lit" style=3D"margin:0px;padding:0px;border:0px;color:rg= b(125,39,39)">192.168.14.193</span><span class=3D"gmail-m_-5547042600921511= 845gmail-pln" style=3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54= )"> TDS_Version </span><span class=3D"gmail-m_-5547042600921511845gmail-pun" st= yle=3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)">=3D</span><sp= an class=3D"gmail-m_-5547042600921511845gmail-pln" style=3D"margin:0px;padd= ing:0px;border:0px;color:rgb(48,51,54)"> </span><span class=3D"gmail-m_-554= 7042600921511845gmail-lit" style=3D"margin:0px;padding:0px;border:0px;color= :rgb(125,39,39)">8.0</span><span class=3D"gmail-m_-5547042600921511845gmail= -pln" style=3D"margin:0px;padding:0px;border:0px;color:rgb(48,51,54)"> Port </span><span class=3D"gmail-m_-5547042600921511845gmail-pun" style=3D"= margin:0px;padding:0px;border:0px;color:rgb(48,51,54)">=3D</span><span clas= s=3D"gmail-m_-5547042600921511845gmail-pln" style=3D"margin:0px;padding:0px= ;border:0px;color:rgb(48,51,54)"> </span><span class=3D"gmail-m_-5547042600= 921511845gmail-lit" style=3D"margin:0px;padding:0px;border:0px;color:rgb(12= 5,39,39)">1433</span></code></pre><pre class=3D"gmail-m_-554704260092151184= 5gmail-lang-sql gmail-m_-5547042600921511845gmail-prettyprint gmail-m_-5547= 042600921511845gmail-prettyprinted" style=3D"white-space:pre-wrap;margin-to= p:0px;margin-bottom:1em;padding:5px;border:0px;font-size:13px;width:auto;ma= x-height:600px;overflow:auto;font-family:consolas,menlo,monaco,"lucida= console","liberation mono","dejavu sans mono",&qu= ot;bitstream vera sans mono","courier new",monospace,sans-se= rif;background-color:rgb(239,240,241);color:rgb(57,51,24);word-wrap:normal"= ><code style=3D"margin:0px;padding:0px;border:0px;font-family:consolas,menl= o,monaco,"lucida console","liberation mono","dejav= u sans mono","bitstream vera sans mono","courier new&qu= ot;,monospace,sans-serif;white-space:inherit"><span class=3D"gmail-m_-55470= 42600921511845gmail-lit" style=3D"margin:0px;padding:0px;border:0px;color:r= gb(125,39,39)"><br></span></code></pre><pre class=3D"gmail-m_-5547042600921= 511845gmail-lang-sql gmail-m_-5547042600921511845gmail-prettyprint gmail-m_= -5547042600921511845gmail-prettyprinted" style=3D"white-space:pre-wrap;marg= in-top:0px;margin-bottom:1em;padding:5px;border:0px;font-size:13px;width:au= to;max-height:600px;overflow:auto;font-family:consolas,menlo,monaco,"l= ucida console","liberation mono","dejavu sans mono"= ;,"bitstream vera sans mono","courier new",monospace,sa= ns-serif;background-color:rgb(239,240,241);color:rgb(57,51,24);word-wrap:no= rmal"><code style=3D"margin:0px;padding:0px;border:0px;font-family:consolas= ,menlo,monaco,"lucida console","liberation mono","= dejavu sans mono","bitstream vera sans mono","courier n= ew",monospace,sans-serif;white-space:inherit"><span class=3D"gmail-m_-= 5547042600921511845gmail-lit" style=3D"margin:0px;padding:0px;border:0px;co= lor:rgb(125,39,39)"><span style=3D"color:rgb(36,39,41);font-family:arial,&q= uot;helvetica neue",helvetica,sans-serif;font-size:15px;white-space:no= rmal;background-color:rgb(255,255,255)">the question =C2=A0is, why isql fai= led to connect to SQL Server and was not able to read the user name and pas= sword from the odbc.ini file ? and what is the solution for this problem ?<= /span><br></span></code></pre><pre class=3D"gmail-m_-5547042600921511845gma= il-lang-sql gmail-m_-5547042600921511845gmail-prettyprint gmail-m_-55470426= 00921511845gmail-prettyprinted" style=3D"white-space:pre-wrap;margin-top:0p= x;margin-bottom:1em;padding:5px;border:0px;font-size:13px;width:auto;max-he= ight:600px;overflow:auto;font-family:consolas,menlo,monaco,"lucida con= sole","liberation mono","dejavu sans mono","b= itstream vera sans mono","courier new",monospace,sans-serif;= background-color:rgb(239,240,241);color:rgb(57,51,24);word-wrap:normal"><co= de style=3D"margin:0px;padding:0px;border:0px;font-family:consolas,menlo,mo= naco,"lucida console","liberation mono","dejavu sa= ns mono","bitstream vera sans mono","courier new",= monospace,sans-serif;white-space:inherit"><span class=3D"gmail-m_-554704260= 0921511845gmail-lit" style=3D"margin:0px;padding:0px;border:0px;color:rgb(1= 25,39,39)"><span style=3D"color:rgb(36,39,41);font-family:arial,"helve= tica neue",helvetica,sans-serif;font-size:15px;white-space:normal;back= ground-color:rgb(255,255,255)">Thanks in advance</span></span></code></pre>= <pre class=3D"gmail-m_-5547042600921511845gmail-lang-sql gmail-m_-554704260= 0921511845gmail-prettyprint gmail-m_-5547042600921511845gmail-prettyprinted= " style=3D"white-space:pre-wrap;margin-top:0px;margin-bottom:1em;padding:5p= x;border:0px;font-size:13px;width:auto;max-height:600px;overflow:auto;font-= family:consolas,menlo,monaco,"lucida console","liberation mo= no","dejavu sans mono","bitstream vera sans mono",= "courier new",monospace,sans-serif;background-color:rgb(239,240,2= 41);color:rgb(57,51,24);word-wrap:normal"><code style=3D"margin:0px;padding= :0px;border:0px;font-family:consolas,menlo,monaco,"lucida console"= ;,"liberation mono","dejavu sans mono","bitstream = vera sans mono","courier new",monospace,sans-serif;white-spa= ce:inherit"><span class=3D"gmail-m_-5547042600921511845gmail-lit" style=3D"= margin:0px;padding:0px;border:0px;color:rgb(125,39,39)"><span style=3D"colo= r:rgb(36,39,41);font-family:arial,"helvetica neue",helvetica,sans= -serif;font-size:15px;white-space:normal;background-color:rgb(255,255,255)"= >Best Regards,</span></span></code></pre><pre class=3D"gmail-m_-55470426009= 21511845gmail-lang-sql gmail-m_-5547042600921511845gmail-prettyprint gmail-= m_-5547042600921511845gmail-prettyprinted" style=3D"white-space:pre-wrap;ma= rgin-top:0px;margin-bottom:1em;padding:5px;border:0px;font-size:13px;width:= auto;max-height:600px;overflow:auto;font-family:consolas,menlo,monaco,"= ;lucida console","liberation mono","dejavu sans mono&qu= ot;,"bitstream vera sans mono","courier new",monospace,= sans-serif;background-color:rgb(239,240,241);color:rgb(57,51,24);word-wrap:= normal"><code style=3D"margin:0px;padding:0px;border:0px;font-family:consol= as,menlo,monaco,"lucida console","liberation mono",&quo= t;dejavu sans mono","bitstream vera sans mono","courier= new",monospace,sans-serif;white-space:inherit"><span class=3D"gmail-m= _-5547042600921511845gmail-lit" style=3D"margin:0px;padding:0px;border:0px;= color:rgb(125,39,39)"><span style=3D"color:rgb(36,39,41);font-family:arial,= "helvetica neue",helvetica,sans-serif;font-size:15px;white-space:= normal;background-color:rgb(255,255,255)">Joseph</span></span></code></pre>= </div></div> --001a114ccd327ba2c5053e1c2df5-- --===============0615112872== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ unixODBC-dev mailing list [email protected] http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev --===============0615112872==--