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 - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig