How to connect robot framework with SQL Database

Hi! I’m new in RPA’s world and I want to connect my robot to SQL Server Database but when I ran this line:

*** Tasks ******
Connect To Database pymssql database user password Host port

I have de next error: ModuleNotFoundError: No module named ‘pymssql’

I’ve already installed pymssql but I don’t know how to add this module in my conda.yaml

Welcome @dianiv_26, one example

channels:
  # Define conda channels here. 
  - 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==10.9.0 # https://rpaframework.org/releasenotes.html
    - pymssql==2.2.2
2 Likes

Hi @dianiv_26,

We also have a short “get started” guide here:

Br, Kari

2 Likes