Manager: 5/DbConfig

Server Configuration

If the server has not yet been connected to, the connection parameters are prompted for. These allow you to set the parameters to build a successful data connection. You might need the help of you database administrator to set these up.

Connection properties

Please enter the following:

• MsSqlServer name or ip address
• Database name on the server
• Database user login name
• Database user login password

CaseTalkManager.ini

The configuration file should resemble something as depicted below. Note the ODBC lines, the Server number and the Active state.

 [Settings]
 Server=1

 [db|0]
 name=Default
 dbuser$=...
 dbpwd$=...
 DataSource=localhost
 Catalog=CaseTalkDatabase
 OdbcParams=MARS_Connection=yes;AnsiNPW=yes;Encrypt=no
 OdbcDriver=SQL Server Native Client 17.0
 OdbcLibrary=msodbcsql17.dll
 active=False

 [db|1]
 name=Test
 dbuser$=...
 dbpwd$=...
 DataSource=localhost
 Catalog=master
 OdbcParams=MARS_Connection=yes;AnsiNPW=yes;Encrypt=no
 OdbcDriver=ODBC DRIVER 17 FOR SQL SERVER
 OdbcLibrary=msodbcsql17.dll
 active=True

Testing

Some CaseTalk Manager versions allow you to test the database connection. Even when the server is connected properly, the database may still be out of reach. To make sure that is also working, the Help\About should report a database version number.

If the database version number is not reported, the database itself is not yet connected and the configuration may need some manual adjustment as listed in the above paragraph about the casetalkmanager.ini.