[sqlalchemy] Re: Connecting to MSSQL with a System DSN on Windows

2008-01-17 Thread Vinay Sajip
On Jan 17, 5:59 pm, Paul Johnston <[EMAIL PROTECTED]> wrote: > Hi, > > >For some reason it didn't work for me (sqlalchemy 0.4.2p3). I tried > >mssql://?dsn=MyDSN, and also mssql://?DSN=MyDSN. Oh well. > > Sorry, it's > mssql:///?dsn=mydsn > > This definitely works, just tested it > >>> eng = sq

[sqlalchemy] Re: Connecting to MSSQL with a System DSN on Windows

2008-01-17 Thread Paul Johnston
Hi, >For some reason it didn't work for me (sqlalchemy 0.4.2p3). I tried >mssql://?dsn=MyDSN, and also mssql://?DSN=MyDSN. Oh well. > > Sorry, it's mssql:///?dsn=mydsn This definitely works, just tested it >>> eng = sqlalchemy.create_engine('mssql:///?dsn=bob') >>> eng.execute('select 1')

[sqlalchemy] Re: Connecting to MSSQL with a System DSN on Windows

2008-01-17 Thread Vinay Sajip
On Jan 16, 7:38 pm, Paul Johnston <[EMAIL PROTECTED]> wrote: > Hi, > > >'mssql://DSN=MyDSN'. How can I get this to work without specifying > > You were nearly there... > mssql://?dsn=mydsn > > Paul Thanks, Paul, For some reason it didn't work for me (sqlalchemy 0.4.2p3). I tried mssql://?dsn=M

[sqlalchemy] Re: Connecting to MSSQL with a System DSN on Windows

2008-01-16 Thread Paul Johnston
Hi, >'mssql://DSN=MyDSN'. How can I get this to work without specifying > > You were nearly there... mssql://?dsn=mydsn Paul --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this gro

[sqlalchemy] Re: Connecting to MSSQL with a System DSN on Windows [Solved]

2008-01-16 Thread Vinay Sajip
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 us