dbabi - ms sql 2005

cem yildiz <[email protected]>
Newsgroups gmane.comp.python.db
Message-ID <CAMNf0djv1So5x=g-S3h83L5-FbMASFtb4bNqk+B_M2i-O7pigw@mail.gmail.com>
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

_______________________________________________
DB-SIG maillist  -  [email protected]
http://mail.python.org/mailman/listinfo/db-sig
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.