Problem SQL Database Connector

Hello Bubblers,
i am trying to connect to Microsoft for 3 days now.
If my string to connect to database with my code is

connectionStrings
add name=“ERPConnection” connectionString=“Data Source=222.874.71.111, 15902;Initial Catalog=Dbase;User ID=so;password=pass@word” providerName=“System.Data.SqlClient” />
connectionStrings

so to fit this string to bubble SQL connector i have put
mssql://so:pass@word@222.874.71.111:3306/Dbase

and i have chosen database type to be Microsoft SQL. i am getting an error

Your connection string does not fit the standard string. It should look like mysql://username:password@my-db-instance.endpoint.us-east-1.rds.amazonaws.com:PORT/db_name.

what is happening? what did i put wrong? my password has @ i have removed it and tried something else but i get same error.

1 Like