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 sqlalchemy@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---