Hi everyone, as the title says I'm trying to run sqlalchemy (pyodbc) with SQL Server 2008 on Windows Server 2008 R2 sp1 but I'm failing with the database connection. Here is a small script I'm using to test the connection:
from sqlalchemy import * from sqlalchemy.engine import reflection url = "mssql+pyodbc://user:password@my.server.address/server_test" e = create_engine(url) insp = reflection.Inspector.from_engine(e) print insp.get_table_names() If I the script I get the following error: Traceback (most recent call last): File "connection.py", line 6, in <module> File "C:\Python27\lib\site-packages\sqlalchemy\engine\reflection.py", line 118 , in from_engine return Inspector(bind) File "C:\Python27\lib\site-packages\sqlalchemy\engine\reflection.py", line 94, in __init__ bind.connect().close() File "C:\Python27\lib\site-packages\sqlalchemy\engine\base.py", line 2316, in connect return self._connection_cls(self, **kwargs) File "C:\Python27\lib\site-packages\sqlalchemy\engine\base.py", line 872, in _ _init__ self.__connection = connection or engine.raw_connection() File "C:\Python27\lib\site-packages\sqlalchemy\engine\base.py", line 2402, in raw_connection return self.pool.unique_connection() File "C:\Python27\lib\site-packages\sqlalchemy\pool.py", line 169, in unique_c onnection return _ConnectionFairy(self).checkout() File "C:\Python27\lib\site-packages\sqlalchemy\pool.py", line 371, in __init__ rec = self._connection_record = pool._do_get() File "C:\Python27\lib\site-packages\sqlalchemy\pool.py", line 697, in _do_get con = self._create_connection() File "C:\Python27\lib\site-packages\sqlalchemy\pool.py", line 174, in _create_ connection return _ConnectionRecord(self) File "C:\Python27\lib\site-packages\sqlalchemy\pool.py", line 256, in __init__ self.connection = self.__connect() File "C:\Python27\lib\site-packages\sqlalchemy\pool.py", line 316, in __connec t connection = self.__pool._creator() File "C:\Python27\lib\site-packages\sqlalchemy\engine\strategies.py", line 80, in connect return dialect.connect(*cargs, **cparams) File "C:\Python27\lib\site-packages\sqlalchemy\engine\default.py", line 280, i n connect return self.dbapi.connect(*cargs, **cparams) sqlalchemy.exc.DBAPIError: (Error) ('08001', '[08001] [Microsoft][ODBC SQL Serve r Driver][DBNETLIB]Invalid connection. (14) (SQLDriverConnect); [01000] [Microso ft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Invalid Instance()). (14)') None None The connection tested with SQL Server Management Studio works fine, so it should not be an authentication problem. Has anyone an idea of what I'm doing wrong? Thanks in advance! -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/g0c-MFla6pAJ. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.