[DB-SIG] How to connect to informix DB in an easy way

Vernon Cole vernondcole at gmail.com
Fri Aug 21 17:37:44 CEST 2009

I assume (since you mention registry keys) that you are using some version
of Windows.

I have not tested this, but it should work:

1) install pywin32, which contains adodbapi.  see:
  (or, if you are using IronPython, http://sourceforge.net/projects/adodbapi

2) set up OLE DB drivers for Informix on your workstation(s). I found this
reference on Google:

3) use a connection string like:
    adodbapi.connect("Provider=Ifxoledbc;Data Source=dbName at serverName;User
  see:  http://connectionstrings.com/informix#p47
Good Luck in your effort.
Vernon Cole

On Fri, Aug 21, 2009 at 6:15 AM, Carsten Haese <carsten.haese at gmail.com>wrote:

> On Fri, Aug 21, 2009 at 5:36 AM, M. Hecht <mhecht2909 at instant-mail.de>wrote:
>> So why I have to configure environment variables or registry keys to
>> connect
>> to an Informix DB
>> with Python??
> 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.
>> Is there any comparable approach doing this in one script whithout
>> additional configuration?
> You could try to set up the necessary environment directly in your code.
> Good luck,
> Carsten Haese
> http://informixdb.sourceforge.net
> _______________________________________________
> DB-SIG maillist  -  DB-SIG at python.org
> http://mail.python.org/mailman/listinfo/db-sig
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/db-sig/attachments/20090821/e45c47b0/attachment.htm>

More information about the DB-SIG mailing list