View source for 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.

[[File:CtkMngr Database.png]]

= 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.