On Dec 23, 11:42 am, Michael Bayer <[email protected]> wrote:
>
> If you want to see exactly what gets passed:
>
> python>>> from sqlalchemy.engine.url import make_url
> >>> from sqlalchemy.connectors import pyodbc
> >>> pyodbc.PyODBCConnector().create_connect_args(make_url("mssql+pyodbc://Defau
> >>> lt"))
>
> [['dsn=Default;Trusted_Connection=Yes'], {}]
>
> There's a difference between your two tests in that one has
> username/password, the other not.
thanks a bunch..
>>> pyodbc.PyODBCConnector().create_connect_args(make_url("mssql+pyodbc://myid:m...@default"))
[['dsn=Default;UID=myid;PWD=mypw'], {}]
this is what we expect, add the database to it..
>>>pyodbc.PyODBCConnector().create_connect_args(make_url("mssql+pyodbc://myid:m...@default/databasename"))
[['DRIVER={None};Server=Default;Database=databasename;UID=myid;PWD=mypw'],
{}]
driver is now gone!!
passing the database in via URL options/parameter syntax, we get what
we expect..
>>> pyodbc.PyODBCConnector().create_connect_args(make_url("mssql+pyodbc://myid:m...@default?database=databasename"))
[['dsn=Default?Database=databasename;UID=myid;PWD=mypw'], {}]
wish I posted this last week!
fyi,
>>> import sqlalchemy
>>> sqlalchemy.__version__
'0.6.4'
thanks
--
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.
