[IronPython] [ANN]: IronPython 2.6 Beta 2
Vernon Cole
vernondcole at gmail.com
Tue Aug 11 21:04:45 CEST 2009
I have filed Codeplex Item # 24272 on this issue. I hope it makes sense --
I had been up way too many hours when I pushed the "send" button.
--
Vernon
On Tue, Aug 11, 2009 at 2:54 AM, Vernon Cole <vernondcole at gmail.com> wrote:
> No. The setup for the test script fiddles with os.path, but adodbapi itself
> makes no changes to sys.modules nor os.path.
>
>
>
> On Mon, Aug 10, 2009 at 5:29 PM, Dino Viehland <dinov at microsoft.com>wrote:
>
>> Does adodbapi publish something into sys.modules under the name adodbapi
>> during import?
>>
>>
>>
>> *From:* users-bounces at lists.ironpython.com [mailto:
>> users-bounces at lists.ironpython.com] *On Behalf Of *Vernon Cole
>> *Sent:* Monday, August 10, 2009 4:21 PM
>>
>> *To:* Discussion of IronPython
>> *Subject:* Re: [IronPython] [ANN]: IronPython 2.6 Beta 2
>>
>>
>>
>> Sorry to be slow getting back... I'm on vacation.
>> In attempting to make a test case as you have requested, I suddenly run in
>> to the following problem:
>>
>> <console dump>
>> C:\temp>ipy ipy_bug.py
>>
>> C:\temp>"c:\program files\Ironpython 2.0.2\ipy.exe" ipy_bug.py
>> version= adodbapi v2.2.7a1
>> Executing the command: "select * from Products"
>> result rowcount shows as= 6. (Note: -1 means "not known")
>>
>> result data description is:
>> NAME TypeCd DispSize IntrnlSz Prec Scale Null?
>> ItemNumber 3 4 4 10 255 1
>> ItemName 202 12 50 255 255 1
>> UnitsOnHand 4 4 4 7 255 1
>> CostPerUnit 131 19 19 14 4 1
>> LastOrdered 7 8 8 255 255 1
>>
>> result first ten records are:
>> (1, 'Widgit', 5.0, Decimal("15.1234"), datetime.datetime(2009, 1, 29, 13,
>> 5, 30)
>> )
>> (2, 'Thingamajig, Standard', 505.0, Decimal("0.1000"),
>> datetime.datetime(2009, 1
>> , 29, 15, 5, 19))
>> (3, 'Left Handed Smoke Shifter', 1.0, Decimal("1000000.0000"),
>> datetime.datetime
>> (2008, 4, 1, 12, 0))
>> (4, 'Gravel (Bulk)', 100.25, Decimal("32.4567"), datetime.datetime(2009,
>> 1, 29,
>> 13, 5, 31))
>> (5, 'Tube, Drinking, Plastic, For cold liquids', 500000.0,
>> Decimal("0.0013"), da
>> tetime.datetime(2009, 1, 29, 13, 5, 32))
>> (6, 'Annoy-A-Tron', 1.0, Decimal("12.9500"), datetime.datetime(2009, 1,
>> 29, 13,
>> 5, 33))
>>
>> C:\temp>ipy26 ipy_bug.py
>>
>> C:\temp>"c:\program files\Ironpython 2.6\ipy.exe" ipy_bug.py
>> version= adodbapi v2.2.7a1
>> Traceback (most recent call last):
>> File "ipy_bug.py", line 52, in ipy_bug.py
>> AttributeError: 'module' object has no attribute 'adodbapi'
>> </console dump>
>>
>> The offending line is:
>> adodbapi.adodbapi.defaultIsolationLevel = adodbapi.adXactBrowse
>>
>> I never have understood why it was necessary to use the
>> adodbapi.adodbapi.(whatever) construct, but smarter people than me said that
>> was necessary, and they are correct. If the redundant-looking entry is not
>> used, the programs runs without an error message, but does not actually
>> perform the intended function. If, for example, the line
>> adodbapi.adodbapi.defaultCursorLocation = adodbapi.adUseClient
>> is changed to
>> adodbapi.defaultCursorLocation = adodbapi.adUseClient
>> then the program will run, but the rowcount will return as -1, rather than
>> 6, because the cursor is not actually changed to a local cursor.
>>
>> So, to make a long story short: some change in IPy 2.6 has broken a needed
>> (if ugly looking) feature in adodbapi.
>> I will file a bug in codeplex as soon as I can isolate a good example.
>> --
>> Vernon
>>
>>
>>
>> On Mon, Aug 3, 2009 at 5:33 PM, Dino Viehland <dinov at microsoft.com>
>> wrote:
>>
>> Ok, I’ve finally got SQL server setup in a reasonable state where I can
>> try and repro this. This is what I’m trying to do. I have a database
>> called “mydatabase” which contains a table “Table_1” which contains 1 column
>> of type binary(4). I then attempt to do:
>>
>>
>>
>> import System
>>
>> conn =
>> System.Activator.CreateInstance(System.Type.GetTypeFromProgID("ADODB.Connection"))
>>
>> connstr = "driver={SQL
>> Server};Server=localhost;Database=mydatabase;Initial
>> Catalog=mydatabase;Trusted_Connection=True;"
>>
>> conn.ConnectionString = connstr
>>
>> conn.Open()
>>
>>
>>
>> rs =
>> System.Activator.CreateInstance(System.Type.GetTypeFromProgID("ADODB.RecordSet"))
>>
>> rs.Open("Table_2", conn, 1, 2, 2) # source, active connection, cursor
>> type (adOpenKeyset), lock type (adLockPessimistic), CommmandType
>> (adCmdTable)
>>
>> rs.AddNew()
>>
>> b = System.Array[System.Byte]((2,3,4,5))
>>
>> x = rs['Test1']
>>
>> x.AppendChunk(b)
>>
>>
>>
>> which fails with:
>>
>>
>>
>> EnvironmentError: System.Runtime.InteropServices.COMException
>> (0x800A0C93): Operation is not allowed in this context.
>>
>>
>>
>> This is the same failure I get if I use Shri’s proposed work around. Do
>> you have any idea of what I’m doing wrong or any suggestions on how to tweak
>> this to get the correct simple repro?
>>
>>
>>
>> *From:* users-bounces at lists.ironpython.com [mailto:
>> users-bounces at lists.ironpython.com] *On Behalf Of *Vernon Cole
>> *Sent:* Thursday, July 23, 2009 10:11 PM
>> *To:* Discussion of IronPython
>> *Subject:* Re: [IronPython] [ANN]: IronPython 2.6 Beta 2
>>
>>
>>
>> Guys:
>> Good work on the new release, and the 215 bug fixes. As usual, as soon
>> as the new beta was announced I downloaded and tested it.
>>
>> Somehow I got the idea that the adodbapi test had been included in the
>> IronPython test suite. Did you only include the tests that already pass?
>> Issue 18222 is still unfixed -- so adodbapi still fails, and you still
>> cannot pass a read-only buffer as a COM parameter.
>>
>> I realize that no one has voted up this rather obscure bug. Perhaps if it
>> were titled "fully support DB API 2.0 compliant database access using ADO"
>> it would have gotten more votes. Nevertheless, this issue has been
>> outstanding for 11 months, and is the only remaining failure in adodbapi for
>> versions 2.3 thru 3.1 of python. Please try to get to it before 2.6 final.
>>
>> Please !!!???
>> --
>> Vernon Cole
>>
>> P.S. -- I plan to make a version of adodbapi which uses real ADO.NET,
>> rather than ADO via COM, but I want the current version to be solid before I
>> start mucking it up.
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.ironpython.com
>> http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
>>
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.ironpython.com
>> http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/ironpython-users/attachments/20090811/7a97d5cd/attachment.html>
More information about the Ironpython-users
mailing list