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 <i...@ianhobson.co.uk
<mailto:i...@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 <i...@ianhobson.co.uk
<mailto:i...@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@lists.ironpython.com <mailto:Users@lists.ironpython.com>
http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
_______________________________________________
Users mailing list
Users@lists.ironpython.com <mailto:Users@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@lists.ironpython.com <mailto:Users@lists.ironpython.com>
http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
_______________________________________________
Users mailing list
Users@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
_______________________________________________
Users mailing list
Users@lists.ironpython.com
http://lists.ironpython.com/listinfo.cgi/users-ironpython.com
