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];