[IronPython] MySQL and Iron Python

[Ian Hobson]

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 
> <mailto: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
>>     <mailto: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 <mailto:Users at lists.ironpython.com>
>>         http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
>>
>>
>>
>>     _______________________________________________
>>     Users mailing list
>>     Users at lists.ironpython.com  <mailto:Users at lists.ironpython.com>
>>     http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
>>        
>>
>>
>>
>>     No virus found in this incoming message.
>>     Checked by AVG -www.avg.com  <http://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 <mailto: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
>    
>
>
>
> 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
>
>    

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/ironpython-users/attachments/20100720/2b95ab0c/attachment.html>