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
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
