Difference between revisions of "Manager:5/DbConfig"

From CaseTalk Wiki
Jump to: navigation, search
(Copied from Manager:4/DbConfig, revision 507)
 
m
Line 10: Line 10:
* Database user login name
* Database user login name
* Database user login password
* 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
  [CaseTalk]
  Application=Y:\CaseTalk.XE\develop\apps\CaseTalk\build\CaseTalk.exe
  [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

Revision as of 08:05, 27 September 2023

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.

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
 [CaseTalk]
 Application=Y:\CaseTalk.XE\develop\apps\CaseTalk\build\CaseTalk.exe
 [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