Re: [python-win32] Makepy for Access on Win7

2013-03-08 Thread Vernon D. Cole
Hartmut: If what you are doing is copying data between an ACCESS table and something else that can be reached from ADO, you might want to consider doing the entire thing from Python using adodbapi. You can do that without even having a copy of Office on your computer. You can glean the connecti

[python-win32] (only in Python 3) decimal.Decimal cannot be converted to a COM VARIENT

2013-03-25 Thread Vernon D. Cole
Guys: I am starting work on an upgrade to adodbapi -- so I set up a new improved test layout and started running some baseline tests before changing any application code. I just tripped across this one: I don't know whether it is actually new or whether my new tests exposed something which has b

[python-win32] Dropping support for Python 2.3?

2013-03-26 Thread Vernon D. Cole
Perhaps it is time... I found a copy of Python 2.3 to load onto a new computer in order to test my software, but it was not easy. It is in the small print about four pages down from the download page on python.org. I was one of 432 people who have downloaded the 2.3 installer for pywin32 build 2

[python-win32] Remote ado: should I use PyRO or DCOM?

2013-04-07 Thread Vernon D. Cole
Dear Gurus: I have committed to the django community that I would provide a prototype remote adodbapi function -- so that django running on Linux will be able to open a MS SQL Server database. This work, if successful, may be expected to result in SQL Server support becoming part of mainstream dja

[python-win32] survey question: should data from database columns of type "adGUID" be returned as instances of class "uuid"?

2013-04-14 Thread Vernon D. Cole
I am doing a major update to adodbapi, and have an ideal opportunity to add a new feature ... but I want to see whether it is a desirable feature... When reading data from database columns of decimal or date-time data, I return them to the user as Python decimal.decimal or datetime.datetime instan

Re: [python-win32] survey question: should data from database columns of type "adGUID" be returned as instances of class "uuid"?

2013-04-15 Thread Vernon D. Cole
I thought Mark approved dropping 2.4. Did I misunderstand? -- Vernon On Mon, Apr 15, 2013 at 10:04 AM, Roger Upole wrote: > I think the uuid module was introduced in python 2.5, might want to bear > that in mind. > > Roger > > "Vernon D. Cole" wrote i

[python-win32] Python 3 --> Can't pickle

2013-04-18 Thread Vernon D. Cole
Help me, Obiwan Kanobi... I have been tracking this one down, for two days, and have cleaned by my data conversion routines and the documentation for them as a result. but I can't determine the "right" way to fix this. This works fine in Python 2, but in Python 3, the class of a datetime retriev

Re: [python-win32] pywin32 and virtualenv

2013-04-18 Thread Vernon D. Cole
The installers will find the correct installation from the Windows registry, and will install in the correct place, side by side, system wide. I have installations varying from Python 2,3 to Python 3.3-64 on my laptop. Since installing Python 3.3, with its new Python loader, I have almost stopped

Re: [python-win32] Dropping support for Python 2.3?

2013-04-25 Thread Vernon D. Cole
This has also been discussed in the GUID thread, but I am bringing it back to this one... I have basically completed the work of breaking adodbapi up into a package of smaller modules. It has really helped to make the code more readable. There is now a "remote" module, so that a programmer (on Win

Re: [python-win32] pywin32 and virtualenv

2013-04-25 Thread Vernon D. Cole
Dinesh: Unless you plan on modifying the C language code of pywin32, or need to add C language routines of your own, there is absolutely no advantage in building pywin32 from source. In almost all cases you are better off downloading the pre-built installers. (( If you ARE one of those rare C p

Re: [python-win32] Dropping support for Python 2.3?

2013-04-25 Thread Vernon D. Cole
m adding to adodbapi will work in Python 2.5, and passed unittest a few minutes ago. 2.4 support is hopeless. -- Vernon On Thu, Apr 25, 2013 at 4:09 AM, Vernon D. Cole wrote: > > > (P.S.: the "remote" and "server" modules require Pyro4, which in turn > requires Pyth

[python-win32] announcing Beta test of adodbapi v2.5 with Linux remote from Windows server data access

2013-04-28 Thread Vernon D. Cole
I have tested this with Python 2.5 and up to 3.3. It tests well, but I would like to have a few other people look at it before committing to pywin32 release. This involved major re-factoring, so I may have missed something that the unit tests do not catch. Use of the server or remote sub-modules re

Re: [python-win32] Dropping support for Python 2.3?

2013-04-28 Thread Vernon D. Cole
lding it :) I can't recall if 2.4 is built with >> vc6 >> too - if so, we might as well kill that too. >> >> Cheers, >> >> Mark. >> >> On 26/03/2013 8:33 PM, Vernon D. Cole wrote: >> >> Perhap

Re: [python-win32] com proxy

2013-05-10 Thread Vernon D. Cole
Eric: Interesting timing. I assume you and your fellow "bunch of crips" are motion impaired. I happen to be in Africa just now working on the polio vaccination effort in an attempt to reduce additions to your group. My mother-in-law (a polio victim) was quadriplegic and used breathing assistanc

[python-win32] adodbapi versions and Python 2.4 -- a status report.

2013-06-04 Thread Vernon D. Cole
I have just released an upgraded version (2.5.0) of adodbapi on its sourceforge site. http://sf.net/projects/adodbapi ( I suppose that I should say here, for the benefit on new readers, that adodbapi is a PEP 249 compliant database api module which ships as part of pywin32, as well as being avail

[python-win32] Notice: Restriction on use of adodbapi remote server with Pyro4 version 2.20

2013-06-13 Thread Vernon D. Cole
Pywin 32 users: Anyone trying the new ADO remote/proxy feature of adodbapi: Pyro 2.20 (just released) uses a new serializer which does not handle decimal or datetime data types. If you update your Pyro4, you need to switch back to the old pickle serializer by defining the environment variable PY

[python-win32] adodbapi and .hgeol

2013-06-14 Thread Vernon D. Cole
I found the following on [pywin32-checkins] this morning: diff -r 4ded0a838f8c -r 1594b8c27383 .hgeol > --- a/.hgeolMon Apr 29 10:01:40 2013 -0400 > +++ b/.hgeolThu Jun 13 18:29:09 2013 +1000 > @@ -2,4 +2,8 @@ > **.dsp = CRLF > **.dsw = CRLF > **.vbp = CRLF > +# adodbapi appears to have be

Re: [python-win32] Passing string[] parameters to c# .NET function

2013-07-19 Thread Vernon D. Cole
Reaching to a .NET assembly from traditional ("non managed") code such as CPython is not easy. Have you looked at IronPython? It is true Python, but is an implementation written in .NET, so it interacts with .NET assemblies much more easily. (Unfortunately, it has no ability to talk to Pywin32 fu

Re: [python-win32] embedded python can't import win32api

2013-09-04 Thread Vernon D. Cole
Dear David: Perhaps someone on this list can give a better answer than the one I am about to give -- because I don't like what I am going to say... ActiveState repackages Python, pywin32, and several other products in order to make it easier to install all of them together, and they call their

Re: [python-win32] Issues with service startup

2013-10-08 Thread Vernon D. Cole
This answer is a bandage, not a cure, but perhaps it will be enough in your case... The first moments of operation when a system (especially a server) is booting up are replete with programs demanding resources which may not be available yet. I found that simply adding a Python time.sleep() call n

Re: [python-win32] how to access SHOpenFolderAndSelectItems() by ctypes

2013-12-13 Thread Vernon D. Cole
Right. You can't call a Windows service unless you are on Windows. You will want to build a "shim" function which you call with a generic name. It looks at what operating system it is running on, and then calls the appropriate operating system specific code to perform the operation. The import

Re: [python-win32] optimizing code to read serial port

2014-02-15 Thread Vernon D. Cole
Tony: Don't do it! Do not attempt to make your data transfer faster while using this defective hardware design! Trust me on this. I have been doing serial port data transfer since 300 baud was fast. The problem with your data transfer speed is not your program optimization. It is contained

Re: [python-win32] optimizing code to read serial port

2014-02-15 Thread Vernon D. Cole
I second the suggestion to try pySerial. I have used it for years to control RS-232 equipment -- don't know why I did not think of that. Like Terra-Term, pySerial will use device-level, rather than file-level APIs to talk to the UART. Of course, your success will depend a great deal on the skill

Re: [python-win32] win32api on Windows 8

2014-03-11 Thread Vernon D. Cole
I updated the Python version on my Windows 8.1 box to match yours exactly, and here is what I see: Microsoft Windows [Version 6.3.9600] > (c) 2013 Microsoft Corporation. All rights reserved. > > C:\Users\vernon>py > Python 2.7.6 (default, Nov 10 2013, 19:24:18) [MSC v.1500 32 bit (Intel)] > on win

Re: [python-win32] Python 3.4: adodbapi.connect(..) crashes

2014-03-21 Thread Vernon D. Cole
Argh! I personally had not gotten around to trying Python 3.4 yet. The pythoncom package is widely used and I can't imagine that the lack of it got past our normal QA tests. I will check on this as soon as I get off work. In the meantime, you should be able to have many versions of python loade

Re: [python-win32] python 3.4 and pywin32

2014-03-24 Thread Vernon D. Cole
So why is _mine_ broken, too? What exactly did you clean up? On Mon, Mar 24, 2014 at 10:38 AM, Thomas Heller wrote: > Am 21.03.2014 21:22, schrieb Thomas Heller: > > [this has also been sent to the python-dev mailing list] >> >> With python 3.4 and pywin32 version 218 it is only possible >>

Re: [python-win32] Global ActiveScripting object not visible

2014-04-15 Thread Vernon D. Cole
The message means that no one has defined a meaning for the name "DOpus" to Python. You, as a programmer, must define that name. If you say: >>>DOpus = "Spam and Eggs" then you have defined it as a character string which contains three English words. If you say: >>>from win32com.client import Di

Re: [python-win32] Global ActiveScripting object not visible

2014-04-15 Thread Vernon D. Cole
One other thing to check: are Python and DO11 this same 32 or 64 bit-ness? 32 bit programs cannot talk to 64 bit COM, and vice-versa. On Tue, Apr 15, 2014 at 2:49 PM, Łukasz Jakubowski wrote: > Hi Vernon, > > Thanks for the answer. > > The DOpus object is not supposed to be created by a user w

[python-win32] Link to source code missing.

2014-04-21 Thread Vernon D. Cole
On the sourceforge.net/projects/pywin32 web page, the tab, and all pointers and links to the hg repository seem to have disappeared. I a change of some kind in the works? (or announced and my Alzheimer's is kicking in?) [Fortunately, I happen to have an old repo lying around which still rememb

Re: [python-win32] Fwd: Re: Python 3.4: adodbapi.connect(..) crashes

2014-04-25 Thread Vernon D. Cole
ould have gone to the list! > > Sibylle > > Original-Nachricht > Betreff: Re: [python-win32] Python 3.4: adodbapi.connect(..) crashes > Datum: Fri, 21 Mar 2014 20:39:43 +0100 > Von: Sibylle Koczian > An: Vernon D. Cole > > > Am 21.03.2014 09

Re: [python-win32] Build 219, adodbapi: no module apibase

2014-05-29 Thread Vernon D. Cole
Arrgh! You are quite correct. After completely removing and re-installing python 3.4, I get exactly the same result. It would appear that my changes in the layout of adodbapi were not updated in pywin32's distribution setup, but that error was masked in my testing by pre-existing files on my test

Re: [python-win32] Build 219, adodbapi: no module apibase

2014-05-29 Thread Vernon D. Cole
Ado is called using COM. adodbapi makes heavy use of the COM interface capabilities of pywin32 when running on CPython, or the built-in COM interface on IronPython. It requires one of the two. On Thu, May 29, 2014 at 11:02 AM, Sibylle Koczian wrote: > Am 29.05.2014 11:33, schrieb Verno

Re: [python-win32] save chart from an existing xlsx as an image

2014-06-20 Thread Vernon D. Cole
It might be possible to run some older versions of Excel on Linux using wine or crossover , but I do not think that you will be able to control them using COM. Python 2.7 (32 bit) for Windows and pywin32 can be installed using Wine, but many

Re: [python-win32] Build 219, adodbapi: no module apibase

2014-09-10 Thread Vernon D. Cole
Dear Edward: I feel your pain. The whole idea of including adodbapi as part of pywin32 was to eliminate having to download and install it as a separate product. Having it broken in this release sadly means a trip back in time to the bad old days. Here are the steps I took to attempt to reprodu

Re: [python-win32] Interactive Code to Script File

2014-09-16 Thread Vernon D. Cole
Dear D.J.: First, let me mention that you violated several of the unwritten rules of asking for help. For example, the code you typed into for email is not the same as the code in the picture you sent as an attachment (using a proprietary format). Code samples should be cut-and-paste, not retype

Re: [python-win32] pip not working?

2014-09-21 Thread Vernon D. Cole
Patrick: I am very sorry, but you are asking this question on the wrong list. This list is for Python for Windows Extension. You may find more productive answers on a list which specializes in either mac OS, or the lxml package. On Sun, Sep 21, 2014 at 9:26 AM, Patrick Asselman wrote: > Can

Re: [python-win32] Error R6034 when I import uuid

2014-10-17 Thread Vernon D. Cole
Which version of Python are you running? 32 or 64 bit? Which version of pywin32? Which version of Windows? Can you make a small test case that will demonstrate the error? On Thu, Oct 16, 2014 at 7:47 PM, Blair Hall wrote: > I have a small python COM server that worked fine with Excel until I >

Re: [python-win32] adodbapi transaction counter

2014-11-13 Thread Vernon D. Cole
On Wed, Nov 12, 2014 at 7:32 AM, Jure Erznožnik wrote: > if self.transaction_level == 0 *or self.transaction_level is None* > Rats! That's what I get for copying code that I don't really understand. My simple tests passed this as okay. I have changed the test to "if not self.transaction_level:"

[python-win32] Resetting passwords

2015-01-19 Thread Vernon D. Cole
As an aside to the recent discussion on storing passwords... Is there a way to (re)set Windows passwords using a pre-computed hash? I can use win32net.NetUserSetInfo() to reset a password, if I use the plain text of the password. My goal is to remotely set passwords on an arbitrary group of Windo

Re: [python-win32] Using pip to install pywin32

2015-02-20 Thread Vernon D. Cole
Pywin32 is mostly written in C, and has lots of dependencies and weird build requirements. In order to compile it, you must have the same C compiler that your release of Python was built with. For older Python versions (like 2.7) that compiler is obsolete and hard to find, so installs from source

Re: [python-win32] Oldest Python version for pywin32?

2015-04-15 Thread Vernon D. Cole
I concur. I am one of the 100 downloads of 2.5 -- and the only reason I download it is to test it, not to use it in production. How many of the other downloaders are like me? Most, I would bet. Dropping 2.5 would allow use of many Python3 features, since 2.6 has the backports for them (print func

Re: [python-win32] Transfer Access 2010 query results to python script for ArcGIS geoprocessing actions

2015-04-15 Thread Vernon D. Cole
You will probably need the help of an experienced Python programmer to do what you wish, but the tools are all available, and you came to the correct place to find them. [ -- almost -- Normally, adodbapi is included in pywin32, but Mark and I had a communications failure with the current release,

Re: [python-win32] Opening Access (mdb) database: ADODB.Connection - Der Provider kann nicht gefunden werden

2015-04-20 Thread Vernon D. Cole
I also cannot read German, and also I guess that you do not have the correct provider. There are numerous difficulties with 64 vs 32 bit providers for Access (Jet) databases. More information about providers can be found on the links in http://adodbapi.sourceforge.net/quick_reference.pdf I in re

Re: [python-win32] Opening Access (mdb) database: ADODB.Connection - Der Provider kann nicht gefunden werden

2015-04-20 Thread Vernon D. Cole
On Mon, Apr 20, 2015 at 7:49 AM, Niemann, Hartmut < hartmut.niem...@siemens.com> wrote: > [...] > > Is this the best way to access an mdb database from python (2.7) or what > would > > be preferred? > > > Rather than programming ADO by COM interface, you might find it easier or more convenient to

Re: [python-win32] Adodbapi date param error with MS access

2015-05-05 Thread Vernon D. Cole
Thanks for bringing this to attention. That exception was in the code (in a slightly different form) when I inherited it many years ago. There was once a note to the effect that it was needed to work around a bug in Access. It is very likely that the Jet database engine has been improved in the la

Re: [python-win32] Issue with refresh of ODBC linked table and submitting credentials in excel using Python

2015-06-22 Thread Vernon D. Cole
I think you are saying that you have an Excel spreadsheet which imports data from an ODBC data source, as talked about in Overview of connecting to (importing) data . If that is

Re: [python-win32] adodbapi 2.6.0.7 question

2015-08-20 Thread Vernon D. Cole
Andrey: Good catch. I have added the following to the quickref documentation for the "connection" class: .timeout # supply a value for CommandTimeout. Note: the "timeout" > connection value is stored in this attribute, and is used as the connection > timeout. It is then re-used as the command

Re: [python-win32] remote database changed causing odbc error

2015-09-02 Thread Vernon D. Cole
There are two different modules which you might be using to connect to an SQL Server database. The odbc module is very basic, written in C, and follows the db-api version 1 api. The adodbapi module is more complex, written in Python, and follows the db-api version 2 specification (PEP 249, with m

Re: [python-win32] adodbapi: Connection with 'WINCCOLEDBProvider.1' fails

2015-09-08 Thread Vernon D. Cole
On Mon, Sep 7, 2015 at 5:48 AM, Stefan Fuchs wrote: > 'WINCCOLEDBProvider.1' Your patch looks like the perfect answer. It has been included in the official source. -- Vernon Cole ___ python-win32 mailing list python-win32@python.org https://mail.pyt

Re: [python-win32] pip not running in windows 64

2015-12-26 Thread Vernon D. Cole
Dear Erick: I assume that you do not usually use the Python programming language. That will make it more difficult for people to help you, since we may not be communicating using the same vocabulary. A few things you should know:... 1) this (Python-win32) is not a group for the discussion of Pyt

[python-win32] pywin32 build 220 adodbapi loads incorrectly on Python3.

2016-02-20 Thread Vernon D. Cole
The error I made in the manifest files for adodbapi in the former release has been corrected, so adodbapi now installs correctly in Python 2. However, the conversion to Python 3 is in error. I shall track down that foul-up in due course. After installing build 220 on Python3, you will need to se

Re: [python-win32] dbi.interalError

2016-05-05 Thread Vernon D. Cole
More information about your program would be helpful. There are at least three ways that connections to SQL Server might be obtained in Python. In general, it would seem that the version of Python may have changed. The bit-width of the SQL Server server should not affect a data client. On Thu, Ma

Re: [python-win32] shell_view.py folder not browsable

2016-07-06 Thread Vernon D. Cole
I seem to be suffering from a lack of context... What example are you referring to? On Wed, Jul 6, 2016 at 5:42 PM, Kurt Eilander wrote: > Hey all, >> >> I was hoping to create my own IShellFolder in python, but there seems to >> be something wrong with the example on my system. >> (Win7 64bit,

Re: [python-win32] adodbapi changing autocommit

2016-10-24 Thread Vernon D. Cole
Wait a bit... Did I just hear that there is a difference in operation between starting a connection with autocommit=false and turning autocommit off during a session? If so, I think that's a bug. PEP-249 has no hook for explicitly starting a transaction, so adodbapi needs to always have done Beg

Re: [python-win32] adodbapi changing autocommit

2016-10-25 Thread Vernon D. Cole
file it using whatever the appropriate > procedure is (if where we're at isn't enough :)). > > On Mon, Oct 24, 2016 at 2:57 PM, Vernon D. Cole > wrote: > >> Wait a bit... Did I just hear that there is a difference in operation >> between starting a connectio

Re: [python-win32] To connect to a remote DB2(AS400) over Python, in any case do we have to pay to IBM for the driver?

2017-06-23 Thread Vernon D. Cole
This forum is appropriate. It has been a number of years since I looked at the code I used for what you ask (perhaps I have an old copy of source laying around) but if I recall correctly, I used the OLE DB Provider. I am not aware of any licensing issues -- perhaps the company already had some ki

Re: [python-win32] Multiple versions of Python

2017-10-08 Thread Vernon D. Cole
Damine: The answer provided by Denis was correct, but is most helpful only in environments where you are developing projects with different prerequisite requirements. For that, you will want to use the Python virtual environment package, aided by virtualenvwrappor.

Re: [python-win32] datetime values in adodbapi

2017-11-06 Thread Vernon D. Cole
Y On Sat, Nov 4, 2017 at 6:27 AM, Bob Kline wrote: > The adodbapi package does not seem to handle datetime values appropriately. > > import adodbapi > print(adodbapi.version) > cursor = adodbapi.connect(...) > cursor.execute("CREATE TABLE #t (i INT, d DATETIME)") > cursor.execute("INSERT INTO #t

Re: [python-win32] datetime values in adodbapi

2017-11-06 Thread Vernon D. Cole
? -- Vernon Cole On Mon, Nov 6, 2017 at 7:59 AM, Vernon D. Cole wrote: > Y > > On Sat, Nov 4, 2017 at 6:27 AM, Bob Kline wrote: > >> The adodbapi package does not seem to handle datetime values >> appropriately. >> >> import adodbapi >> print(adod

Re: [python-win32] datetime values in adodbapi

2017-11-07 Thread Vernon D. Cole
The real question here is where the significance gets lost. It's hard to get a handle on what is really in the tables. Also, the time conversion routines (both in and out of the database) are a mass of confusion. Obviously Bob has found a where a value an internal form blows up when fed directly b

[python-win32] sudo.py -- publish to pypi or gist?

2018-02-16 Thread Vernon D. Cole
I finished work on a new module today -- it is called "sudo.py" and does pretty much what you would expect. If executed as a main program, on Linux or MacOS, it just runs "sudo" which is not very exciting. On Windows, it requests elevation and runs a command as an Administrator, which is a capabil

Re: [python-win32] Bug reporting

2018-02-18 Thread Vernon D. Cole
or body 'help' to > >>> python-win32-requ...@python.org > >>> > >>> You can reach the person managing the list at > >>> python-win32-ow...@python.org > >>> > >>> When replying, please edit your Subject line so it is mo

Re: [python-win32] Bug reporting

2018-02-19 Thread Vernon D. Cole
Sounds like a good plan. On Feb 19, 2018 04:57, "Bob Kline" wrote: > On Mon, Feb 19, 2018 at 2:25 AM, Vernon D. Cole > wrote: > > > I will try to clear this up as much as I can... > > Thanks very much for your reply, Vernon. > > > Adodbapi lives in

Re: [python-win32] Bug reporting

2018-02-21 Thread Vernon D. Cole
ing them in the main manifest? @Mark -- please chime in here... > On Mon, Feb 19, 2018 at 11:59 AM, Bob Kline wrote: > >> On Mon, Feb 19, 2018 at 11:18 AM, Vernon D. Cole > wrote: > >> > >>> Sounds like a good plan. > >> > >> As in, "yes, l

Re: [python-win32] Bug reporting

2018-02-26 Thread Vernon D. Cole
There are two problems with the existing SourceForge repo of adodbapi. First, the manual copy of updates to the pywin32 code base can easily fail -- as it did several years ago and I missed the resulting error which remained unfixed for several releases of pywin32. That problem was exacerbated by

Re: [python-win32] Bug reporting

2018-03-04 Thread Vernon D. Cole
) document in SourceForge that future updates will take place in the pywin32 repo. -- Vernon On Mon, Feb 26, 2018 at 5:53 PM, Mark Hammond wrote: > On 27/02/2018 5:40 am, Vernon D. Cole wrote: > >> Second: the effective "bus size" of the adodbapi repo is *one*. The oth

Re: [python-win32] Dispatching something that requires elevation

2018-06-09 Thread Vernon D. Cole
look in github.com/salt-bevy/sudo.py for a module which will request elevated privileges for a Python script running as a normal user. Perhaps that can help create a solution for your use case. There is a sample call fo

Re: [python-win32] Python 3.7: difficulties importing adodbapi after installation

2018-08-17 Thread Vernon D. Cole
The hassle is because I have not fulfilled my responsibility to keep adodbapi maintained properly for these last few years. I now work in a Linux shop and have almost nothing to do with databases, so my work on Windows database software keeps taking a back seat to other responsibilities. This week

Re: [python-win32] adodbapi: paramstyle 'named' doesn't work as expected

2019-02-25 Thread Vernon D. Cole
Sibyille: Thanks for the report and the excellent analysis. I was afraid no one would ever use "named" paramstyle. Dennis: Any code suggestion would be very welcome. Would you be able to suggest a patch? -- Vernon Cole On Sat, Feb 23, 2019 at 7:30 AM Sibylle Koczian wrote: > Am 21.02.201

[python-win32] Do we need dotnet 3.5?

2019-03-14 Thread Vernon D. Cole
I am trying to build a build machine (actually a script to build build machines) capable of creating a pywin32 distribution. (I need to test the distribution I am trying to fix.) Somewhere in there it seems that I need to have .net3.5 installed. I have been struggling with this all morning, and ha

Re: [python-win32] Do we need dotnet 3.5?

2019-03-15 Thread Vernon D. Cole
et-3-5-framework-on-windows-server-2012-without-dvd > > On Thu, Mar 14, 2019 at 1:29 PM Vernon D. Cole > wrote: > >> I am trying to build a build machine (actually a script to build build >> machines) capable of creating a pywin32 distribution. (I need to test the >

Re: [python-win32] runas analog

2019-03-18 Thread Vernon D. Cole
Perhaps ShellExecuteEx will do what you are wishing for? I found a good formula for starting a process as an administrator and it is packaged in a small module tries to emulate a "sudo" command. You might look at the cod

[python-win32] almost there -- running "py -2 setup.py install"

2019-03-27 Thread Vernon D. Cole
I have been working for a while on writing a script to provision a machine to be able to build pywin32 using downloadable components, the most important of which is the VCforPython27 compiler package. It seems that in packaging that compiler, at least one header file needed to build pywin32 was le

[python-win32] Announcement: adodbapi source code moved to pywin32/adodbapi

2019-11-25 Thread Vernon D. Cole
(adodbapi is a pure-Python PEP-249 compliant SQL interface for Windows using Microsoft ADO. It can access numerous database engines using ADO providers or ODBC drivers, and features such leading-edge enhancements as named-column data retrieval and user-selected query parameter styles.) For anyone

Re: [python-win32] Seemingly incomplete installation

2020-03-04 Thread Vernon D. Cole
Do not expect Start Menu tools. If you select the installation option to add Python to your path, then the scripts directory is also added to the path, which will make all the tools work -- from the command line. Having said that, adding them to the start menu would be pointless, because they are

Re: [python-win32] How to install pywin32 for Text only/TTY, excluding all GUI components

2020-05-26 Thread Vernon D. Cole
Tim: I don't understand. If I include pywin32 as a pip requirement, then I get the whole thing, I think. How can I "ship a package" without carrying the unneeded parts around? On Sun, May 24, 2020 at 12:28 AM Tim Roberts wrote: > On May 23, 2020, at 4:27 AM, Markus Kramer > wrote: > > > Hel

[python-win32] Very unimportant bug report.

2020-06-18 Thread Vernon D. Cole
I am testing the installation of our newest version 228 of pywin32. When attempting to install pywidn32 on the 32-bit version of Python 3.8 on *Windows 7 *32 bit, I get the following error: "The procedure entry point ucrtbase.terminate could not be located in the dynamic link library api-ms-win-cr

Re: [python-win32] Outlook Add-In Demo Question ... A runtime error occurred during the loading of the com add-in

2021-12-08 Thread Vernon D. Cole
Most likely, you are running a 64 bit version of Python. Due to Windows restrictions, only 32 bit programs can talk to each other. If you download and install a 32 bit version of Python, you may find success. PyCharm and Windows will happily allow multiple versions of Python to work alongside each

Re: [python-win32] Outlook Add-In Demo Question ... A runtime error occurred during the loading of the com add-in

2021-12-08 Thread Vernon D. Cole
Thanks, Tim. Your depth of knowledge is appreciated. I have never understood the "magic" which happens when you make a COM call. Now it all makes sense why 32 and 64 bit COM are mutually incompatible. On Wed, Dec 8, 2021 at 1:52 PM Tim Roberts wrote: > Vernon D. Cole wrote: &g

Re: [python-win32] Package giving Error while deploying to windows container

2022-05-19 Thread Vernon D. Cole
Django also runs on Windows, and I have operated it there for testing purposes, but it is most at home in a Linux environment. I have never (personally) run it in a container. I prefer the better performance and ease of use when installed directly on the server. Containers may deploy more quickly,

Re: [python-win32] pywin32 Documentation

2022-12-06 Thread Vernon D. Cole
The most important document for adodbapi is in Markdown. (That's an improvement - - I wrote it in .odt) so if that helps the decision, I would say lean toward that direction. It needs to be linked / indexed in where people can actually find it. adodbapi/quick_reference.md

Re: [python-win32] pywin32 Documentation

2022-12-06 Thread Vernon D. Cole
Brian: I did not see your entry before writing mine. Fantastic work on the adodbapi calling interfaces! I think that there is still a need for something like the quick_reference, so that there can be discussion about things like the extensions. The ability to switch between paramstyles is probab

Re: [python-win32] How to search Windows file structure (with existing indexes)

2023-08-09 Thread Vernon D. Cole
Because pywin32 is required for adodbapi to operate, it was merged into pywin32 several years ago. Installing a current version of pywin32 will install adodbapi as part of it. It will appear as a separate module in the Python site-packages library tree. I have never tried accessing the Windows fil

Re: [python-win32] How to search Windows file structure (with existing indexes)

2023-08-09 Thread Vernon D. Cole
For reading file directories I recommend using pathlib from the Python standard library. On Wed, Aug 9, 2023 at 12:40 PM Vernon D. Cole wrote: > Because pywin32 is required for adodbapi to operate, it was merged into > pywin32 several years ago. Installing a current version of pywin3

Re: [python-win32] Recommended web server implementation to actively run multiple flask web apps on a windows machine

2023-09-07 Thread Vernon D. Cole
I highly recommend nginx. I also highly recommend NOT running a web server on Windows. On Wed, Sep 6, 2023 at 1:14 AM Jacob Kruger wrote: > Hi there > > > My primary development focus at the moment is web applications, using > the flask web-framework, and, while, in development, I can just run