#130 adodbapi - InterfaceError #Probably COM Error adodbapi.adodb

closed
nobody
None
5
2011-06-02
2011-05-22
Anonymous
No

I'm very new to Python and I have Python 3.2 installed on a Win 7-32 workstation. Trying to connect to MSSQLServer 2005 Server using adodbapi-2.4.2.2, the latest update to that package.

The code/connection string looks like this:

conn = adodbapi.connect('Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=XXX;Data Source=123.456.789');

From adodbapi I continually get the error (this is entire error message from Wing IDE shell):

Traceback (most recent call last): File "D:\Program Files\Wing IDE 4.0\src\debug\tserver_sandbox.py", line 2, in if name == 'main': File "D:\Python32\Lib\site-packages\adodbapi\adodbapi.py", line 298, in connect raise InterfaceError #Probably COM Error adodbapi.adodbapi.InterfaceError:

I can trace through the code and see the exception as it happens.

I also tried using conn strings with OLEDB provider and integrated Windows security, with same results.

All of these connection strings work fine from a UDL fine on my workstation, and from SSMS, but fail with the same error in adodbapi.

Any help in solving this would be appreciated.

Discussion

    • status: open --> closed
     
  • This is the bug tracker for the Python Package Index (PyPI), not for any individual package. Please contact the authors of the package for bugs in the package.