Skip site navigation (1) Skip section navigation (2)

pymssql Connection to the database failed for an unknown reason

From: orgilhp <orgilhp(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pymssql Connection to the database failed for an unknown reason
Date: 2011-01-29 13:08:22
Message-ID: c340a047-1dcf-4833-a6f7-fa9da9a7b725@l22g2000pre.googlegroups.com (view raw or flat)
Thread:
Lists: pgsql-general
Hello
I am using pymssql to connect to MSSQL2008 database. But an error
occurs:
------------------------------------------------------------------
>>> import pymssql
>>> conn = pymssql.connect(host='orgilhpnb\mssql2008', user='erp', password='123', database='eoffice_clone')
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/usr/lib/pymodules/python2.6/pymssql.py", line 609, in connect
    raise InterfaceError, e[0]
pymssql.InterfaceError: Connection to the database failed for an
unknown reason.
------------------------------------------------------------------

The host name, user, password and database name are all correct.
Why I get an error? Please help me!

Any suggestion would be highly appreciated!

Best regards,
Orgil

Responses

pgsql-general by date

Next:From: Matt WarnerDate: 2011-01-29 14:46:43
Subject: Re: Full Text Index Scanning
Previous:From: Thom BrownDate: 2011-01-29 11:58:00
Subject: Re: PG9.0 planner difference to 8.3 -> majorly bad performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group