[python-win32] calling python as process from vb.net

2009-07-29 Thread Pam Westphal
I have a great python script that does quite a bit of statistical smoothing after reading data from a SQL table and then writes the results to a table. I don't really want to convert it into C. Currently I call the python script as a process from vb.net. About 1/2 of the time Python stops runnin

Re: [python-win32] Copying a MS Access Table

2009-07-29 Thread sebastian . venus
Thanks. I solved this now. The first argument in CopyObject should simply be the file path to the database being accessed. Internet m...@timgolden.me.uk 29/07/2009 09:23 To Sebastian VENUS, python-win32@python.org cc Subject Re: [python-win32] Copying a MS Access Table [copying back

Re: [python-win32] Copying a MS Access Table

2009-07-29 Thread Vernon Cole
Sebastian: You have what looks (to a non-Postgres user) like a proper ADO connection string for PostgreSQL. Open the Postgres database using adodbapi. I have already done all of the tricky COM stuff for you. You can also open the ACCESS database using adodbapi. There is an example in C:\python{y

Re: [python-win32] Copying a MS Access Table

2009-07-29 Thread Mike Driscoll
Tim Golden wrote: [copying back to the list] Not sure how to reply to the thread, since I thought that if I reply to "python-win32@python.org" then it would start a new thread? Replying to python-win32@python.org is the right thing to do; the mailing list software should recognise all the c

Re: [python-win32] By-reference COM method arguments not being treated as outputs

2009-07-29 Thread Mike Graham
On Wed, Jul 29, 2009 at 12:30 AM, Mark Hammond wrote: > On 29/07/2009 7:30 AM, Mike Graham wrote: >> >> Upon some further investigation, I have come to understand the method >> a bit better >> >> def PickObject(self, >>obj=defaultNamedNotOptArg, >>x=defaultNamedNotOptArg, >>

Re: [python-win32] ImportError: No module named win32file

2009-07-29 Thread Elias Fotinis
First, check if the file ("\Lib\site-packages\win32\win32file.pyd") really exists. Then check the Python module search path. Put a "print sys.path" before the "import win32file" and check whether it contains the "...site-packages\win32" dir. Either pywin32 didn't install properly or some modu

Re: [python-win32] Copying a MS Access Table

2009-07-29 Thread Gerdus van Zyl
Are you trying to copy a table from an access database to a postgres database? Because that's the impression I get, in which case do you need to do it once or do you need to do it regularly? In both cases Python might not be an optimal choice. You might have more luck using TransferDatabase and ODB

[python-win32] ImportError: No module named win32file

2009-07-29 Thread Iman Darabi
hi . i'm using pyserial 2.4 to work with some device via serial port . in linux have no prob with that ( because no pywin32 is needed ) but because i should write my program portable on both win and linux so tried to test it in win ... . installed python2.6 and pywin32-214 . but when i try to run m

Re: [python-win32] Copying a MS Access Table

2009-07-29 Thread Tim Golden
[copying back to the list] Not sure how to reply to the thread, since I thought that if I reply to "python-win32@python.org" then it would start a new thread? Replying to python-win32@python.org is the right thing to do; the mailing list software should recognise all the clues it needs to con