VIA Data Query Example Connection Strings

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;