I have a Windows setup in which I need to use Integrated
Authentication with pyodbc and MSSQL. I have set up a System DSN using
the Control Panel and pyodbc connects OK using this DSN - I can run
queries etc. without problems. I use the connection string 'DSN=MyDSN'
for pyodbc, where MyDSN is the System DSN I have set up.
However, this doesn't work if I pass it to create_engine() - e.g.
'mssql://DSN=MyDSN'. How can I get this to work without specifying
username, password or database in the URL?
Sorry if this has come up before. I saw an earlier (Sep 2007) thread
which seems to imply that you have to the username & password in the
URL, and an earlier (June 2007) thread about using Driver={} on Unix.
Is there an easy way to just pass the pyodbc connection to SQLAlchemy?
I couldn't spot anything obvious in the docs.
Thanks in advance,
Vinay Sajip
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
