There IS a working dbapi 2.0 implementation for Iron Python. see <a href="http://sourceforge.net/projects/adodbapi">http://sourceforge.net/projects/adodbapi</a> <br><br>It uses Microsoft ADO, so should be able to connect with PostgreSQL or almost any other tabular data source. I have not yet tested it with Postgres. That's the next thing on my to-do list. (I have a server running on my handy Ubuntu box, but can't seem to get it to connect. Why is there never enough time?) It is known to work with MicroSoft SQL, ACCESS, MySQL, and IBM AS400 sql.<br>
<br>I also have not yet written a distutils setup for it for IronPython -- you will have to unzip and copy to do the install the hard way. (Another to-do list item.)<br><br>You will either need to find an ADO provider for Postgres, or use an ODBC driver and a different connection string. (I use an ODBC connection for the MySQL sample in the \test folder.) Let me know how it works for you.<br>
--<br>Vernon Cole <br><br><div class="gmail_quote">On Fri, Jul 9, 2010 at 8:49 AM, Michael Foord <span dir="ltr"><<a href="mailto:fuzzyman@voidspace.org.uk">fuzzyman@voidspace.org.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 class="im">On 09/07/2010 14:50, Funke, Matt wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
I'm extremely new to compiling things in anything approaching a pythonic way, so my apologies in advance for what's probably a very simplistic question.<br>
<br>
I've downloaded the source for psycopg2-2.2.1. The documentation recommends using the standard "python setup.py build" and "python setup.py install".<br>
<br>
So I tried to run "ipy setup.py build" to incorporate these libraries into IronPython.<br>
<br>
I get this error:<br>
<br>
Traceback (most recent call last):<br>
File "setup.py", line 50, in<module><br>
ImportError: No module named subprocess<br>
<br>
<br>
</blockquote>
<br></div>
subprocess relies on modules like signal that aren't available in IronPython 2.6.1.<br>
<br>
There is a partial implementation of subprocess by Jeff Hardy floating around that you could try. In general the IronPython support for distutils is "minimal", so I still wouldn't expect normal module installation to work.<br>
<br>
All the best,<br>
<br>
Michael<div class="im"><br>
<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
I can verify that subprocess.py is in C:\Users\me\AppData\Local\Microsoft\VisualStudio\10.0\Extensions\Microsoft\IronPython Tools for Visual Studio\0.2\Lib. Do I need to add this directory to an environment variable (like PATH), or is there some other way I can notify IronPython about where to look for library files?<br>
<br>
Thanks for your time.<br>
<br>
-- Best Regards,<br>
Matt Funke<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>
<br>
<br></div><font color="#888888">
-- <br>
<a href="http://www.ironpythoninaction.com/" target="_blank">http://www.ironpythoninaction.com/</a><br>
<a href="http://www.voidspace.org.uk/blog" target="_blank">http://www.voidspace.org.uk/blog</a><br>
<br>
READ CAREFULLY. By accepting and reading this email you agree, on behalf of your employer, to release me from all obligations and waivers arising from any and all NON-NEGOTIATED agreements, licenses, terms-of-service, shrinkwrap, clickwrap, browsewrap, confidentiality, non-disclosure, non-compete and acceptable use policies (”BOGUS AGREEMENTS”) that I have entered into with your employer, its partners, licensors, agents and assigns, in perpetuity, without prejudice to my ongoing rights and privileges. You further represent that you have the authority to release me from any BOGUS AGREEMENTS on behalf of your employer.</font><div>
<div></div><div class="h5"><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>
</div></div></blockquote></div><br>