This function is used to define database settings and connection methods.
SetDatabaseSettings(Byval Server as String, Byval Database as String, Byval SQLServerAuthentication as Boolean, Optional Byval UserName as String = "", Optional Byval Password as String = "") as Boolean
The server you want to connect to
The database you want to open
True if you want to connect using username and password
False if you want to connect using Windows Authentication
The name of the account to connect with
The password corresponding to the above username
Returns a boolean value. True if succeded, false if not.