I'm attempting to code up a simple Teradata dialect for SQLAlchemy but am getting a curious error complaining of "No module named pyodbc" when I attempt to do a create_engine on my Windows box. I'm running on Windows 7 (32-bit), with stock Python 2.7 from the Python website and SQLA 0.9.8 and pyODBC 3.0.7.
PyODBC otherwise works fine otherwise in other tests from Python, but fails when SQLAlchemy attempts to __import__ it for some reason. I've found several posts regarding this issue for IronPython and other non-stock Windows Pythons but nothing that is glaringly obvious as to what is wrong with my relatively standard setup. I'll include the custom dialect files if anyone wants to try it themselves. The nose tests also appear to fail with this error. <snip> *# both libs appear to be local to each other's Python site-packages dir* In [10]: import sqlalchemy In [11]: print sqlalchemy.__file__ C:\Python27\lib\site-packages\sqlalchemy\__init__.pyc In [12]: import pyodbc In [13]: print pyodbc.__file__ C:\Python27\lib\site-packages\pyodbc.pyd *# pyodbc appears to work* In [15]: conn = pyodbc.connect('dsn=td_tms_user') In [16]: conn.execute('select current_timestamp').fetchone() Out[16]: (datetime.datetime(2015, 1, 3, 21, 12, 21, 100000), ) *# loading my custom dialect fails though* In [17]: from sqlalchemy.dialects import registry In [18]: registry.register("teradata.pyodbc", "sqlalchemy_teradata.pyodbc", "teradataDialect_pyodbc") In [19]: engine = create_engine('teradata+pyodbc://tms_user:password@td_tms_user') --------------------------------------------------------------------------- ImportError Traceback (most recent call last) <ipython-input-19-36d09e5c6713> in <module>() ----> 1 engine = create_engine('teradata+pyodbc://tms_user:password@td_tms_user') C:\Python27\lib\site-packages\sqlalchemy\engine\__init__.pyc in create_engine(*args, **kwargs) 360 strategy = kwargs.pop('strategy', default_strategy) 361 strategy = strategies.strategies[strategy] --> 362 return strategy.create(*args, **kwargs) 363 364 C:\Python27\lib\site-packages\sqlalchemy\engine\strategies.pyc in create(self, name_or_url, **kwargs) 49 u = url.make_url(name_or_url) 50 ---> 51 dialect_cls = u.get_dialect() 52 53 if kwargs.pop('_coerce_config', False): C:\Python27\lib\site-packages\sqlalchemy\engine\url.pyc in get_dialect(self) 127 else: 128 name = self.drivername.replace('+', '.') --> 129 cls = registry.load(name) 130 # check for legacy dialects that 131 # would return a module with 'dialect' as the C:\Python27\lib\site-packages\sqlalchemy\util\langhelpers.pyc in load(self, name) 172 def load(self, name): 173 if name in self.impls: --> 174 return self.impls[name]() 175 176 if self.auto_fn: C:\Python27\lib\site-packages\sqlalchemy\util\langhelpers.pyc in load() 196 def register(self, name, modulepath, objname): 197 def load(): --> 198 mod = compat.import_(modulepath) 199 for token in modulepath.split(".")[1:]: 200 mod = getattr(mod, token) C:\Python27\lib\site-packages\sqlalchemy\util\compat.pyc in import_(*args) 138 if len(args) == 4: 139 args = args[0:3] + ([str(arg) for arg in args[3]],) --> 140 return __import__(*args) 141 142 callable = callable *ImportError: No module named pyodbc* </snip> -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
sqlatd.tgz
Description: GNU Unix tar archive