Re: [python-win32] adodbapi COM Refresh clears Parameters

Kenneth: Sounds like a bug in the provider, doesn't it. I would not expect to see a patch, so it's a good thing you found a work-around. You asked if there might be a way to always build the parameter list manually. Perhaps we can add one. I happily adopt features from other db api implement

Re: [python-win32] AccessDB 2007

', '2009-01-29 15:05:19') ('3', 'Left Handed Smoke Shifter', '1.0', '100', '2008-04-01 12:00:00') ('4', 'Gravel (Bulk)', '100.25', '32.4567', '2009-01-29 13:05:31') ('5

Re: [python-win32] time/datetime module wierdness on some windows7/XP PCs

in32timezone, datetime Please report back if that does not work. -- Vernon Cole On Wed, Jul 25, 2012 at 12:00 AM, wrote: > hi, > > i've just noticed the following wierdness with the time and datetime > modules > (python-2.6.2 and python-2.7.3) on three windows7 hosts and one

Re: [python-win32] Getting output parameters from stored procedures

Michael: Last time I looked at the code of django-mssql it was using a fork of adodbapi, not the code I maintain, which is included with pywin32. Nevertheless, I don't think there are any changes in the return parameter handling between the two forks. I just ran across a related page on the AS/400

Re: [python-win32] adodbapi: using prepared statements

ave source code?) -- Vernon On Fri, May 25, 2012 at 4:06 PM, Alan Trick wrote: > On Fri, May 25, 2012 at 2:53 PM, Vernon Cole > wrote: > > Try setting adodbapi.adodbapi.verbose = 4 and see if that sheds any > light. > > Particularly look for the line that specifies 'e

Re: [python-win32] adodbapi: using prepared statements

that Tim's guess is correct. ADO really doesn't do much to remove the differences between SQL engines, and the adodbapi code blindly hands stuff to it. If the FoxPro provider does not handle parameters, or expects some format other than qmark, you might see an error like this one.

Re: [python-win32] Fwd: Trouble with SQL CE 3.5 DB File

My error! Reading again, I see that your version is up to date. If the data is not private, could you send a zipped copy of your data file to me directly (not to the list)? -- Vernon On Thu, May 17, 2012 at 12:59 PM, Vernon Cole wrote: > David: >You do not mention the version of ad

Re: [python-win32] Fwd: Trouble with SQL CE 3.5 DB File

ersion if you have not done that. If that does not do the trick, then there is yet another bug to chase... download from http://sourceforge.net/projects/adodbapi or get the latest pywin32. -- Vernon Cole On Thu, May 17, 2012 at 11:01 AM, David L. Page wrote: > > Hi, > > I have an .sdf

Re: [python-win32] A little help for a n00b, please

First, make sure that you can type "print somefile.txt" on a console command line and get it to work. Often the old DOS style print command - which is what you are trying here - will not work on new Windows printers. You may very likely have to use a much more complex method involving the Windows p

Re: [python-win32] a trivial question

*self*.doc.Tables(1).Cell(row,2) is not a string, and therefore has no .split() method. str(*self*.doc.Tables(1).Cell(row,2)) returns a string, so it does have a split() method and therefore str(*self*.doc.Tables(1).Cell(row,2)).split() is correct, but str(*self*.doc.Tables(1).Cell(row,2).split())

[python-win32] How do I detect a 64 bit version of Windows?

This is a reworded re-post of a question which I just placed to the IronPython list. I repeat it here, because I hope to get a general answer which will work on CPython, too, since the database driver I support works on both implementations. I have code which detects the "width" of the Python I am

Re: [python-win32] MySQL connection/admin tool

Jacob: adodbapi provides an extended dbapi 2.0 (PEP 249) connection to many databases, MySQL is one of the ones I test with regularly. It is included in pywin32. Just "import adodbapi" to use it. (You do have to install the MySQL ODBC driver.) The other packages you mention are MySQL specific,

Re: [python-win32] encoding decoding for python2.5

Dear person: There are lots of ways to encode and decode data. You'll need to provide some more information about the use you intend in order to get good advise. Do you just want to protect something from prying eyes on one workstation? How secure does it have to be? Are you sending the data to s

Re: [python-win32] PyCharm rather inaccessible/useless to me as such

The entire idea of a Python IDE written in java is frightening to me... Vernon Cole (sent from my 'droid phone) ___ python-win32 mailing list python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32

Re: [python-win32] Accessing standard Mail-application

On Fri, Jul 8, 2011 at 3:23 PM, Steffen Frömer < steffen.froe...@gns-systems.de> wrote: > On 07/08/2011 10:16 PM, Tim Roberts wrote: > > Steffen Frömer wrote: > > i tried to access standard mail application to write a mail. > I know the machanism with urllib, but there is no regular way to add >

Re: [python-win32] installation problem on win xp

should automatically find its own correct version of python. Is that what you tried? -- Vernon Cole On Wed, Jul 6, 2011 at 11:31 AM, Lynn Oliver wrote: > Hello, > > New here, so I hope I'm following correct procedures. > > Yesterday I installed python 2.7.2 on win xp and the

Re: [python-win32] Creating PyCComboBox?

from "1900". Yech! I think that a proper combobox will have to be coded at a higher level. I hope I'm wrong. -- Vernon Cole On Sat, Jun 11, 2011 at 12:55 AM, Greg Ewing wrote: > How are you supposed to create a PyCComboBox? There > doesn't seem to be a CreateCombo

Re: [python-win32] First post to list, etc.

hough it was written ten years ago and is based on a very old version of python. "Python Programming on Win 32". I think an electronic version of it may have been pirated on line as well. Yes, everything in pywin32 works on 64 bit versions of Windows and Python, too. -- Vernon Cole O

Re: [python-win32] Fw: [ pywin32-Bugs-3292681 ] adodbapi - Subtle crash

I found two fixes for the crash. Now I need one of you brilliant folks to tell me which is correct. First, here is a snippet from adodbapi. Look closely at the comments on the last three lines of code ... v v v v v v v v v [... Snip ...] [ (Note: lines below are paraphrased -- not quite the actu

[python-win32] Fw: [ pywin32-Bugs-3292681 ] adodbapi - Subtle crash

nore...@sourceforge.net Date: Tuesday, April 26, 2011, 3:11 PM Bugs item #3292681, was opened at 2011-04-25 15:51 [... snip ...] Category: adodbapi Group: None Status: [Accepted] Resolution: None Priority: 5 Private: No Submitted By: https://www.google.com/accounts () Assigned to: Vernon Cole (

Re: [python-win32] unable to register a python com server

Correct. 32 bit COM cannot talk to 64 bit COM. That's one of the few reasons for running 64 bit Python. On Thu, Apr 7, 2011 at 8:53 AM, Matteo Boscolo wrote: > thanks but unfortunately it does not solve the problem .. > > my machine is a 64 bit and my os is w7 > my python version is 2.6 32bit ..

Re: [python-win32] Catching Send To in Office

One of the executives where I used to work actually made use of the ¨send to" feature in Word. The resulting bloat that appeared was appalling, and IIRC the recipient had to have Word installed to read the mail, when she finally imported it. Perhaps later versions of Word do a better job. Our ans

Re: [python-win32] Conversion to Mercurial is done

Working fine here. Here's a sample for anyone who has not tried sourceforge hg before. I have PuTTY loaded on this machine, and already have my ssh keys set up on sourceforge -- just like with CVS. Mercurial is loaded using the binary installer. And, I actually remembered to load my sourceforge ke

Re: [python-win32] Possible trouble with pywin23-216 on python 3.2

I ran across this problem myself awhile back, and it seems to be common enough that they added a feature to distutils to handle it. I have added a copy of my setup.cfg to CVS, which contains: [build] force=1 [bdist_wininst] user_access_control=auto With "force=1", it should theoretically clean o

Re: [python-win32] print file byte contents distribution

What a nifty script! I love it! Here's my version. I tested using a 800 KByte image file and it runs in a blink. Dictionary access in Python is very fast. counter = {} for bytes in open('c:\\temp\\16.jpg', "rb").read(): try: counter[bytes] += 1 except KeyError: counter[bytes

Re: [python-win32] Mapping Drives in Python

e by putting an "r" before the opening quote. r"\\someserver\someshare\somepath" in Python. -- Vernon Cole On Fri, Mar 4, 2011 at 12:46 AM, Becky Mcquilling wrote: > Hi: > Hoping you guys can help out a python noob here. > I have a list of machines that I am backing up flat

Re: [python-win32] Fonts behaving differently with Py3/216

On Thu, Mar 3, 2011 at 8:37 PM, Mark Hammond wrote: [...] > > the 32 bit version of pywin32 appears to have 2.x syntax .py files). [...] No, not completely 2.x syntax, only "except SomeError, e" so if you get lucky, some modules might import okay.   The version of setup.py that I use in the stan

Re: [python-win32] Possible trouble with pywin23-216 on python 3.2

Smarta (err) (umm) Thanks Tim, I'll try that. -- Vernon On Mar 3, 2011 1:50 AM, "Tim Golden" wrote: > """ > Re: [python-win32] Possible trouble with pywin23-216 on python 3.2 > """ > > Aha! There's your problem: you're trying to install pywin23. > Don't know why you didn't spot it yourself...

[python-win32] Possible trouble with pywin23-216 on python 3.2

Attempting to install using the binary installer, the installer gets to "postinstall script finished", but the display window says: v v v v v v v v Copied pythoncom32.dll to C:\Windows\system32\pythoncom32.dll Copied pythoncomloader32.dll to C:\Windows\system32\pythoncomloader32.dll Copied pywintyp

Re: [python-win32] Possible future direction for PyGUI on Win32

So with pythoncom on one hand and pywin32 on ironclad on the other you could go either way on either compiler? Sounds pretty neat. Is pythoncom python3 ready? (I haven't looked at source yet. Vernon Cole (sent from my 'droid phone) On Feb 28, 2011 2:58 AM, "Tim Golden" w

Re: [python-win32] Possible future direction for PyGUI on Win32

Hmmm... projects get abandoned for many reasons. Michael: In your professional opinion would it be worthwhile to clone/fork/resurrect the pythonnet project, or is it a bad idea better left dead? -- Vernon On Sun, Feb 27, 2011 at 1:38 PM, Michael Foord wrote: > > > On 26 February 2011 20:31, G

Re: [python-win32] [ANN] pywin32 build 215 released.

Mark: Trouble! in build 215, the Python 3 versions of adodbapi are broken. It seems that when 2to3 is run on adodbapi.py, the "raise" filter is missing, so that two syntax errors are left in the module. -- Vernon On Sun, Feb 20, 2011 at 5:40 PM, Mark Hammond wrote: > Hi all, > I'm happy

Re: [python-win32] FW: python-win32 image fields problem

Dardo: Thanks for the data base you sent me. It allowed me to do a good test of large binary data, and the scenery in the images is beautiful. I assume they are images from the Canary Islands. Also thanks for the VB sample program. Why does anyone use Visual Basic? Python is so much simpler, as y

Re: [python-win32] IE (ocx) OK, but python never close

Michel: Without actually analyzing you script, I see one thing immediately... You expect Windows and Internet Explorer to actually respond quickly. Your timeout for the shutdown is 1/4 second. When last I tried to automate Windows functions, I gave up on using fixed timers, because sometimes it

Re: [python-win32] DVCS options for pywin32

My personal stuff is on bzr and I have put my open source stuff on hg, partly because you said you were switching to it. A 3rd dvcs is one too many IMHO. I moved the stand-alone (IronPython) copy of adodbapi to hg on sourceforge and it was painless. I'ld encourage hg. Vernon Cole (sent fr

Re: [python-win32] InstallService TypeError: exceptions must be classes or instances not str

mp\win32_service>c:\python26\python.exe test_service.py install Service installed Service started which I think is what you intended. The service is indeed installed on my system. --- So... What version of Windows are you running? Where did "test_service.exe" come from? (I don't see

Re: [python-win32] FW: python-win32 image fields problem

to the list.) Vernon Cole (sent from my 'droid phone) On Feb 3, 2011 4:24 AM, "Dardo Schuster Glez" wrote: > > > > > Dear Sir > > How can y show a jpg that is in a SQL Server image field in a Qlabel object ??? and how to change and save it in the image f

Re: [python-win32] How to specify parameters in a query using odbc

Code=? AND SampleTests.TestStatus<900 AND SampleResults.ComponentName=’IntMethod’) “”” Paul's impression that parameter substitution only works in INSERT statements is incorrect. (The documentation IS awfully lightweight.) You can also use them in SELECT as in your example. -- Vernon C

Re: [python-win32] error importing win32com for Dispatch

Don't use the ZIP file. It is a pain to install, and (as you see) sometimes does not install correctly. Unfortunately, sourceforge sets it as the default thing to do. What you want to do is push the "view all files" button and select the la

Re: [python-win32] odbc under windows 7?

Gary: I was able to track down a Windows 7 - 64 bit computer this morning. Installed Python 3.1 (32 bit) Installed pywin32-214 for py31 (32 bit) Installed adodbapi 2.4 (to get the test.mdb database) I was able to read the data correctly. No Microsoft office components were installed. (I also fo

Re: [python-win32] odbc under windows 7?

I think Tim's last suggestion is the way to go, and you should NOT need ACCESS installed. Microsoft invented ODBC. Everybody saw it was a great idea and adopted it. So Microsoft had to invent something even newer, which everybody else does not support. That's called ADO. ADO defaults to ODBC m

Re: [python-win32] adodbapi returns None for text field in first row

ion function= > > output=u'infitrating' > > …see attachment for remaining… > > >>> print repr(rows[0]) > > (u'infiltrating', None, u'C0007124') > > >>> print repr(rows[1]) > > (u'infitrating&

Re: [python-win32] Attempting to install pyWin32: Skipping exchdapi: No library 'Ex2KSdk' Skipping directsound: The header 'dsound.h' can not be located

Unless for some reason you actually NEED to compile pywin32, such as if you are testing patches or new modules or such, then use the binary installer. It is much easier. On Jan 1, 2011 10:42 PM, "Marc Hankin" wrote: I just downloaded pyWin32 (https://sourceforge.net/projects/pywin32/) and starte

Re: [python-win32] adodbapi returns None for text field in first row

Scott: Something is indeed fishy. What os, version of python, and version of pywin32 are you using? As an attempt to duplicate your result, I built a table "tblTemp" on my Windows Vista laptop's SQL express 2008 with three VarChar fields and loaded two rows of data. I defined an ODBC DSN to poin

Re: [python-win32] Two questions

I had a similar project. I had a .bat file on a network share which installed python & pywin32 from Windows installers on the share. On each workstAtion, the user would click an icon which ran a console mode .py script which copied the .py files from the share if needed, then forked a .pyw of the

Re: [python-win32] Access femap API, Type mismatch

Jim: Greg's answer is correct for you. Use it. It made me think of the following question which you may safely ignore. VC Dear Gurus: This thread made me wonder. (It happens occasionally.) The IronPython team chose a different work-around for system calls: they have a class which can be used

Re: [python-win32] Running GUI apps from a python/IIS web application

There is a registry hack to make a Windows box auto log in when it boots up. If you cannot find an example, get back to me and I will get a sample from a co-worker at a former employer. We had several dozen machines there which were actually servers, but the software was written for a GUI desktop

Re: [python-win32] odbc exceptions

On Tue, Nov 30, 2010 at 10:25 AM, Preston Landers wrote: > That's strange. I don't get that under Python 2.6.5 and PyWin32 v214. I > get the kind of error one would expect. > > >>> try: > ... odbc.odbc("asdf") > ... except: > ... raise > ... > Traceback (most recent call last): > File "", lin

Re: [python-win32] odbc exceptions

Robin: Odbc is still maintained. It is not deprecated, exactly, but is obsolescent since it uses db api version 1 calls. It is maintained that way so that it doesn't break old code. The bug report is appreciated, I'll make sure it gets into the sourceforge bug list if you don't beat me to it. The

Re: [python-win32] Pythonwin interactive window seems gone ?

2) Download python and pywin32 separately from: http://python.org/ and http://sourceforge.net/projects/pywin32/ -- Vernon Cole On Mon, Nov 29, 2010 at 9:13 AM, leegold wrote: > Hi, > > The interactive window ( the shell window) in Pythonwin is gone, I open > it and it's an empty can

Re: [python-win32] FW: Problems with recordset object

be very welcome. Unit tests can miss things. Please try it out and let me (and everyone else) know how it works for you. -- Vernon Cole On Thu, Sep 2, 2010 at 4:36 AM, Dardo Schuster Glez < dardoschus...@hotmail.com> wrote: > Dear Sirs > > I was programming many years with delphi

[python-win32] Announcing adodbapi version 2.4.0 -- now with COLUMN NAME data access

Announcing a new version of adodbapi... [ for those who may not know... [ adodbapi is a pure Python package which fully implements the PEP-249 db-api [ using Microsoft ADO/db. [ It runs on CPython versions 2.3 and later, IronPython 2.6 and later, [ or Python 3.0 and later. http://sourceforge.net/p

Re: [python-win32] pywin32 services

Well, you get that specific error from something like: >>> list1 = ['this is a','list'] >>> anError = list1[2] Traceback (most recent call last): File "", line 1, in IndexError: list index out of range What does the code look like at hqmonitor.py line 220? -- VC On Mon, Jul 19, 2010 at 6:50 A

Re: [python-win32] unable to read mssql varchar(max)

can throw together a quick example of the failure if that will help with debugging. It involves a sample SQL data table that must be imported for the test and is not small (several recorded telephone calls as blobs)-- so I will only do it if needed. Does anyone (Mark?) need it? -- Vernon Cole On

Re: [python-win32] Python, COM, VARIANT, VT_BYREF, Joy!

If I Recall Correctly, the ActiveXCtrl class in wxPython does not use the pywin32 tools, but a different package. That, along with no plans to migrate to Python 3, is why my own work is migrating away from wxPython. Too bad, too. I rather liked wxPython. -- Vernon Cole On Mon, May 24, 2010 at 7

Re: [python-win32] Windows freeze

Well, MY Windows PC freezes sporadically even when nothing is running. I think that's considered a feature in Redmond, Washington. ;-) 2010/5/6 Leonhardt, Günter > Hi all, > I'am using python-win32 for communication with 2 terminalservers. > There 16 parallel connection handled, each in a seper

Re: [python-win32] Win API call to display a BMP/PNG file as a splash screen for a console app?

Malcolm: I used to have exactly what you need. Unfortunately, when I checked just now, I find that I failed to "lift" a copy of the source code when I left the place where I wrote it. "It" was a command line utility which accepted as arguments the name of a .jpg file and the number of seconds

Re: [python-win32] odbc version

On Wed, Dec 30, 2009 at 3:10 AM, Robin Becker wrote: > On 29/12/2009 14:34, Vernon Cole wrote: > >> Robin: >> A quick reminder -- odbc (in pywin32) is db api version 1.0 compliant. >> adodbapi is db api version 2.0 compliant, and uses odbc DSN connections >> by

Re: [python-win32] odbc version

Robin: A quick reminder -- odbc (in pywin32) is db api version 1.0 compliant. adodbapi is db api version 2.0 compliant, and uses odbc DSN connections by default if you use a simple connection string. Select your db module by deciding what level of api compliance you need. If you use adodbapi,

Re: [python-win32] Setting a netboot within windows OS

Gowtham: I waited before giving this answer, to let the real Windows Gurus answer first. Tims pronouncement is as good is it gets, so here is my hair-brained idea. Perhaps it would actually work. As much as I hate to admit this on a Windows mailing list ... When I have multi-boot things to ac

Re: [python-win32] Apparent bug in COM browser on Vista

On Wed, Dec 16, 2009 at 9:44 AM, Ross Boylan wrote: > Vernon Cole wrote: > >> Dear Ross: >> The combined Python package hosted by Active State is convenient, but >> does not always stay up to date. The current build of pywin32 is 214. Many >> bug fixes have happen

Re: [python-win32] Apparent bug in COM browser on Vista

try re-installing python from the official sources: http://python.org/ and http://sourceforge.net/projects/pywin32/ If that does not fix the problem, please let us know here. -- Vernon Cole On Wed, Dec 16, 2009 at 1:37 AM, Ross Boylan wrote: > The Python COM browser (pywin32 build 211.1), availa

Re: [python-win32] adodbapi upgrade

Randy: Good idea, but I need a test case which gives a reliable failure. The simple test in the test suite works fine. Could I talk you into submitting a copy of adodbapitest.py which will demonstrate the problem which must be fixed? That way the problem, once fixed, can never re-occur. -- Ver

Re: [python-win32] Solved - Printing coordinate system problem

You're the Man, Thomas! You, too, Greg! Now I have to get my latest upgrade to adodbapi done so I can put some time into really using pygui. -- Vernon On Tue, Dec 15, 2009 at 4:15 AM, Greg Ewing wrote: > Thomas Heller wrote: > > I would guess that GetDeviceCaps() returns the information that you

Re: [python-win32] [Pygui] Printing coordinate system problem

In searching for documentation, remember a quirk in Microsoft vocabulary... a "printer" is software, not hardware. The device on the corner of your desk with the paper in it is not a "printer", it is a "printing device." -- Not being an expert on writing Windows printer code, nevertheless let me v

[python-win32] Poll: split of adodbapi.py into two modules? (django support)

; >>> This will break code which expects some of these constants to be attributes of adodbapi, such as 'adUseClient' and 'adXactBrowse'. Question: Should I proceed to use the separate version of ado_consts, even though it might break some existing programs? -- Vernon Cole

Re: [python-win32] [pygtk] ANN: PyGUI 2.1

-mail to postmaster @ python.org That's where the pywin32 group lives, and it works rather well. -- Vernon Cole On Mon, Nov 16, 2009 at 3:31 PM, Greg Ewing wrote: > > John Finlay wrote: > >> Start your own list for the community that is interested in your project. > >

Re: [python-win32] Python for Windows extensions

Welcome, Hung: I tried answering this question on sourceforge, but your email address there does not work. :-( The short answer is: we think that it works for both python 3 and 64 bit. We test it on both. If you find a problem, report it here and we will try to help. -- Vernon Cole On Mon, Nov

Re: [python-win32] [pygtk] ANN: PyGUI 2.1

Strula: The GUI designer has to output code for some API or another. If it produces code for a cross platform GUI API then the resulting application will be cross platform. I would love to find one such that actually works and produces good code. Do you have any suggestions? -- Vernon Cole Sent

Re: [python-win32] [pygtk] ANN: PyGUI 2.1

first... -- Vernon Cole Sent from my Windows Mobile phone -Original Message- From: Greg Ewing Sent: Sunday, November 15, 2009 2:18 PM To: John Finlay Cc: PyObjC-Dev ; PyGtk ; python-win32 Subject: Re: [python-win32] [pygtk] ANN: PyGUI 2.1 John Finlay wrote: > Greg, > > Why do yo

Re: [python-win32] completely removing python from windows

right-click on "myPythonScript.py" and select "Edit", I will get the IDE for which ever version of Python I installed most recently, usually a 3.x version, which may make it rather difficult to debug a Python 2.x script. ;-) HTH Vernon Cole P.S.: I keep all of my imitation

Re: [python-win32] Compiling Python code to DLLs: Any way to do this

would then have an excuse to learn more about this myself. He claims that it would be good for my consulting repertory. -- Vernon Cole On Sat, Nov 7, 2009 at 10:20 PM, Ti Crossman wrote: > Hello, all. I have a need to create application extensions for ESRI > ArcGIS geographic information sy

[python-win32] Fwd: win32 errata: AddSourceToRegistry

Aahz: Thank you. The correction has been made in the source for the second edition. (Now I need to finish writing the *proposal* for the second edition so we can see if O'Reilly will print one.) -- Vernon Cole On Mon, Nov 2, 2009 at 4:44 PM, Aahz wrote: > The signa

Re: [python-win32] [Fwd: Re: Running the COM MakePy Utility from python]

pretty much a drop-in replacement for pgdb and MySQLdb in most cases, so that programmers can use it to start moving code like yours into newer and/or weirder environments (i.e. IronPython and Python 3). I will be referring to your work as I add postgresql tests to the adodbapi suite. -- Vernon Cole

Re: [python-win32] Dealing with windows in Windows

source, but the license is inexpensive. See: http://users.swing.be/wintclsend/windpysend/<http://users.swing.be/wintclsend/windpysend/> -- Vernon Cole On Mon, Aug 3, 2009 at 9:05 AM, Kimmo Kekkonen wrote: > Hi! > > I were wondering if it is possible to use Python to select a window

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

easier to use than VBA for prototyping and quickie jobs. -- Vernon Cole On Wed, Jul 29, 2009 at 6:16 AM, Gerdus van Zyl wrote: > 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

Re: [python-win32] dbi module deprecated at 2.5. What to use in its place in 2.5, 2.6, and 3.0?

, and therefore may be slightly slower. ADO is fussy about re-using a cursor, you have to close the old one and open a new one for each transaction. On the other hand, perhaps re-using cursors is why odbc seemed to crash sometimes for me. YMMV. -- Vernon Cole On Wed, Jul 8, 2009 at 6:31 AM, Mark Hammond

Re: [python-win32] Shell extension debugging

;x.txt','w') >>> import sys >>> sys.stdout = x >>> print 'hello, world' >>> exit() C:\Users\vernon>type x.txt hello, world --- For debugging, you may want to add sys.stderr = x as well. -- Vernon Cole ___ python-win32 mailing list python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32

Re: [python-win32] regarding invoking command prompt using python

wrote: > Vernon Cole wrote: > > Thanks, Tim! > > > > Should this be logged against the standard library as a bug? > > Nope. It's actually the documented behavior. See section 16.1.1 here: >http://docs.python.org/library/os.html > > -- > Tim Robert

Re: [python-win32] regarding invoking command prompt using python

So -- is there an api call which DOES actually place the value in os.environ? -- Vernon On Wed, Jun 17, 2009 at 11:56 PM, Roger Upole wrote: > Vernon Cole wrote: > >> Tim: >> Okay, explain this... >> C:\BZR\sterling\HL7>c:\python26\python.exe >> Python 2.6.2 (

Re: [python-win32] regarding invoking command prompt using python

t;>> os.putenv('x','test') >>> print os.getenv('x') zzz >>> exit() C:\BZR\sterling\HL7>set x x=zzz C:\BZR\sterling\HL7> -- Vernon On Wed, Jun 17, 2009 at 8:11 PM, Tim Roberts wrote: > Vernon Cole wrote: > > > >

Re: [python-win32] regarding invoking command prompt using python

ram files\Ironpython 2.0.1\ipy.exe" %1 %2 %3 %4 %5 %6 %7 %8 %9" ped.bat contains: "start c:\python26\Lib\site-packages\pythonwin\pythonwin.exe %1 %2 %3" 2to3.bat contains: "c:\python26\python.exe c:\python26\Tools\Scripts\2to3.py %1 %2 %3 %4 %5 %6 %7 %8 %9" Suppose I am r

Re: [python-win32] adodbapi and stored procedure output parameters on

-644-4776 > http://www.rcs-comp.com > > "Whether, then, you eat or drink or > whatever you do, do all to the glory > of God." 1 Cor 10:31 > > > Vernon Cole wrote: > > According to PEP 249... > .callproc(procname[,parameters]) >

Re: [python-win32] adodbapi and stored procedure output parameters on

, 2009 at 12:54 PM, Randy Syring wrote: > > > Vernon Cole wrote: > > In this case, the proceedure outputs TWO record sets, since there are > two SELECT statements. > If the second select statement, "select @param = 10" were changed to > "SET @param = 10" t

Re: [python-win32] adodbapi and stored procedure output parameters on

According to PEP 249... .callproc(procname[,parameters]) Call a stored database procedure with the given name. The sequence of parameters must contain one entry for each argument that the procedure expects. The result of the call is returned a

Re: [python-win32] Error 500 on IIS

"win32all" is a very old name which is still hanging around in some documentation. The package is now referred to as "pywin32". http://sourceforge.net/projects/pywin32/ Which versions of Python and pywin32 are you using? -- Vernon Cole On Mon, Apr 27, 2009 at 9:22 AM, Iuri w

[python-win32] Iron Python integration.

environment using IronPython? -- Vernon Cole ___ python-win32 mailing list python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32

Re: [python-win32] Might be a easy problem.

Dear dynamicbit: Your example contains numerous errors in tabs and spelling, and shows a total lack of understanding of Python. Try reading the tutorial http://docs.python.org/3.0/tutorial/ and working simple examples to learn the basics. Python is a great language, and you would be much better off

Re: [python-win32] executing dos commands

One warning: If you do a chdir command (for example) or define a dos environment variable, etc, in a shell script -- using any of the subprocess or os.system or such commands -- it will only affect the child procees which is created for the call, not the process you make the call from. This is not

Re: [python-win32] OnCtlColor not working?

So, Greg, can we anticipate a python_gui flavor for Windows in native mode? -- Vernon Cole On Mon, Mar 2, 2009 at 7:46 AM, Mike Driscoll wrote: > King Simon-NFHD78 wrote: >>> >>> -Original Message- >>> From: python-win32-bounces+simon.king=motorola@pytho

Re: [python-win32] opening files with names in non-english characters.

argument is a unicode object. myPath = unicode(someStringObject) or myPath = u'somePath' -- Vernon Cole ___ python-win32 mailing list python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32

Re: [python-win32] Help required in opening a remote file in python.

u type four to get two: >>> f=open("remote_machine\\folder1\\file1.doc", "r") 3) use a python "raw" string which eliminates backslash escapes entirely so that you can type the string as windows will see it (note the letter "r" before first quote): &

[python-win32] Fwd: [DB-SIG] adodbapi return datetime

g existing code if I change the default. Your comments solicited... -- VC On Tue, Feb 10, 2009 at 8:49 AM, William Dode wrote: > On 10-02-2009, Vernon Cole wrote: > > > William: > > It has always seemed to me that the syntax you tried should work. Perhaps > > someday, so

Re: [python-win32] Unable to connect to MSSQL Database(x64) using pyodbc 32bit & python 32bit

Siddhartha: This seems to be a pyodbc question, and would be best answered on their discussion group. Try http://groups.google.com/group/pyodbc The SQL dbapi interfaces which ship with pywin32 are odbc and adodbapi. Nevertheless, your very long DSN string gives me pause. You might try going back

Re: [python-win32] [pywin32-checkins] py3k status

lling time.gmtime(). Intrestingly, this was also a problem in IronPython. I had to file two separate bug reports to get time.gmtime working there. -- Vernon On Thu, Feb 5, 2009 at 5:14 AM, Mark Hammond wrote: > On 5/02/2009 5:10 AM, Vernon Cole wrote: > >> Okay, group, I'm opening

Re: [python-win32] [pywin32-checkins] py3k status

Okay, group, I'm opening this up for discussion... Is my routine wrong, or is the test flawed? This test works fine at my house, U.S. Mountain Standard Time. When I change my Windows time zone to Brisbane, it fails here like it does for Mark. The test is: def testDateObjectFromCOMDate(self)

Re: [python-win32] Pythonwin crashes everytime

Are you using a Chinese character set by default? If so, you may be the second person to discover a bug which was described recently. I quote: I tracked down the source of the problem. > > I am using Windows XP, SP3. Two days ago I changed Control Panel, Regional > and Language Options, Advanced

Re: [python-win32] How to calc amount of avail RAM in a process ?

Geoff: Congratulations, you have just provided an excellent example of Nathan's first law: > *Software is a gas* > Software always expands to fit whatever container it is stored in. > http://www.codinghorror.com/blog/archives/000677.html -- VC On Thu, Jan 29, 2009 at 5:18 AM, Steven James wrote:

Re: [python-win32] Reading constants

object for documentation purposes, so the next guy who reads your program (or yourself five years later) can understand what the number means in the interface. -- Vernon Cole # -- #constants from http://www.indesignscriptingreference.com/CS3/JavaScript/SaveOptions-enum.htm SaveOptionsNo =

Re: [python-win32] ImportError: DLL load failed: The specified procedure could not be found.

Directory of C:\Python25\Lib\site-packages\isapi > > 01/26/2009 11:05 AM37,888 PyISAPI_loader.dll >1 File(s) 37,888 bytes > > Directory of C:\Python25\Lib\site-packages\pywin32_system32 > > 01/26/2009 11:05 AM 339,968 pythoncom25.d

  1   2   >