[Python] SAP Connection failed: name 'Connection' is not defined, PyRFC in django

I'm experiencing an issue with the PyRFC library in my Django project running on Pythonanywhere server. Specifically, I am trying to use the Connection class from PyRFC to establish a connection to an SAP system, but I am encountering an ImportError when I try to import Connection in my views.py file. The error message says:

SAP Connection failed: name 'Connection' is not defined
​

However, when I test the same code in the Django shell, everything works fine, and the Connection class is correctly imported. I have verified that the environment variables SAP_NWRFC_HOME and LD_LIBRARY_PATH are set correctly, and the libsapnwrfc.so library loads successfully.

If I do import like from PyRFC import Connection, then it gives the error:

2025-01-22 07:28:52,598: Error running WSGI application
2025-01-22 07:28:52,599: ImportError: cannot import name 'Connection' from 'pyrfc' (/home/moeez007/.local/lib/python3.10/site-packages/pyrfc/__init__.py)
2025-01-22 07:28:52,599: File "/var/www/moeez007_pythonanywhere_com_wsgi.py", line 80, in <module>
2025-01-22 07:28:52,600: from pyrfc import Connection


I also have tried to set the environment variables in the wsgi file

import os
os.environ["SAP_NWRFC_HOME"] = "/home/moeez007/nwrfcsdk"
os.environ["LD_LIBRARY_PATH"] = "/home/moeez007/nwrfcsdk/lib"


But still the same, I also have tried to run this as a separate file but still the same.

Why is it working in the Django shell and python but not in the view?

This is the code for my connection view:

import pyrfc
from pyrfc import *
logger = logging.getLogger(__name__)


def sap_conn_test(request):
if request.method == "GET":
try:
print(os.environ.get("SAP_NWRFC_HOME"))
print(os.environ.get("LD_LIBRARY_PATH"))
sap_conn = XPL_SAP_CON.objects.first()
conn = Connection(
user=sap_conn.user_name,
passwd=sap_conn.password,
ashost=sap_conn.server_address,
sysnr=sap_conn.system_number,
client=sap_conn.client_number,
)
response = {
"message": "SAP Connection successful!",
"status": "success"
}
except Exception as e:
response = {
"message": f"SAP Connection failed: {e}",
"status": "error"
}
return JsonResponse(response)
return JsonResponse({"message": "Invalid request method.", "status": "error"})

Continue reading...