In addition to the previous email, pyodbc is also required.
Otherwise,
sqlalchemy will not extract data from MS SQL sever 2005.
On Dec 30, 9:42 am, Ning <station.n...@gmail.com> wrote:
> thank you so much. I have changed sql2005 to msql. then, it works
> perfectly now.
>
> many thanks again.
>
> Ning
>
> On Dec 29, 3:45 pm, "Michael Trier" <mtr...@gmail.com> wrote:
>
> > Hi,
>
> > On Mon, Dec 29, 2008 at 7:19 AM, Ning <station.n...@gmail.com> wrote:
>
> > > 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''')
>
> > The syntax is "mssql://user:passw...@host/database"
>
> > See here for more
> > info:http://www.sqlalchemy.org/trac/wiki/DatabaseNotes#MS-SQL
>
> > Michael
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
