Re: [python-win32] Play MP3s from Windows, Just Works

2008-08-12 Thread Vernon Cole
As always, remember that mp3 is proprietary, and the owner has shown willingness to be nasty about licensing it. Therefore, anything that is "easy to install" is possibly illegal and/or will open you to a lawsuit. If you are doing new work, better to use ogg. On Tue, Aug 12, 2008 at 5:53 AM, Sidne

Re: [python-win32] Play MP3s from Windows, Just Works

2008-08-13 Thread Vernon Cole
Where can one find documentation of MCI? On Tue, Aug 12, 2008 at 4:30 PM, Michel Claveau <[EMAIL PROTECTED]> wrote: > Hi! > > This is perfect. Works like a charm ... Thank you very much! >> > > Thanks for return. > > For info, MCI can, also, record from microphone, save file, give infos on > so

Re: [python-win32] interprocess communication python and visual basic can it be done?

2008-08-26 Thread Vernon Cole
Emanuel: Best answer: Find a copy of *Python Programming On Win32* by Mark Hammond and Andy Robinson and read chapter 7. Unfortunately, copies of the book are getting quite hard to get. -- VC Mark: New edition??? Please!!! -- VC On Tue, Aug 26, 2008 at 10:26 AM, Emanuel Sotelo <[EMAIL PROTE

Re: [python-win32] interprocess communication python and visual basic can it be done?

2008-08-27 Thread Vernon Cole
On Tue, Aug 26, 2008 at 11:00 PM, Tony Cappellini <[EMAIL PROTECTED]>wrote: > > Unfortunately, copies of the book are >> getting quite hard to get. >> >> > Why? It's still being published > http://oreilly.com/catalog/9781565926219/index.html > > Amazon still has them in stock too > > http://www.

[python-win32] adodbapi version 2.2 ready and in cvs.

2008-08-29 Thread Vernon Cole
dbapi . Put the unzipped folder in your /lib/site-packages directory. -- Vernon Cole ___ python-win32 mailing list python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32

[python-win32] adodbapi 2.2.1 (bugfix) release.

2008-09-05 Thread Vernon Cole
I found a bug in adodbapi v2.2 already. When putting data into a numeric database column, if the input was in a string (as for example the value of a wxPython grid cell), then the data would be truncated to the binary length of the field. So if I tried tried putting "12345" into an integer column,

[python-win32] Fwd: adodbapi 2.2.1 (bugfix) release.

2008-09-07 Thread Vernon Cole
[I tried sending this to two lists at once, and it seems to have been rejected by both, so this is a retry. -- VC] I found a bug in adodbapi v2.2 already. When putting data into a numeric database column, if the input was in a string (as for example the value of a wxPython grid cell), then the data

Re: [python-win32] ODBC date and time issues

2008-10-07 Thread Vernon Cole
tures" of MS Access. It occurs to me that the same "feature" my also occur in odbc.odbc so I'ld like to try it as well. --- Vernon Cole ___ python-win32 mailing list python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32

Re: [python-win32] ODBC dates and buffers

2008-11-11 Thread Vernon Cole
so if you install eGenix base suddenly your time comparisons quit working. My guess is that most people who use mxDateTime also use mxODBC rather than either of our free api's, so a change in default would not bite as many people as the status quo.

Re: [python-win32] getting integer value for worksheet.Cells(row, col).Value

2008-11-19 Thread Vernon Cole
(alpha) Perhaps there is something about the received string that will not convert. For example, an empty string will give you a ValueError. You may have to use something like: try: val = int(alpha) except ValueError: val = 0 # or do you want val = None ? -- Vernon Cole On Wed, Nov 19,

Re: [python-win32] python.exe crashes while connecting to MSSQL Database using pyodbc.connect

2008-12-17 Thread Vernon Cole
Do you have some special reason for using pyodbc, such as higher performance? If not, you might try replacing pyodbc with adodbapi. import adodbapi try: DBCon = adodbapi.connect("DSN=TestDB;UID=tester;PWD=tester") except adodbapi.Error, erno: mesg = "Unable to connect testD

Re: [python-win32] python print statements

2009-01-08 Thread Vernon Cole
How about -- if debug: print x or, in a more complex setting, have a "verbose" attribute in each module and -- if self.verbose > 2: print x # so you can have levels of debug printouts ?? -- Vernon Cole On Wed, Jan 7, 2009 at 11:30 PM, Michel Claveau wrote: > Hi! > >

Re: [python-win32] python print statements

2009-01-08 Thread Vernon Cole
27;I is =', i class blackHole(object): def write(self,*args): pass import sys test(3) sys.stdout = blackHole() test(100) print >> sys.stderr, 'It worked!' -- Error messages (which are send to sys.stderr rather than sys.stdout) will still display normally. Vernon C

[python-win32] Support for ProgresSQL in adodbapi?

2009-01-12 Thread Vernon Cole
opinions either way whether or not I should do this. Whaddaya think? -- Vernon Cole ___ python-win32 mailing list python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32

Re: [python-win32] how to best use datetime objects in pywin32?

2009-01-13 Thread Vernon Cole
me.datetime.now(timezone.local) >>>gmt = datetime.datetime.now(timezone.utc) so, using Paul's suggestion: >>>now = datetime.datetime.now() >>>win32api.SetFileTimes("foo", now, now, now) and: >>>.win32api.SetFileTimes("foo", herenow, hereno

Re: [python-win32] Como usar unicode para ejecutar comandos de sistema

2009-01-23 Thread Vernon Cole
is part of the Python standard library, and questions should be sent to that list.) -- Vernon Cole On Fri, Jan 23, 2009 at 2:36 AM, Josu Rodriguez wrote: > Hola a todos, > > Tengo problemas para ejecutar comandos en el sistema, con caracteres > unicode. > > el problema es a

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

2009-01-26 Thread Vernon Cole
never have to pay for a redistribution license. -- Vernon Cole On Mon, Jan 26, 2009 at 10:28 AM, Liu, Donald (H USA) < donald@siemens.com> wrote: > Hi Mark, > > Thanks for your reply. I ran "dir c:\Windows\system32\py*.dll", and got > the following: > > C:\>

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

2009-01-26 Thread Vernon Cole
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

Re: [python-win32] Reading constants

2009-01-27 Thread Vernon Cole
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] How to calc amount of avail RAM in a process ?

2009-01-29 Thread Vernon Cole
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] Pythonwin crashes everytime

2009-02-01 Thread Vernon Cole
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] [pywin32-checkins] py3k status

2009-02-04 Thread Vernon Cole
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] [pywin32-checkins] py3k status

2009-02-05 Thread Vernon Cole
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] Unable to connect to MSSQL Database(x64) using pyodbc 32bit & python 32bit

2009-02-06 Thread Vernon Cole
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

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

2009-02-10 Thread Vernon Cole
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] Help required in opening a remote file in python.

2009-02-23 Thread Vernon Cole
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): &

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

2009-02-24 Thread Vernon Cole
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] OnCtlColor not working?

2009-03-02 Thread Vernon Cole
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] executing dos commands

2009-03-06 Thread Vernon Cole
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] Might be a easy problem.

2009-04-05 Thread Vernon Cole
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

[python-win32] Iron Python integration.

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

Re: [python-win32] Error 500 on IIS

2009-04-27 Thread Vernon Cole
"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

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

2009-05-26 Thread Vernon Cole
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] adodbapi and stored procedure output parameters on

2009-05-26 Thread Vernon Cole
, 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

2009-05-26 Thread Vernon Cole
-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] regarding invoking command prompt using python

2009-06-17 Thread Vernon Cole
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] regarding invoking command prompt using python

2009-06-17 Thread Vernon Cole
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

2009-06-18 Thread Vernon Cole
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

2009-06-18 Thread Vernon Cole
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] Shell extension debugging

2009-06-29 Thread Vernon Cole
;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] dbi module deprecated at 2.5. What to use in its place in 2.5, 2.6, and 3.0?

2009-07-08 Thread Vernon Cole
, 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] Copying a MS Access Table

2009-07-29 Thread Vernon Cole
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] Dealing with windows in Windows

2009-08-04 Thread Vernon Cole
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] [Fwd: Re: Running the COM MakePy Utility from python]

2009-08-27 Thread Vernon Cole
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

[python-win32] Fwd: win32 errata: AddSourceToRegistry

2009-11-04 Thread Vernon Cole
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] Compiling Python code to DLLs: Any way to do this

2009-11-08 Thread Vernon Cole
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

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

2009-11-09 Thread Vernon Cole
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] [pygtk] ANN: PyGUI 2.1

2009-11-15 Thread Vernon Cole
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] [pygtk] ANN: PyGUI 2.1

2009-11-16 Thread Vernon Cole
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] Python for Windows extensions

2009-11-16 Thread Vernon Cole
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

2009-11-16 Thread Vernon Cole
-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. > >

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

2009-11-28 Thread Vernon Cole
; >>> 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] [Pygui] Printing coordinate system problem

2009-12-14 Thread Vernon Cole
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

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

2009-12-15 Thread Vernon Cole
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] adodbapi upgrade

2009-12-15 Thread Vernon Cole
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] Apparent bug in COM browser on Vista

2009-12-16 Thread Vernon Cole
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] Apparent bug in COM browser on Vista

2009-12-16 Thread Vernon Cole
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] Setting a netboot within windows OS

2009-12-21 Thread Vernon Cole
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] odbc version

2009-12-29 Thread Vernon Cole
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] odbc version

2009-12-31 Thread Vernon Cole
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] Win API call to display a BMP/PNG file as a splash screen for a console app?

2010-03-23 Thread Vernon Cole
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] Windows freeze

2010-05-07 Thread Vernon Cole
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] Python, COM, VARIANT, VT_BYREF, Joy!

2010-05-24 Thread Vernon Cole
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] unable to read mssql varchar(max)

2010-05-27 Thread Vernon Cole
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] pywin32 services

2010-07-19 Thread Vernon Cole
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

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

2010-07-31 Thread Vernon Cole
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] FW: Problems with recordset object

2010-09-02 Thread Vernon Cole
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

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

2010-11-29 Thread Vernon Cole
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] odbc exceptions

2010-11-30 Thread Vernon Cole
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] odbc exceptions

2010-11-30 Thread Vernon Cole
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] Running GUI apps from a python/IIS web application

2010-12-01 Thread Vernon Cole
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] Access femap API, Type mismatch

2010-12-02 Thread Vernon Cole
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] Two questions

2010-12-19 Thread Vernon Cole
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] adodbapi returns None for text field in first row

2010-12-30 Thread Vernon Cole
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] Attempting to install pyWin32: Skipping exchdapi: No library 'Ex2KSdk' Skipping directsound: The header 'dsound.h' can not be located

2011-01-02 Thread Vernon Cole
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

2011-01-03 Thread Vernon Cole
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] odbc under windows 7?

2011-01-24 Thread Vernon Cole
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] odbc under windows 7?

2011-01-25 Thread Vernon Cole
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] error importing win32com for Dispatch

2011-01-31 Thread Vernon Cole
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] How to specify parameters in a query using odbc

2011-02-01 Thread Vernon Cole
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] FW: python-win32 image fields problem

2011-02-03 Thread Vernon Cole
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] InstallService TypeError: exceptions must be classes or instances not str

2011-02-07 Thread Vernon Cole
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] DVCS options for pywin32

2011-02-07 Thread Vernon Cole
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] IE (ocx) OK, but python never close

2011-02-09 Thread Vernon Cole
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] FW: python-win32 image fields problem

2011-02-18 Thread Vernon Cole
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] [ANN] pywin32 build 215 released.

2011-02-20 Thread Vernon Cole
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] Possible future direction for PyGUI on Win32

2011-02-27 Thread Vernon Cole
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] Possible future direction for PyGUI on Win32

2011-02-28 Thread Vernon Cole
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

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

2011-03-02 Thread Vernon Cole
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 trouble with pywin23-216 on python 3.2

2011-03-03 Thread Vernon Cole
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...

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

2011-03-04 Thread Vernon Cole
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] Mapping Drives in Python

2011-03-04 Thread Vernon Cole
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] print file byte contents distribution

2011-03-04 Thread Vernon Cole
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] Possible trouble with pywin23-216 on python 3.2

2011-03-05 Thread Vernon Cole
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] Conversion to Mercurial is done

2011-03-05 Thread Vernon Cole
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] Catching Send To in Office

2011-03-23 Thread Vernon Cole
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] unable to register a python com server

2011-04-07 Thread Vernon Cole
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 ..

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

2011-04-28 Thread Vernon Cole
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] Fw: [ pywin32-Bugs-3292681 ] adodbapi - Subtle crash

2011-04-28 Thread Vernon Cole
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

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

2011-05-17 Thread Vernon Cole
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

  1   2   >