Commcare Sync Connection String

Good day,

Please share the connection string format when using an Azure SQL Database on the Commcare Sync app.

Thank you,

Hi

Thanks for reaching out and welcome to the CommCare forum.

You can find instructions for generating the connection string on the help site: Generating Database Connection Strings - CommCare Public - Dimagi Confluence

1 Like

Hi Simon,

Thank you for a quick response. I checked the statements from the help site. Unfortunately I still get the error even though my connection string is in the below format:

mssql+pyodbc:///?odbc_connect=DRIVER%3D%7BODBC+Driver+17+for+SQL+Server%7D%3BSERVER%3Dtcp%3Aphakamisa.database.windows.net%3BPORT%3D1433%3BDATABASE%3Dphakamisa%3BUID%3Dphakamisa%3BPWD%3Dphakamisa

Thank you,