Cannot import pyodbc

Anvil Q&A
1

I try to use pyodbc like this:
import pyodbc
and I get
ModuleNotFoundError: No module named 'pyodbc'
Not all modules are available in client code. Click for more info

It his correct way to import it?

2

The packages listed here:Anvil Docs | List of Packages

are all available only on the server, not the client, as the error message says. Do that import in a server module (on a paid plan), and it’ll work.

3

Thanks. I can see now that is exactly what the message says.
Then I get another problem. The server in on the same net as my client, but I need to open the fw to external access to be able to access it from anvil server. I can probably get around that also.