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".<br>
You can find it at <a href="http://dev.mysql.com/downloads/connector/odbc/5.1.html">http://dev.mysql.com/downloads/connector/odbc/5.1.html</a> <br><br>Also, <a href="http://www.connectionstrings.com/">http://www.connectionstrings.com/</a> will shed more light on the black magic of creating a working connection string.<br>
--<br>Vernon<br><br><div class="gmail_quote">On Tue, Jul 20, 2010 at 12:16 PM, Ian Hobson <span dir="ltr"><<a href="mailto:ian@ianhobson.co.uk">ian@ianhobson.co.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div bgcolor="#ffffff" text="#000000">
...Testing MySql login...<br>
(-2147352567, 'Exception occurred.', (0, u'Microsoft OLE DB Provider
for ODBC Dr<br>
ivers', u'[Microsoft][ODBC Driver Manager] Data source name not found
and no def<br>
ault driver specified', None, 0, -2147467259), None)<br>
Unit tests for adodbapi version 2.3.0<br>
Default Date Converter is <adodbapi.pythonDateTimeConverter object
at 0x023D7610<div><div></div><div class="h5"><br>
><br>
<br>
<br>
On 20/07/2010 19:05, Vernon Cole wrote:
</div></div><blockquote type="cite"><div><div></div><div class="h5">I use MySQL as one of the basic tests for adodbapi, so I
can say that it works pretty well for me.<br>
What obstacle do you hit?<br>
--<br>
Vernon Cole<br>
<br>
<div class="gmail_quote">On Tue, Jul 20, 2010 at 11:52 AM, Ian Hobson
<span dir="ltr"><<a href="mailto:ian@ianhobson.co.uk" target="_blank">ian@ianhobson.co.uk</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi
all,<br>
<br>
How can I (a nube) read a MySQL database using Iron Python? (windows 7
and 2008 Server).<br>
<br>
Any method will do, so long as it works. :)<br>
<br>
I've tried adodbapi and mysqldb and mysqlconnector - and always hit an
obstacle I can't get round.<br>
<br>
Regards<br>
<br>
Ian<br>
<br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.ironpython.com" target="_blank">Users@lists.ironpython.com</a><br>
<a href="http://lists.ironpython.com/listinfo.cgi/users-ironpython.com" target="_blank">http://lists.ironpython.com/listinfo.cgi/users-ironpython.com</a><br>
</blockquote>
</div>
<br>
<pre><fieldset></fieldset>
_______________________________________________
Users mailing list
<a href="mailto:Users@lists.ironpython.com" target="_blank">Users@lists.ironpython.com</a>
<a href="http://lists.ironpython.com/listinfo.cgi/users-ironpython.com" target="_blank">http://lists.ironpython.com/listinfo.cgi/users-ironpython.com</a>
</pre>
</div></div><pre><fieldset></fieldset>
No virus found in this incoming message.
Checked by AVG - <a href="http://www.avg.com" target="_blank">www.avg.com</a>
Version: 9.0.839 / Virus Database: 271.1.1/3017 - Release Date: 07/20/10 07:36:00
</pre>
</blockquote>
<br>
</div>
<br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.ironpython.com">Users@lists.ironpython.com</a><br>
<a href="http://lists.ironpython.com/listinfo.cgi/users-ironpython.com" target="_blank">http://lists.ironpython.com/listinfo.cgi/users-ironpython.com</a><br>
<br></blockquote></div><br>