[sqlalchemy] Re: SQLAlch. + ODBC + DBISAM... :-(

2007-05-01 Thread Paul Johnston
Hi, I've found SA/MSSQL is mostly stable now. I do have a few bugs outstanding, and I'm sure I'll need to dive into the source code again in the future, but it's comparably stable to the rest of SA. The unit test failures are right down, at least on Windows. I haven't tested PyODBC on other

[sqlalchemy] Re: SQLAlch. + ODBC + DBISAM... :-(

2007-05-01 Thread Rick Morrison
The 0.3.7 bug is my fault, I checked in the changes without testing on pyodbc. Didn't know that Mike would cut 0.3.7 the very next day! Guess I'll get to use that buildslave for something after all... Paul, I wasn't aware of scope_identity() not working on pyodbc, I checked it in because it was

[sqlalchemy] Re: SQLAlch. + ODBC + DBISAM... :-(

2007-05-01 Thread Rick Morrison
Good to hear that adodbapi is going to get some loving. Here's a brain dump on Unix + ODBC: There are a lot of commercial UNIX ODBC interfaces of varying quality out there; I'm not familiar with any of them. As usual with open source, there's not one but two options for free ODBC software,

[sqlalchemy] Re: SQLAlch. + ODBC + DBISAM... :-(

2007-04-27 Thread Rick Morrison
I'd be happy to host a buildslave here on a VM. AFAIK, the buildslaves connect outbound to the master, which would work for me. As far as hosting the master, I dunno -- we're out here in the hinterlands of Connecticut in dynamic IP address land for now. On 4/27/07, Michael Bayer [EMAIL

[sqlalchemy] Re: SQLAlch. + ODBC + DBISAM... :-(

2007-04-26 Thread Michael Bayer
mssql:// supports pyodbc. On Apr 26, 2007, at 5:35 AM, durumdara wrote: Hi! I want to subst. my modpy webframework to Pylons. I want use ORM in DB handling. But we used DBISAM in our projects, and now we access tables via ODBC and pyodbc. I don't see any odbc database engine in

[sqlalchemy] Re: SQLAlch. + ODBC + DBISAM... :-(

2007-04-26 Thread Durumdara
Hi! 2007/4/26, Michael Bayer [EMAIL PROTECTED]: mssql:// supports pyodbc. And how to I open the engine? (XXX is the name of the ODBC DataSource what I want to open. It is DBISAM database). from sqlalchemy import * import pyodbc db = create_engine('mssql://zeusweb', module=pyodbc) The

[sqlalchemy] Re: SQLAlch. + ODBC + DBISAM... :-(

2007-04-26 Thread Michael Bayer
On Apr 26, 2007, at 9:35 AM, Durumdara wrote: Hi! 2007/4/26, Michael Bayer [EMAIL PROTECTED]: mssql:// supports pyodbc. And how to I open the engine? (XXX is the name of the ODBC DataSource what I want to open. It is DBISAM database). from sqlalchemy import * import pyodbc db =

[sqlalchemy] Re: SQLAlch. + ODBC + DBISAM... :-(

2007-04-26 Thread Rick Morrison
.3.6 was stable (at least for me). One of the issues to address is going to be the multi-DBAPI support. Keeping all three stable at the same time can be tough. So starting .3.7, making pyodbc the only supported configuration is OK with me, although I'll keep pymssql up and running for the next

[sqlalchemy] Re: SQLAlch. + ODBC + DBISAM... :-(

2007-04-26 Thread Michael Bayer
On Apr 26, 2007, at 6:15 PM, Rick Morrison wrote: .3.6 was stable (at least for me). One of the issues to address is going to be the multi-DBAPI support. Keeping all three stable at the same time can be tough. So starting .3.7, making pyodbc the only supported configuration is OK

[sqlalchemy] Re: SQLAlch. + ODBC + DBISAM... :-(

2007-04-26 Thread Rick Morrison
Sounds like a great idea -- is there an existing buildbot master to tie into, or will the whole thing be new? On 4/26/07, Michael Bayer [EMAIL PROTECTED] wrote: On Apr 26, 2007, at 6:15 PM, Rick Morrison wrote: .3.6 was stable (at least for me). One of the issues to address is going