Skip to main content

How can we help?

Frequently searched: Android devices, cloning, ADC Gallery, Glossary,...

Supervisor and CCA

Field management tutorials for Supervisor. All tutorials in this section can be applied to CAWI, CATI & CAPI surveys

In this article

    AskiaField connection strings for MS SQL Azure

     

     

    CCA

    Registry > HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Peter Holmes\Cca\Settings
    MainDatabase Driver={SQL Server Native Client 11.0};Server=tcp:[ServerAzureName].database.windows.net;Database=ASKIA_CCA;Uid=[SQL_Login]@[ServerAzureName];Pwd=[SQL_Password];Encrypt=yes

    SQL > CCA.DatabaseConnectionConfiguration
    Statistics Provider=SQLNCLI11; Data Source=tcp:[ServerAzureName].database.windows.net;Initial Catalog=ASKIA_STATISTICS; User ID=[SQL_Login]@[ServerAzureName]; Password=[SQL_Password];
    Surveys (Legacy) Provider=SQLNCLI11; Data Source=tcp:[ServerAzureName].database.windows.net;Initial Catalog=ASKIA_SURVEYS; User ID=[SQL_Login]@[ServerAzureName]; Password=[SQL_Password];
    Surveys Provider=SQLNCLI11; Data Source=tcp:[ServerAzureName].database.windows.net;Initial Catalog=ASKIA_SURVEYS; User ID=[SQL_Login]@[ServerAzureName]; Password=[SQL_Password];
    CTScript Provider=SQLNCLI11; Data Source=tcp:[ServerAzureName].database.windows.net;Initial Catalog=ASKIA_GLOBAL; User ID=[SQL_Login]@[ServerAzureName]; Password=[SQL_Password];
    Lists Provider=SQLNCLI11; Data Source=tcp:[ServerAzureName].database.windows.net;Initial Catalog=ASKIA_LISTS; User ID=[SQL_Login]@[ServerAzureName]; Password=[SQL_Password];

    WEBPROD

    Windows path > .\inetpub\wwwroot\webprod\global.asa
    strWebProdDatabase Provider=SQLNCLI11; Data Source=tcp:[ServerAzureName].database.windows.net;Initial Catalog=ASKIA_WEBINTERVIEWS; User ID=[SQL_Login]@[ServerAzureName]; Password=[SQL_Password];

    SQL > Webprod.WP_Const
    InterviewDbConnectionString Provider=SQLNCLI11; Data Source=tcp:[ServerAzureName].database.windows.net;Initial Catalog=ASKIA_WEBINTERVIEWS; User ID=[SQL_Login]@[ServerAzureName]; Password=[SQL_Password];

    ASKIAVISTA

    Registry > HKEY_LOCAL_MACHINE\SOFTWARE\Peter Holmes\AskiaVistaServer\Settings
    MainDatabase Provider=SQLNCLI11; Data Source=tcp:[ServerAzureName].database.windows.net;Initial Catalog=ASKIA_VISTA; User ID=[SQL_Login]@[ServerAzureName]; Password=[SQL_Password];

    Windows path > .\Askia\AskiaCtrl\askia.config
    MainDatabase Provider=SQLNCLI11; Data Source=tcp:[ServerAzureName].database.windows.net;Initial Catalog=ASKIA_VISTA; User ID=[SQL_Login]@[ServerAzureName]; Password=[SQL_Password];
    ReportDatabase Provider=SQLNCLI11; Data Source=tcp:[ServerAzureName].database.windows.net;Initial Catalog=ASKIA_VISTAREPORT; User ID=[SQL_Login]@[ServerAzureName]; Password=[SQL_Password];

     

    Notes

    CCA uses for databases:

    • CCA (main database) = ODBC
    • Everything else = OLEDB

    CCA converts this to an OLEDB connection string. So the connection strings (using https://www.connectionstrings.com/sql-azure/) should be:

    • CCA:
      Driver={SQL Server Native Client 11.0}; 
      Driver={SQL Server Native Client 11.0};Server=tcp:[ServerAzureName].database.windows.net;Database=ASKIA_CCA;Uid=[SQL_Login]@[ServerAzureName];Pwd=[SQL_Password];Encrypt=yes
    • Everything else: 
      Provider=SQLNCLI11; Data Source=tcp:[ServerAzureName].database.windows.net;Initial Catalog=ASKIA_STATISTICS; User ID=[SQL_Login]@[ServerAzureName]; Password=[SQL_Password];

     

    Related articles