A connection string follows the following structure:

    
Provider=SQLNCLI11.0;Persist Security Info=False;User ID=XXX;Data Source=XXX;Initial Catalog=XXX

To adapt the connection string to your database access parameters, simply replace the placeholders (XXX) with the following information:

User ID: The name of the user you have set up for access from Innosoft.
Data Source: Server name, port and instance name of the Microsoft SQL Server, in the following format: <SERVERNAME>[\<INSTANZNAME>][:PORT]
Initial Catalog: Name of the database to be used by Innosoft.

Innosoft.XML

Most Innosoft desktop applications get the information for establishing the database connection from an XML file called "Innosoft.xml". In the following template, insert the connection string in the element "ConnectionString" and enter the user's encrypted password directly below it in "Password". In the attribute "name" of the element "Client" you should give a meaningful name for the database connection.

Beispielhafte Innosoft.xml

<?xml version="1.0" encoding="UTF-8"?>
<Innosoft version="1.0">
  <Database>
    <Clients>
      <Client name="">
        <ConnectionString></ConnectionString>
        <Password></Password>
        <Type>MSSQL</Type>
      </Client>
    </Clients>
  </Database>
  <Options>
    <ResourcesPath>..\Resources</ResourcesPath>
    <ReportPath>.\Reports</ReportPath>
  </Options>
  <Debugging></Debugging>
  <Printing>
    <IniPath>.</IniPath>
  </Printing>
  <Logging>
    <Path>..\Logs</Path>
    <log4d:configuration xmlns:log4d="http://log4d.sourceforge.net" loggerFactory="TLogDefaultLoggerFactory" configDebug="false" threshold="Error">
      <renderer renderedClass="TComponent" renderingClass="TComponentRenderer"></renderer>
      <renderer renderedClass="TGuidedObject" renderingClass="TGuidedObjectRenderer"></renderer>
      <!-- Define appenders, with layouts and optional parameters. -->
      <appender name="ODS" class="TLogODSAppender">
        <layout class="TISLogLayout"></layout>
      </appender>
      <appender name="ToFile" class="TISLogFileAppender">
        <layout class="TISLogLayout"></layout>
        <param name="path" value="%configRef%"></param>
        <param name="fileName" value="%configRef%"></param>
        <param name="formatDateTime" value="ddmmyyyy_hh_nn"></param>
      </appender>
      <root>
        <level value="error"></level>
        <appender-ref ref="ODS"></appender-ref>
        <appender-ref ref="ToFile"></appender-ref>
      </root>
      <logger name="ObjNoTransfer" additive="false">
        <level value="info"></level>
        <appender-ref ref="ODS"></appender-ref>
      </logger>
      <appender name="ToFileForServer" class="TISLogFileAppender">
        <layout class="TISLogLayout"></layout>
        <param name="path" value="%configRef%"></param>
        <param name="fileName" value="ProtokollMax_Server.txt"></param>
      </appender>
      <logger name="GlobalServer" additive="false">
        <level value="all"></level>
        <appender-ref ref="ODS"></appender-ref>
        <appender-ref ref="ToFileForServer"></appender-ref>
      </logger>
    </log4d:configuration>
  </Logging>
  <Visual>
    <FormLoader></FormLoader>
    <Font></Font>
    <ColorScheme>SIX</ColorScheme>
    <PCEDesignerActive>False</PCEDesignerActive>
  </Visual>
  <DotNetIntegration></DotNetIntegration>
</Innosoft>

Innoconfig.xml

Some Innosoft web applications use a file called "Innoconfig.xml" instead. Here, too, you enter the connection string in the connectionstring element. Unlike the Innosoft.xml, the password is appended to the connection string here:

<CONNECTION STRING>;Password=<VERSCHLÜSSELTES PASSWORT>

Enter the name of the database connection in the element "name".

Beispielhafte innoconfig.xml

<?xml version="1.0" encoding="utf-8" ?>
 
<innoconfig>
  <database>  
    <mandant>
      <name></name>
      <type>MSSQL</type>
      <connectionstring></connectionstring>
      <initializeindividualobjectsonstartup>1</initializeindividualobjectsonstartup>
      <loadtabledescriptions>00</loadtabledescriptions>
      <loadnhibernatemappingsfrominnosoftbase>00</loadnhibernatemappingsfrominnosoftbase>
      <maxrows>1000</maxrows>
      <trimspaces>1</trimspaces>
    </mandant>
 
  </database>
 
  <log4net>
    <appender name="File" type="log4net.Appender.FileAppender">
      <file value="./Protokoll.txt" />
      <immediateFlush value="true"/>
      <appendToFile value="true" />
      <layout type="log4net.Layout.PatternLayout">
        <conversionPattern value="%date [%-5level] %logger - %message %exception%newline" />
      </layout>
    </appender>
 
    <!-- ============ LOGGING THE JSONFILESUPDATER TO A SEPARATE FILE ================ -->
 
 
    <appender name="JsonFilesUpdaterAppender" type="log4net.Appender.FileAppender">
      <file value="./JsonFilesUpdaterLog.txt" />
      <immediateFlush value="true"/>
      <appendToFile value="true" />
      <layout type="log4net.Layout.PatternLayout">
        <conversionPattern value="%date [%-5level] %logger - %message %exception%newline" />
      </layout>
    </appender>
 
 
    <logger name="JsonFilesUpdater" additivity="false">
      <level value="INFO" />
      <appender-ref ref="JsonFilesUpdaterAppender" />
    </logger>
 
 
    <!-- ============ LOGGING THE LIZENZFRAMEWORKS TO A SEPARATE FILE ================ -->
 
    <!--
    <appender name="LicenseAppender" type="log4net.Appender.FileAppender">
      <file value="./LicenseLog.txt" />
      <immediateFlush value="true"/>
      <appendToFile value="true" />
      <layout type="log4net.Layout.PatternLayout">
        <conversionPattern value="%date [%-5level] %logger - %message %exception%newline" />
      </layout>
    </appender>
 
    <logger name="Licensing" additivity="false">
      <level value="ALL" />
      <appender-ref ref="LicenseAppender" />
    </logger>-->
 
    <!--<logger name="NHibernate.SQL" additivity="false">
      <level value="ALL" />
      <appender-ref ref="File" />
    </logger>-->
 
 
    <!-- ============ LOGGING THE DBTransformers TO A SEPARATE FILE ================ -->
 
    <appender name="DBTransformerAppender" type="log4net.Appender.FileAppender">
      <file value="./DBTransformerLog.txt" />
      <immediateFlush value="true"/>
      <appendToFile value="true" />
      <layout type="log4net.Layout.PatternLayout">
        <conversionPattern value="%date [%-5level] %logger - %message %exception%newline" />
      </layout>
    </appender>
 
 
    <logger name="DBTransformer" additivity="false">
      <level value="INFO" />
      <appender-ref ref="DBTransformerAppender" />
    </logger>
 
    <root>
      <level value="ERROR" />
      <appender-ref ref="File" />
    </root>
  </log4net>
 
</innoconfig>