Initializing help system before first use

# insightgetsoldb

Purpose
Get information about the solution database for the current DMP solution.
Synopsis
`function insightgetsoldb:insightsoldb`
Return value
A record containing information required to connect to solution database
Example

    declarations
      ctx: insightcontext
      soldb: insightsoldb
    end-declarations
    ctx := insightgetcontext
    if ctx.dmp.ispopulated then
      soldb := insightgetsoldb
      writeln('The solution database can be accessed on server ', soldb.server, ' using account ', soldb.username)
    else
      writeln('The Insight app is not executing in DMP, so no solution database is available')
    end-if

Example of using insightgetsoldb to fetch information about the solution database.
Further information
1. When connecting directly to the database using mmodbc, it is easiest to call insightgetsoldbconnstr to fetch the ODBC connection string directly.
2. Attempting to use the solution database when the Insight app is not being run in DMP will cause the model to abort with an error. The ispopulated field of the insightdmpcontext record can be used to distinguish between an app executing within DMP ( true) and on-premise ( false).
3. Attempting to get the solution database when the model is not run though Xpress Insight will cause the model to abort with an error, except when test mode has been activated by setting insight_testmode.
4. When called from test mode, the value returned can be set by insightsetsoldb
Related topics
insightsoldb insightsetsoldb insightgetsoldbconnstr
Parent Topic Context

© 2001-2026 Fair Isaac Corporation. All rights reserved. This documentation is the property of Fair Isaac Corporation (“FICO”). Receipt or possession of this documentation does not convey rights to disclose, reproduce, make derivative works, use, or allow others to use it except solely for internal evaluation purposes to determine whether to purchase a license to the software described in this documentation, or as otherwise set forth in a written software license agreement between you and FICO (or a FICO affiliate). Use of this documentation and the software described in it must conform strictly to the foregoing permitted uses, and no other use is permitted.