I am trying to establish a connection to a database provided by Microsoft SQL
Server 2008 on our local network. The traceback seems to indicate that pyodbc
is not being found, but this is my first attempt to use SQLAlchemy with a
database other than sqlite so there are many holes in my understanding.
The server is "hellcat"
The instance is "cohiba"
The user is "userA"
The password is "usera$dbo"
I installed pyodbc
benjy:pyodbc-2.1.8 msharp$ python setup.py build install
running build
running build_ext
building 'pyodbc' extension
creating build
creating build/temp.macosx-10.6-universal-2.6
...
Installed
/Library/Python/2.6/site-packages/pyodbc-2.1.8-py2.6-macosx-10.6-universal.egg
Processing dependencies for pyodbc==2.1.8
Finished processing dependencies for pyodbc==2.1.8
benjy:python msharp$ python
Python 2.6.1 (r261:67515, Feb 11 2010, 00:51:29)
[GCC 4.2.1 (Apple Inc. build 5646)] on darwin
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlalchemy
>>> sqlalchemy.__version__
'0.6.4'
>>> mssql_db =
>>> sqlalchemy.create_engine('mssql+pyodbc://userA:usera$...@[hellcat\cohiba]')
>>> # I have tried this with and without the brackets (that is,
>>> ......@hellcat\cohiba and ......@[hellcat\cohiba])
>>> connection = mssql_db.connect()
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File
"/Library/Python/2.6/site-packages/SQLAlchemy-0.6.4-py2.6.egg/sqlalchemy/engine/base.py",
line 1814, in connect
return self.Connection(self, **kwargs)
File
"/Library/Python/2.6/site-packages/SQLAlchemy-0.6.4-py2.6.egg/sqlalchemy/engine/base.py",
line 835, in __init__
self.__connection = connection or engine.raw_connection()
File
"/Library/Python/2.6/site-packages/SQLAlchemy-0.6.4-py2.6.egg/sqlalchemy/engine/base.py",
line 1877, in raw_connection
return self.pool.unique_connection()
File
"/Library/Python/2.6/site-packages/SQLAlchemy-0.6.4-py2.6.egg/sqlalchemy/pool.py",
line 143, in unique_connection
return _ConnectionFairy(self).checkout()
File
"/Library/Python/2.6/site-packages/SQLAlchemy-0.6.4-py2.6.egg/sqlalchemy/pool.py",
line 370, in __init__
rec = self._connection_record = pool.get()
File
"/Library/Python/2.6/site-packages/SQLAlchemy-0.6.4-py2.6.egg/sqlalchemy/pool.py",
line 214, in get
return self.do_get()
File
"/Library/Python/2.6/site-packages/SQLAlchemy-0.6.4-py2.6.egg/sqlalchemy/pool.py",
line 733, in do_get
con = self.create_connection()
File
"/Library/Python/2.6/site-packages/SQLAlchemy-0.6.4-py2.6.egg/sqlalchemy/pool.py",
line 148, in create_connection
return _ConnectionRecord(self)
File
"/Library/Python/2.6/site-packages/SQLAlchemy-0.6.4-py2.6.egg/sqlalchemy/pool.py",
line 254, in __init__
self.connection = self.__connect()
File
"/Library/Python/2.6/site-packages/SQLAlchemy-0.6.4-py2.6.egg/sqlalchemy/pool.py",
line 320, in __connect
connection = self.__pool._creator()
File
"/Library/Python/2.6/site-packages/SQLAlchemy-0.6.4-py2.6.egg/sqlalchemy/engine/strategies.py",
line 76, in connect
return dialect.connect(*cargs, **cparams)
File
"/Library/Python/2.6/site-packages/SQLAlchemy-0.6.4-py2.6.egg/sqlalchemy/engine/default.py",
line 249, in connect
return self.dbapi.connect(*cargs, **cparams)
sqlalchemy.exc.DBAPIError: (Error) ('IM002', '[IM002] [iODBC][Driver
Manager]Data source name not found and no default driver specified. Driver
could not be loaded (0) (SQLDriverConnectW)') None None
Mark Sharp
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@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.
