[IronPython] MySQL and Iron Python

[Vernon Cole]

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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/ironpython-users/attachments/20100720/6515edca/attachment.html>