[sqlalchemy] Re: Firebird backend
Hello, Lele Gaifax said the following on 01.04.2007 2:36: I checked and the role argument is correctly seen by the FB backend, and your script works for me *when* accessing the database as LELE, but effectively not when using SYSDBA, *if* with fails you mean that you get NONE as result. No, I mean - I've got exception when executing that code with the new backend: http://paste.turbogears.org/paste/1177 And... I'm ashtonished to ear that it does work for you, with the pristine backend. It may very well be me misunderstanding the roles, as I never used them. Do they work when connecting as SYSDBA? Yes they work, but it is not crucial here. I just use this as example because SELECT CURRENT_ROLE FROM RDB$DATABASE is the first SQL statement in my program and it doesn't work with the new backend ;-) -- Oleg --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Re: Firebird backend
Oleg Deribas wrote: No, I mean - I've got exception when executing that code with the new backend: http://paste.turbogears.org/paste/1177 Uhm, this is really strange: the backend is involvend only marginally in your example as the traceback shows, I thought it was a problem of applying all the arguments coming down from the URL to the actual connection... I see that you are on Windows, using Python 2.5, and SA 0.3.6. I cannot retry the exact combination, but will try with the latest two on GNU/Linux. Any chance for you to try out the current trunk of SA? That's what I Do they work when connecting as SYSDBA? Yes they work, but it is not crucial here. Ok, I see: even SYSDBA needs an explicit grant to use the ROLE... ciao, lele. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Re: Firebird backend
Oleg Deribas wrote: Hello, Lele Gaifax said the following on 19.03.2007 17:03: Since I'd be very sad knowing I'm breaking someone else project, I'd like to hear a voice from some other FB user, before asking Michael to accept this work. Here is simple code which works with the stock backend and fails with the new: http://paste.turbogears.org/paste/1138 Sorry for the late answer, but see http://rafb.net/p/dv4lIn88.html and http://rafb.net/p/MkgNud70.html I checked and the role argument is correctly seen by the FB backend, and your script works for me *when* accessing the database as LELE, but effectively not when using SYSDBA, *if* with fails you mean that you get NONE as result. And... I'm ashtonished to ear that it does work for you, with the pristine backend. It may very well be me misunderstanding the roles, as I never used them. Do they work when connecting as SYSDBA? Thank you, bye, lele. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---