Re: [sqlalchemy] Sqlalchemy issue on Windows Server 2008 R2 sp1

2012-11-27 Thread David Moore
- Original Message - > Hi everyone, as the title says I'm trying to run sqlalchemy (pyodbc) > with SQL Server 2008 on Windows Server 2008 R2 sp1 but I'm failing > with the database connection. Here is a small script I'm using to > test the connection: > from sqlalchemy import * > from sql

Re: [sqlalchemy] Sqlalchemy issue on Windows Server 2008 R2 sp1

2012-11-27 Thread Michael Bayer
I'd first recommend creating a real ODBC datasource, since that's how ODBC is meant to be used. Then you can try connecting to it using ODBC test tools (such as on my Mac here, I have a program called "iodbctest" which tests an ODBC datasource) and then perhaps creating a plain pyodbc connecti

[sqlalchemy] Sqlalchemy issue on Windows Server 2008 R2 sp1

2012-11-27 Thread Massi
Hi everyone, as the title says I'm trying to run sqlalchemy (pyodbc) with SQL Server 2008 on Windows Server 2008 R2 sp1 but I'm failing with the database connection. Here is a small script I'm using to test the connection: from sqlalchemy import * from sqlalchemy.engine import reflection url =