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

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

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

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 p

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

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

Re: [python-win32] pywin32 Documentation

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

Re: [python-win32] pywin32 Documentation

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] Package giving Error while deploying to windows container

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] Outlook Add-In Demo Question ... A runtime error occurred during the loading of the com add-in

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] Outlook Add-In Demo Question ... A runtime error occurred during the loading of the com add-in

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

[python-win32] Very unimportant bug report.

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

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

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: > > >

Re: [python-win32] Seemingly incomplete installation

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

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

(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

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

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

Re: [python-win32] runas analog

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

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

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 >

[python-win32] Do we need dotnet 3.5?

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

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

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

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

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

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

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

Re: [python-win32] Bug reporting

ument in SourceForge that future updates will take place in the pywin32 repo. -- Vernon On Mon, Feb 26, 2018 at 5:53 PM, Mark Hammond <mhamm...@skippinet.com.au> wrote: > On 27/02/2018 5:40 am, Vernon D. Cole wrote: > >> Second: the effective "bus size" of the adodb

Re: [python-win32] Bug reporting

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

n the main manifest? @Mark -- please chime in here... > On Mon, Feb 19, 2018 at 11:59 AM, Bob Kline <bkl...@rksystems.com> wrote: > >> On Mon, Feb 19, 2018 at 11:18 AM, Vernon D. Cole <vernondc...@gmail.com> > wrote: > >> > >>> Sounds like a good plan. &

Re: [python-win32] Bug reporting

Sounds like a good plan. On Feb 19, 2018 04:57, "Bob Kline" <bkl...@rksystems.com> wrote: > On Mon, Feb 19, 2018 at 2:25 AM, Vernon D. Cole <vernondc...@gmail.com> > wrote: > > > I will try to clear this up as much as I can... > > Thanks very much f

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

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

Re: [python-win32] datetime values in adodbapi

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

Re: [python-win32] datetime values in adodbapi

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)") >

Re: [python-win32] Multiple versions of Python

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] To connect to a remote DB2(AS400) over Python, in any case do we have to pay to IBM for the driver?

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

Re: [python-win32] adodbapi changing autocommit

happy to 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 <vernondc...@gmail.com> > wrote: > >> Wait a bit... Did I just hear that there is a difference in operation >> between st

Re: [python-win32] adodbapi changing autocommit

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

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

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

Re: [python-win32] dbi.interalError

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,

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

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

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

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

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

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

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

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

Re: [python-win32] adodbapi 2.6.0.7 question

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] Issue with refresh of ODBC linked table and submitting credentials in excel using Python

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 https://support.office.com/en-ca/article/Overview-of-connecting-to-importing-data-c0ad7aec-ff1a-4e48-9c21-dc18a102433f . If that is

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

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

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

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: [python-win32] Opening Access (mdb) database: ADODB.Connection - Der Provider kann nicht gefunden werden

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 use the

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

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

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

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] Using pip to install pywin32

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

[python-win32] Resetting passwords

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

Re: [python-win32] adodbapi transaction counter

On Wed, Nov 12, 2014 at 7:32 AM, Jure Erznožnik jure.erznoz...@perftech.si 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

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

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 blairdh...@gmail.com wrote: I have a small python COM server that worked fine

Re: [python-win32] pip not working?

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

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

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

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

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

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

It might be possible to run some older versions of Excel on Linux using wine https://winehq.org/ or crossover https://codeweavers.com/products/, 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

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

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

, schrieb Vernon D. Cole: (if you have pip installed) pip install adodbapi --upgrade Worked, thank you very much. This looks as if I could install adodbapi without the rest of the windows extensions - right or wrong? Greetings, Sibylle

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

, this should 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 nulla.epist...@web.de An: Vernon D. Cole vernondc...@gmail.com Am 21.03.2014 09

[python-win32] Link to source code missing.

On the sourceforge.net/projects/pywin32 web page, the Code 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

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

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 Dispatch

Re: [python-win32] python 3.4 and pywin32

So why is _mine_ broken, too? What exactly did you clean up? On Mon, Mar 24, 2014 at 10:38 AM, Thomas Heller thel...@ctypes.org 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

Re: [python-win32] win32api on Windows 8

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\vernonpy Python 2.7.6 (default, Nov 10 2013, 19:24:18) [MSC v.1500 32 bit (Intel)] on win32

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

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

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

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

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] Issues with service startup

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

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

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] Passing string[] parameters to c# .NET function

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

[python-win32] adodbapi and .hgeol

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 been

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

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

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

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

Re: [python-win32] com proxy

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

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

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: [python-win32] Dropping support for Python 2.3?

. On 26/03/2013 8:33 PM, Vernon D. Cole wrote: 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

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

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

Re: [python-win32] pywin32 and virtualenv

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

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

unittest a few minutes ago. 2.4 support is hopeless. -- Vernon On Thu, Apr 25, 2013 at 4:09 AM, Vernon D. Cole vernondc...@gmail.comwrote: (P.S.: the remote and server modules require Pyro4, which in turn requires Python 2.6) I have carefully isolated the prerequisites so that they do

[python-win32] Python 3 -- Can't pickle class 'pywintypes.datetime'

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

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

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

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

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

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

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

[python-win32] Dropping support for Python 2.3?

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

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

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

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

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