[DB-SIG] dbabi - ms sql 2005

[cem yildiz]

hi,

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
adodbapi.InterfaceError

thank you all,
cem
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/db-sig/attachments/20120211/3bb83154/attachment.html>