Re: [IronPython] Calling a query from .MDB (Access stored procedure) by name:

Just a guess but could try 'select * from queryname'? Davy On Mon, May 24, 2010 at 8:55 PM, Peter Masiar wrote: > So I can connect to my little database now, thanks. > > I have a "query" in Access - I believe it's an Access term for a > stored procedure. > I'd like to call that stored procedure

[IronPython] Fwd: example of using IronPython with MS Access database (.mdb)?

(A copy for the group. Peter did not wish to possibly embarrass me, for which I thank him.) -- Vernon -- Forwarded message -- From: Vernon Cole Date: Mon, May 24, 2010 at 2:29 PM Subject: Re: [IronPython] example of using IronPython with MS Access database (.mdb)? To: Peter Masiar

[IronPython] Calling a query from .MDB (Access stored procedure) by name:

So I can connect to my little database now, thanks. I have a "query" in Access - I believe it's an Access term for a stored procedure. I'd like to call that stored procedure by name from my IronPython code. SQL text is huge (it inserts data from a Sharepoint "list", linked as access table, to real

Re: [IronPython] IronPython Tools and standard library

I don't think there's a way to do this right now other than copying the standard library (or site-packages) into your project :( I'll add it to the list of bugs and try and come up with a fix. And ultimately we also want some form of caching of the intellisense data so we don't need to re-scan

Re: [IronPython] example of using IronPython with MS Access database (.mdb)?

I found that it is a wiki and I can fix it myself - so I did. http://www.ironpython.info/index.php/Databases_with_Odbc "helping the next guy" (TM) Thanks again. ___ Users mailing list Users@lists.ironpython.com http://lists.ironpython.com/listinfo.cgi/

Re: [IronPython] example of using IronPython with MS Access database (.mdb)?

Or, if you wish to use the standard python PEP249 api for your JET data (thus making your program portable), you get a copy of http://sourceforge.net/projects/adodbapi and use a connection string like the sample in the .tests folder. If you tried this in the last two weeks (version 2.3.0), and got

Re: [IronPython] example of using IronPython with MS Access database (.mdb)?

Thank you. The three lines from Oracle example made the difference: import clr import System clr.AddReference("System.Data") Of course they are obvious for you gurus but to help a confused learner like me, it would be nice to add them to main ODBC example at http://www.ironpython.info/index.php/D

Re: [IronPython] example of using IronPython with MS Access database (.mdb)?

Peter Masiar wrote: Gurus, I am trying to wrap my mind about how I can access MS Access database from IronPython. My apologies - I bet this was asked about zillion times, but of course "Access" is impossible to google. I believe that it is same thing as Jet engine, Access 2003 uses .mdb as file

Re: [IronPython] example of using IronPython with MS Access database (.mdb)?

You should be able to use a standard OLE DB connection like what's described in http://www.ironpython.info/index.php/Oracle_&_OleDb and substitute the connection string pattern defined in http://www.connectionstrings.com/access /bill -- Carthago delenda est __

[IronPython] example of using IronPython with MS Access database (.mdb)?

Gurus, I am trying to wrap my mind about how I can access MS Access database from IronPython. My apologies - I bet this was asked about zillion times, but of course "Access" is impossible to google. I believe that it is same thing as Jet engine, Access 2003 uses .mdb as file extension. I found ht

[IronPython] IronPython 2.6 CodePlex Source Update

This is an automated email letting you know that sources have recently been pushed out. You can download these newer sources directly from http://ironpython.codeplex.com/SourceControl/changeset/view/66283. ADDED SOURCES $/IronPython/IronPython_Main/Languages/IronPython/IronPythonTest/