Hi all, I am pretty new for using sqlalcemy. I am able to connect postgre database, but we recently moved data from postgre to SQL sever 2005.
I have tried to connect sql sever 2005 as following: DB = sqlalchemy.create_engine('''sql2005://user_name:passw...@server/ database''') Then, i got error message as following in python Z:\Scripts\OperationalProcesses\Forecasts\<ipython console> in <module> () C:\PythonXY\python\lib\site-packages\sqlalchemy\engine\__init__.pyc in create_engine(*args, **kwargs) 150 """ 151 152 strategy = kwargs.pop('strategy', default_strategy) 153 strategy = strategies.strategies[strategy] --> 154 return strategy.create(*args, **kwargs) C:\PythonXY\python\lib\site-packages\sqlalchemy\engine\strategies.pyc in create(self, name_or_url, **kwargs) 42 u = url.make_url(name_or_url) 43 ---> 44 dialect_cls = u.get_dialect() 45 46 dialect_args = {} C:\PythonXY\python\lib\site-packages\sqlalchemy\engine\url.pyc in get_dialect(self) 90 if dialect is not None: 91 return dialect ---> 92 raise ImportError('unknown database %r' % self.drivername) 93 94 def translate_connect_args(self, names): ImportError: unknown database 'sql2005' It will be so thankful, if there is any one could help! Many thanks! Ning --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. 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 -~----------~----~----~----~------~----~------~--~---