I assume (since you mention registry keys) that you are using some version of Windows.<br><br>I have not tested this, but it should work:<br><br>1) install pywin32, which contains adodbapi. see: <a href="http://sourceforge.net/projects/pywin32">http://sourceforge.net/projects/pywin32</a><br>
(or, if you are using IronPython, <a href="http://sourceforge.net/projects/adodbapi">http://sourceforge.net/projects/adodbapi</a><br><br>2) set up OLE DB drivers for Informix on your workstation(s). I found this reference on Google:<br>
<a href="http://www.datadirect.com/support/getting_started/quick_start/ado_informix/index.ssp">http://www.datadirect.com/support/getting_started/quick_start/ado_informix/index.ssp</a><br><br>3) use a connection string like:<br>
adodbapi.connect("<span class="cs_k">Provider</span>=<span class="cs_v">Ifxoledbc;</span><span class="cs_k">Data Source</span>=<span class="cs_v">dbName@serverName;</span><span class="cs_k">User ID</span>=<span class="cs_v">myUsername;</span><span class="cs_k">Password</span>=<span class="cs_v">myPassword;")<br>
see: <a href="http://connectionstrings.com/informix#p47">http://connectionstrings.com/informix#p47</a><br>--<br>Good Luck in your effort.<br>Vernon Cole<br><br></span><div class="gmail_quote">On Fri, Aug 21, 2009 at 6:15 AM, Carsten Haese <span dir="ltr"><<a href="mailto:carsten.haese@gmail.com">carsten.haese@gmail.com</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 class="gmail_quote"><div class="im">On Fri, Aug 21, 2009 at 5:36 AM, M. Hecht <span dir="ltr"><<a href="mailto:mhecht2909@instant-mail.de" target="_blank">mhecht2909@instant-mail.de</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;">
So why I have to configure environment variables or registry keys to connect<br>
to an Informix DB<br>
with Python??</blockquote></div><div><br>You have to configure environment variables or registry keys to connect to Informix with ANY LANGUAGE, not just in Python, because that's how the Informix client library is set up.<br>
<br></div><div class="im"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Is there any comparable approach doing this in one script whithout<br>
additional configuration?</blockquote></div><div><br>You could try to set up the necessary environment directly in your code.<br><br>Good luck,<br><br>Carsten Haese<br><a href="http://informixdb.sourceforge.net" target="_blank">http://informixdb.sourceforge.net</a><br>
</div></div><br>
<br>_______________________________________________<br>
DB-SIG maillist - <a href="mailto:DB-SIG@python.org">DB-SIG@python.org</a><br>
<a href="http://mail.python.org/mailman/listinfo/db-sig" target="_blank">http://mail.python.org/mailman/listinfo/db-sig</a><br>
<br></blockquote></div><br>