Hi everyone,
I am trying to connect my bot to a Microsoft SQL Server, using these configurations:
tracker_store:
type: SQL
dialect: "mssql+pyodbc"
db: "{ip address}/sqlexpress/{databaseName}" # path to your db
username: "username" #example value
password: "password"
but I am getting am error message:
rasa_core_1 | File "/usr/local/lib/python3.6/site-packages/sqlalchemy/connectors/pyodbc.py", line 37, in dbapi
rasa_core_1 | return __import__("pyodbc")
rasa_core_1 | ModuleNotFoundError: No module named 'pyodbc'
I downloaded pyodbc using pip:
pip install pyodbc
Requirement already satisfied: pyodbc in
c:\users\admin\appdata\local\programs\python\python36\lib\site-packages
I’ve also tried using dialect mssql+pymssql
but got the same error:
rasa_core_1 | File "/usr/local/lib/python3.6/site-packages/sqlalchemy/dialects/mssql/pymssql.py", line 61, in dbapi
rasa_core_1 | module = __import__("pymssql")
rasa_core_1 | ModuleNotFoundError: No module named 'pymssql'
pymssql is also installed with pip:
pip install pymssql
Requirement already satisfied: pymssql in c:\users\admin\appdata\local\programs\python\python36\lib\site-packages
Is there something I am missing or doing wrong? I am using Rasa version 1.0.1