python - SqlAlchemy equivalent of pyodbc connect string using FreeTDS -

the following works:

import pyodbc pyodbc.connect('driver={freetds};server=my.db.server;database=mydb;uid=myuser;pwd=mypwd;tds_version=8.0;port=1433;') 

the following fails:

import sqlalchemy sqlalchemy.create_engine("mssql://myuser:mypwd@my.db.server:1433/mydb?driver=freetds& odbc_options='tds_version=8.0'").connect() 

the error message above is:

dbapierror: (error) ('08001', '[08001] [unixodbc][freetds][sql server]unable connect data source (0) (sqldriverconnectw)') none none

can please point me in right direction? there way can tell sqlalchemy pass specific connect string through pyodbc?

please note: want keep dsn-less.

the example @singletoned not work me sqlalchemy 0.7.2. sqlalchemy docs connecting sql server:

if require connection string outside options presented above, use odbc_connect keyword pass in urlencoded connection string. gets passed in urldecoded , passed directly.

so make work used:

import urllib quoted = urllib.quote_plus('driver={freetds};server=my.db.server;database=mydb;uid=myuser;pwd=mypwd;tds_version=8.0;port=1433;') sqlalchemy.create_engine('mssql+pyodbc:///?odbc_connect={}'.format(quoted)) 

this should apply sybase well.