Database Connection Strings

Sqac requires a connection string in order to connect to the target database. Each of the supported databases has their own distinct connection string syntax.

Sqac presently supports MSSQL, MySQL, PostgreSQL, Sqlite3 and the SAP Hana database. You will need to know the db user-name / password, as well as the address:port and name of the database. Sample connection strings are provided as a reference.

MSSQL Connection String
cs := "sqlserver://SA:my_passwd@localhost:1401?database=my_dbname"
MySQL Connection String
cs := "my_uname:my_passwd@tcp(192.168.1.10:3306)/my_dbname?charset=utf8&parseTime=True&loc=Local"
PostgreSQL Connection String
cs := "host=127.0.0.1 user=my_uname dbname=my_dbname sslmode=disable password=my_passwd"
Sqlite3 Connection String
cs := "my_db_file.sqlite"

// or

cs = "my_db_file.db"
SAP Hana Connection String
cs := "hdb://my_uname:my_passwd@192.168.111.45:30015"