[sqlalchemy] Re: SA and pyodbc connections

2007-06-08 Thread Paul Johnston
Hi, For me, at least, solid and passes all tests are not necessarily the same thing This depends somewhat on your definition of solid. In terms of volumns, I think you're absolutely right, if your basic operation works, you can process millions of rows and it doesn't matter that other

[sqlalchemy] Re: SA and pyodbc connections

2007-06-07 Thread scurra
On 7 Jun, 00:00, Paul Johnston [EMAIL PROTECTED] wrote: Hi, If you could mail the output off list to both myself and Rick Morrison, that would be magic. Well, the summary is: FAILED (failures=20, errors=245) Looks like making this solid on Unix would be a mammoth task. Not one I'm

[sqlalchemy] Re: SA and pyodbc connections

2007-06-07 Thread Paul Johnston
Hi, I am no ODBC expert but I suspect that the problem with connecting Un*x to SQL Server has to do with the limitations of the Un*x odbc drivers. Yes, this is likely. Still on the issue of unicode support, FreeTDS does claim to support utf-8, so I'd be hopeful that it could be made to work,

[sqlalchemy] Re: SA and pyodbc connections

2007-06-07 Thread Rick Morrison
pymssql does better, but as the underlying dbLib does not support unicode, most of the unicode-based unit tests fail. For me, at least, solid and passes all tests are not necessarily the same thing The issue I think likes more with the test suite than with MSSQL or any of its connectors, and

[sqlalchemy] Re: SA and pyodbc connections

2007-06-06 Thread scurra
Hi Paul Thanks for the advice. I have checked out the subversion SQLAlchemy, made the change to mssql.py, and run the unit tests. 648c648 connectors = [Driver={SQL Server}] --- connectors = [DRIVER={}] src/sqlalchemy$ python test/alltests.py --dburi='mssql:// ryant:[EMAIL

[sqlalchemy] Re: SA and pyodbc connections

2007-06-06 Thread Rick Morrison
I'm interested in the results too, as well as the ODBC config. I'm still in the process of setting up a buildbot slave on Ubuntu that's going to be running pyodbc as well. I normally use pymssql, and it'll be my first serious go with pyodbc. If it's OK with the list, maybe you can post the

[sqlalchemy] Re: SA and pyodbc connections

2007-06-06 Thread Paul Johnston
Hi, src/sqlalchemy$ python test/alltests.py --dburi='mssql:// ryant:[EMAIL PROTECTED]/testdb' --verbose --coverage | tee -a sqlaut.log Try this command line: python test/alltests.py --dburi='mssql://ryant:[EMAIL PROTECTED]/testdb?text_as_varchar=1' sqlaut.log 21 If you could mail the

[sqlalchemy] Re: SA and pyodbc connections

2007-06-06 Thread scurra
Hi Paul src/sqlalchemy$ python test/alltests.py --dburi='mssql:// ryant:[EMAIL PROTECTED]/testdb' --verbose --coverage | tee -a sqlaut.log Try this command line: python test/alltests.py --dburi='mssql://ryant:[EMAIL PROTECTED]/testdb?text_as_varchar=1' sqlaut.log 21 If you could mail