Example of Using SQLAlchemy to Connect to Microsoft SQL Server 2005 via Trusted Connections

[Keyton Weissinger]

Greetings all.

I'm new to sqlalchemy and would REALLY like to use it at my office.
I'm looking for examples and having a HECK of a time.
1. Running Python 2.5.2 on Windows XP.
2. Connecting to a local instance of SQL Server 2005.
3. Want to use **trusted connections** so others can run the script
without having to make changes.

Are there examples out there and I just can't find them? Does anyone
have any examples they can share?

I'm about to have to just bail and use straight pyodbc.

Thank you in advance!

Keyton

[Empty]

Hello,

On Tue, Dec 9, 2008 at 9:19 AM, Keyton Weissinger <key...@gmail.com> wrote:

Greetings all.

I'm new to sqlalchemy and would REALLY like to use it at my office.
I'm looking for examples and having a HECK of a time.
1. Running Python 2.5.2 on Windows XP.
2. Connecting to a local instance of SQL Server 2005.
3. Want to use **trusted connections** so others can run the script
without having to make changes.

Are there examples out there and I just can't find them? Does anyone
have any examples they can share?

Have you looked at the Database Notes on the wiki which covers this sort of thing?  http://www.sqlalchemy.org/trac/wiki/DatabaseNotes

Michael

[Keyton Weissinger]

Yep. Doesn't cover trusted connections, unfortunately.

[Michael Bayer]

how would you establish a trusted connection using straight pyodbc ?
SQLA's URL should allow any number of arguments straight through to
pyodbc, and if not, there are documented methods of giving the SQLA
engine a connection factory that does whatever is needed in order to
connect.