[DB-SIG] dbabi - ms sql 2005
vernondcole at gmail.com
Mon Feb 13 17:18:15 CET 2012
Using Python 3.2.2 and pywin32-217 on Windows 7 (all 64 bit), I get this
result (filtering out the crud):
pywintypes.com_error: (-2147352567, 'Exception occurred.', (0, 'Microsoft
OLE Provider for SQL Server', "Login failed for user 'ableton'.", None, 0,
Which would mean that the server is working and does not recognize your
password, which, I hope, is to be expected. I see nothing wrong with your
What versions of everything are you using?
On Sat, Feb 11, 2012 at 1:45 PM, cem yildiz <cem at fizy.com> wrote
> i am trying to connect sql server 2005 via db api 2.0 in last 3 days but i
> couldn't handle it. i can connect to the database remotely by navicat
> without any problem. i would be really very happy if anyone knows where do
> i make the mistake.
> >>> import adodbapi
> >>> cs = "Provider=SQLOLEDB;Data Source=sql2002.shared-servers.com,1086;Initial
> Catalog=ableton;User ID=ableton;Password=miklagard1;"
> >>> conn = adodbapi.connect(cs)
> Traceback (most recent call last):
> File "<stdin>", line 1, in <module>
> File "adodbapi.py", line 298, in connect
> raise InterfaceError #Probably COM Error
> thank you all,
> DB-SIG maillist - DB-SIG at python.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the DB-SIG