The Working with databases page states we “need to get the appropriate module for the database system you are interacting with and add it to your robot’s conda.yaml
file.” However, it doesn’t actually show us how to do that.
I get ModuleNotFoundError: No module named ’ pymssql’ when running the below.
I am trying to get a connection to a Microsoft 2017 SQL Server running on Linux. I see that pymssql has the library supporting it.
#conda.yaml file
channels:
# Define conda channels here.
- defaults
- conda-forge
dependencies:
# Define conda packages here.
# If available, always prefer the conda version of a package, installation will be faster and more efficient.
# https://anaconda.org/search
- python=3.7.5
- pip=20.1
- pip:
# Define pip packages here.
# https://pypi.org/
- rpaframework==7.1.1 # https://rpaframework.org/releasenotes.html
*** Settings ***
Documentation Template robot main suite.
Library RPA.Database
*** Tasks ***
Minimal task
Connect To Database pymssql MyDatabaseName ....