pymssql: version problem?

--===============3519098681344793042==
Content-Type: multipart/alternative; boundary=000e0cd47f10e4d17304733e19ec

--000e0cd47f10e4d17304733e19ec
Content-Type: text/plain; charset=ISO-8859-1

hello experts,

Thanks for all of your replies during the past three days. I installed "
pymssql-0.8.0" instead of "python-sybase-0.39".

>From my test results I see that I could connect to Sybase with "tsql" on
prompt no matter if I use "freetds.conf" or not. However, if I use Python
script as follows

import pymssql
con=pymssql.connect(dbhost, user, password)

the I got
"_mssql.error: Could not connect to MS SQL Server".

I know that there are three "freetds.conf" files. One is in
"/home/my_dir/freetds-0.82/". The second one is in /etc/ and the third one
is in /etc/freetds/. They are all the same. In global section "tds version =
4.2" and in SybaseServer section "tds version = 5.0".   When I installed
"freetds-0.82" I indicted that with-tdsver=4.2.

Why does this Python script try to connect MS SQL Server? Is there any other
place besides freetds that indicates MS-SQL or Sybase? And "tsql" works
correctly on prompt with freestd file.

Any clues how to fix this problem?

Thanks so much. I appreciate your help.

--000e0cd47f10e4d17304733e19ec
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div>hello experts, </div>
<div>=A0</div>
<div>Thanks for all of your replies during the past three days. I installed=
 &quot; pymssql-0.8.0&quot; instead of &quot;python-sybase-0.39&quot;.</div=
>
<div>=A0</div>
<div>From my test results I see that I could connect to Sybase with &quot;t=
sql&quot; on prompt no matter if I use &quot;freetds.conf&quot; or not. How=
ever, if I use Python script as follows</div>
<div>=A0</div>
<div>import pymssql</div>
<div>con=3Dpymssql.connect(dbhost, user, password)</div>
<div>=A0</div>
<div>the I got </div>
<div>&quot;_mssql.error: Could not connect to MS SQL Server&quot;. </div>
<div>=A0</div>
<div>I know that there are three &quot;freetds.conf&quot; files. One is in =
&quot;/home/my_dir/freetds-0.82/&quot;. The second one is in /etc/ and the =
third one is in /etc/freetds/. They are all the same. In global section &qu=
ot;tds version =3D 4.2&quot; and in SybaseServer section &quot;tds version =
=3D 5.0&quot;.=A0=A0 When I installed &quot;freetds-0.82&quot; I indicted t=
hat with-tdsver=3D4.2.=A0=A0=A0 </div>

<div>=A0</div>
<div>Why does this Python script try to connect MS SQL Server? Is there any=
 other place besides freetds that indicates MS-SQL or Sybase? And &quot;tsq=
l&quot; works correctly on prompt with freestd file. </div>
<div>=A0</div>
<div>Any clues how to fix this problem? </div>
<div>=A0</div>
<div>Thanks so much. I appreciate your help. <br></div>

--000e0cd47f10e4d17304733e19ec--


--===============3519098681344793042==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
--===============3519098681344793042==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Python-sybase-misc mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/python-sybase-misc

--===============3519098681344793042==--