Sphinx won't update from SQL Server

Question

My Sphinx server was working to a greater or lesser extent using mySQL. The system I need to integrate into, however, is using SQL Server. Upon changing the config as below, changes aren't being brought over.

Is this because documents that have been changed in SQL Server can't override existing records in Sphinx or some other reason? Thanks.

Snippet of sphinx.conf.dist

source src1
{
    # data source type. mandatory, no default value
    # known types are mysql, pgsql, mssql, xmlpipe, xmlpipe2, odbc
    type            = odbc

    #####################################################################
    ## SQL settings (for 'mysql' and 'pgsql' types)
    #####################################################################

    # some straightforward parameters for SQL source types
    sql_host        = localhost
    sql_user        = test
    sql_pass        = test123
    sql_db          = test
    sql_port        = 1433  # optional, default is 3306

Answer 1

Using the "odbc_dsn" setting as suggested by Jeroen led me down the correct path to configuring the settings correctly.