Setting up the MS SQL Driver

You must set up the MS SQL Driver before making Microsoft SQL connections to your data.

See Creating New Microsoft SQL Server Connections.

To set up the MS SQL Driver, follow these steps:

  1. Open an ssh terminal to the host machine.
  2. Enter the following command to login as the root user.
    $ sudo su
  3. Enter the following command to install the packages on the machine.
    $ yum install freetds freetds-devel
  4. Enter the following command to install the package group, Development Tools.
    $ yum groupinstall 'Development Tools'
  5. Enter the following command to install the MS SQL Driver.
    $ pip install pymssql 
    You must restart the Arcadia Visualization Server for changes to take effect.