On Tue, Apr 1, 2008 at 10:09 AM, Lukasz Szybalski <[EMAIL PROTECTED]> wrote:
> On Tue, Apr 1, 2008 at 9:26 AM, Rick Morrison <[EMAIL PROTECTED]> wrote:
> >
> >
> > > or sqlalchemy connection string will have to provide some way to add a
> > > driver name to connection string.
> > >
> > >
> > > sqlalchemy.create_engine('mssql://user:[EMAIL
> PROTECTED]:1433/?driver=TDS')
> > >
> >
> > That capability, with that very keyword, is in SVN trunk, part of the last
> > round of changes. BTW, this string is malformed: it's missing a database
> > name.
> >
> >
> >
> > > 2. Could you add unixODBC instructions to sqlalchemy docs, namely:
> > > a)Required: pyodbc, unixodbc, tdsodbc
> > > b)sqlalchemy.create_engine('mssql://user:[EMAIL
> PROTECTED]:1433/?driver=TDS')
> > >
> >
> > It would be better if you yourself would submit some text that you'd like
> to
> > see here. After just having gone through the configuration procedure, you
> > are just as qualified as anyone to describe the process. I'd be happy to
> > review anything submitted.
>
> Under:
> http://www.sqlalchemy.org/docs/04/documentation.html#dbengine_establishing
>
> after:
> "# oracle will feed host/port/SID into cx_oracle.makedsn
> oracle_db = create_engine('oracle://scott:[EMAIL PROTECTED]:1521/sidname')"
>
> add:
> #mssql connection string. (On Linux using unixODBC you will have to
> provide a driver name, on Windows driver name defaults to 'SQL Server'
> )
> mssql_db=create_engine('mssql://user:[EMAIL
> PROTECTED]:1433/mydatabase?driver=TDS')
>
>
> I would also fix the mysql line from:
> # mysql
> mysql_db = create_engine('mysql://localhost/foo')
>
> to
> # mysql connection string
> mysql_db = create_engine('mysql://user:[EMAIL PROTECTED]/mydatabase')
>
> Lucas
>
I guess my last question is how do I use sqlalchemy now? Is there a
release that is coming out soon that would include unixodbc support or
should I use svn? If I use svn how do I know it works?
Should I wait until these changes are in some branch? and chek out that branch?
Lucas
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
