[sqlalchemy] Re: Read only connection with Table reflection

2007-08-29 Thread shday
Is there any way to use reflection with a read only connection? I use reflection on an Oracle database with read only permission, no problems (using SA 0.3.8). I don't recall seeing SA trying to do a ROLLBACK during reflection though. Steve

[sqlalchemy] Re: Read only connection with Table reflection

2007-08-29 Thread Michael Bayer
On Aug 29, 2007, at 1:55 PM, Jason Koelker wrote: I am attempting to use SQLAlchemy's table reflection to access a MSSQL 2k database. However the user I can connect with only had db_datareader access. When SQLAlchemy tries to load the schema, it attempts a rollback at the end, which the

[sqlalchemy] Re: Read only connection with Table reflection

2007-08-29 Thread Jason Koelker
On Aug 29, 7:27 pm, Michael Bayer [EMAIL PROTECTED] wrote: On Aug 29, 2007, at 1:55 PM, Jason Koelker wrote: I am attempting to use SQLAlchemy's table reflection to access a MSSQL 2k database. However the user I can connect with only had db_datareader access. When SQLAlchemy tries to