[IronPython] [ANN]: IronPython 2.6 Beta 2

Dino Viehland dinov at microsoft.com
Wed Aug 12 00:11:50 CEST 2009


Awesome, thanks!  I've found and I believe I have a fix for the import issue - it was a regression from fixing
bug 20174.    Now I'll take a look at this :)

From: users-bounces at lists.ironpython.com [mailto:users-bounces at lists.ironpython.com] On Behalf Of Vernon Cole
Sent: Tuesday, August 11, 2009 2:53 PM
To: Discussion of IronPython
Subject: Re: [IronPython] [ANN]: IronPython 2.6 Beta 2

Dino:
  Here is the repo. You were using ADODB.RecordSet. This is ADODB.Command.
<Python>
"""exercise BINARY field bug"""

_computername=".\SQLexpress" #or name of computer with SQL Server
_databasename="Northwind" #or something else

constr = r"Initial Catalog=%s; Data Source=%s; Provider=SQLOLEDB.1; Integrated Security=SSPI" \
                 %(_databasename, _computername)

import System

conn = System.Activator.CreateInstance(System.Type.GetTypeFromProgID("ADODB.Connection"))

connstr = constr #"driver={SQL Server};Server=localhost;Database=mydatabase;Initial Catalog=mydatabase;Trusted_Connection=True;"

conn.ConnectionString = connstr

conn.Open()

operation = "INSERT INTO Table_1 (Test1) VALUES (?)"
b = buffer('\x02\x03\x04\x05')
print 'b=',repr(b)

cmd = System.Activator.CreateInstance(System.Type.GetTypeFromProgID("ADODB.Command"))
cmd.ActiveConnection=conn
cmd.CommandText=operation
cmd.CommandType=1 #adCmdText

cmd.Parameters.Refresh()
p = cmd.Parameters.Item[0]

p.AppendChunk(b)  # this is the error line

ra = System.Reference[int]()
rs = cmd.Execute(ra)
count = ra.Value
print 'Returned rowcount=',count
</code>
--
Vernon
On Mon, Aug 3, 2009 at 5:33 PM, Dino Viehland <dinov at microsoft.com<mailto: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> [mailto: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<http://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<mailto: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/0dda593a/attachment.html>


More information about the Ironpython-users mailing list