From: VV W <vv...@gm...> - 2009-09-10 19:21:15
|
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. |