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 [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
