Below is a list of example connection strings you can use to connect to VIA Data Query:
ADO.NET
Server=tcp:data-query.joinvia.com,1433;Database=ucportal_activity;User ID={your_login_here};Password={your_password_here};Trusted_Connection=False;Encrypt=True;Connection Timeout=30;
ODBC
Driver={SQL Server Native Client 10.0};Server=tcp:data-query.joinvia.com,1433;Database=ucportal_activity;Uid={your_login_here};Pwd={your_password_here};Encrypt=yes;Connection Timeout=30;
JDBC
jdbc:sqlserver://data-query.joinvia.com:1433;database=ucportal_activity;user={your_login_here};password={your_password_here};encrypt=true;hostNameInCertificate=*.database.windows.net;loginTimeout=30;