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.<br>
(paramstyle='named'). So for today, you must use column position to read the data.<br>--<br>Vernon<br><br><div class="gmail_quote">On Tue, Jul 20, 2010 at 1:12 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">
Thanks Vernon, <br>
<br>
With your help I now have some data! <br>
<br>
Now to find out if I can access it by field name and not just position.
<br>
<br>
Thanks again<br><font color="#888888">
<br>
Ian</font><div><div></div><div class="h5"><br>
<br>
On 20/07/2010 19:32, Vernon Cole wrote:
<blockquote type="cite">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" target="_blank">http://dev.mysql.com/downloads/connector/odbc/5.1.html</a>
<br>
<br>
Also, <a href="http://www.connectionstrings.com/" target="_blank">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" 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;">
<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><br>
><br>
<br>
<br>
On 20/07/2010 19:05, Vernon Cole wrote:
</div>
</div>
<blockquote type="cite">
<div>
<div>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" 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>
<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>
<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></div></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>