Thread: pymssql Connection to the database failed for an unknown reason
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
On 29 January 2011 13:08, orgilhp <orgilhp@gmail.com> wrote: > 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 Again, this is a PostgreSQL list. Please use this list for PostgreSQL-related queries only. -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935
Re: pymssql Connection to the database failed for an unknown reason
From
Thomson.Li@sourcephotonics.com
Date:
On Saturday, January 29, 2011 9:08:22 PM UTC+8, orgilhp wrote: > 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 Do you solve this issue? I encounted the same issue would you like to reply the issue?
On 10 Oct 2012, at 3:17, Thomson.Li@sourcephotonics.com wrote: > On Saturday, January 29, 2011 9:08:22 PM UTC+8, orgilhp wrote: >> 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 > > Do you solve this issue? I encounted the same issue > would you like to reply the issue? It looks like you're accidentally using an MS-SQL interface to connect to a Postgres database? Or you're asking the wrongmailing list ;) Alban Hertroys -- Religion is: Volunteering your children for brainwashing.