[IronPython] MySQL and Iron Python

[Vernon Cole]

Field name access is the next development step. The API calls for position
(field number) access. Field name access is an extension. I personally think
that it is the obvious thing to do, but the movers and shakers of the
database API don't see it the same way.  My big goal is to add that feature.
I implemented name access for (input) parameters in the last revision.
(paramstyle='named').  So for today, you must use column position to read
the data.
--
Vernon

On Tue, Jul 20, 2010 at 1:12 PM, Ian Hobson <ian at ianhobson.co.uk> wrote:

>  Thanks Vernon,
>
> With your help I now have some data!
>
> Now to find out if I can access it by field name and not just position.
>
> Thanks again
>
> Ian
>
>
> On 20/07/2010 19:32, Vernon Cole wrote:
>
> You need to supply a "Driver" for each dialect of SQL you use. The
> Microsoft drivers (SQL server and JET) ship with Windows, but you have to
> hunt for the others. For my testing, I use the "MySQL ODBC 5.1 Driver".
> You can find it at http://dev.mysql.com/downloads/connector/odbc/5.1.html
>
> Also, http://www.connectionstrings.com/ will shed more light on the black
> magic of creating a working connection string.
> --
> Vernon
>
> On Tue, Jul 20, 2010 at 12:16 PM, Ian Hobson <ian at ianhobson.co.uk> wrote:
>
>>     ...Testing MySql login...
>> (-2147352567, 'Exception occurred.', (0, u'Microsoft OLE DB Provider for
>> ODBC Dr
>> ivers', u'[Microsoft][ODBC Driver Manager] Data source name not found and
>> no def
>> ault driver specified', None, 0, -2147467259), None)
>>  Unit tests for adodbapi version 2.3.0
>> Default Date Converter is <adodbapi.pythonDateTimeConverter object at
>> 0x023D7610
>>
>> >
>>
>>
>> On 20/07/2010 19:05, Vernon Cole wrote:
>>
>>  I use MySQL as one of the basic tests for adodbapi, so I can say that it
>> works pretty well for me.
>> What obstacle do you hit?
>> --
>> Vernon Cole
>>
>> On Tue, Jul 20, 2010 at 11:52 AM, Ian Hobson <ian at ianhobson.co.uk> wrote:
>>
>>> Hi all,
>>>
>>> How can I (a nube) read a MySQL database using Iron Python? (windows 7
>>> and 2008 Server).
>>>
>>> Any method will do, so long as it works. :)
>>>
>>> I've tried adodbapi and mysqldb and mysqlconnector - and always hit an
>>> obstacle I can't get round.
>>>
>>> Regards
>>>
>>> Ian
>>>
>>>
>>> _______________________________________________
>>> Users mailing list
>>> Users at lists.ironpython.com
>>> http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
>>>
>>
>>
>> _______________________________________________
>> Users mailing listUsers at lists.ironpython.comhttp://lists.ironpython.com/listinfo.cgi/users-ironpython.com
>>
>>
>>
>> No virus found in this incoming message.
>> Checked by AVG - www.avg.com
>> Version: 9.0.839 / Virus Database: 271.1.1/3017 - Release Date: 07/20/10 07:36:00
>>
>>
>>
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.ironpython.com
>> http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
>>
>>
>
> _______________________________________________
> Users mailing listUsers at lists.ironpython.comhttp://lists.ironpython.com/listinfo.cgi/users-ironpython.com
>
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 9.0.839 / Virus Database: 271.1.1/3017 - Release Date: 07/20/10 07:36:00
>
>
>
>
>
> _______________________________________________
> 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/20100720/81c5e1ff/attachment.html>