Commcare Sync Connection String

Developers
1

Good day,

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

Thank you,

2

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 - CommCare Public

1 Like
3

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,