What bitness (32 or 64) should MSSQL Server choose to work in tandem with Python?

Question

Python

The problem-free connection to the database is of interest. I want to order 64 bits, but I'm afraid because of the potential communication problems between the x32 ODBC driver and the x64 server, about which I googled information.
There will be 2 use cases (and we are talking about Python 2.x):
1. a Python application on a 32-bit Windows7 machine that works with a database server over the network
2. a Python application (32 bit GUI wx) that runs on on the same machine on which the database server "spins" (which is itself a 64-bit Windows Server)
Applications already exist and work now with MySQL, the task is to migrate the database to MSSQL (the reason for the migration is not technical, but administrative).

Answer 1

"640KB should be enough for everyone."
MS SQL loves RAM very much, so the question is - will 4 GB of database be enough for your application to work?
Even if enough - for how long?
By choosing a 32-bit solution, you immediately limit yourself. If there are problems with the application (and no one bothers to raise the test environment and check), then it is better to remake the application for compatibility with modern infrastructure.
In general, when buying MS SQL, you can use both 32 and 64 bit versions of the product, and decide after the purchase. Check this information with the sellers or with the melkosoft itself.