On 16 Jan, 18:10, Vinay Sajip <[EMAIL PROTECTED]> wrote:
> 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.
>
Problem solved. I had to use r'machinename\sqlexpress' as the host
because it's an embedded version of MSSQL. Sorry for the noise.
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
-~----------~----~----~----~------~----~------~--~---
