Read the default profile

The top section of the ini file contains profiles which are a list of the different projects available from Smart Instrumentation.

e.g.

[PROFILES]

DATABASE1=dbProjectA

DATABASE2= dbProjectB

DEFAULT= dbProjectA

 In the example above ‘dbProjectA’ is used, But if there is no default in the ini file, generic ‘database’ is used.

Read Specific Project Data from the profile

In the example below, ‘ORA’ is used as the type of database. Other supported types are ‘MSS’ for MS SQLServer and ‘ODBC’ for Sybase.

[dbProjectA]

AUTOCOMMIT=0

COMMIT=100

CONTINUE=N

DATABASE=ORCL

DATABASEPASSWORD=

DBMS=ORA

DBPARM=PBCATALOGOWNER='OWNER',DISABLEBIND=1

DSN=

LOGID=UID

LOGPASSWORD=PASS

PROMPT=110

SECURITYSCHEMAPASSWORD=INTOOLS_LOGIN

SERVERNAME=ORCL

STAYCONNECTED=1

TABLEDIR=0

USERID=

The three properties in brick boldface are formatted in the connection string along with the driver string.

e.g.

"Driver={Oracle in OraDB19Home1};DBQ=ORCL; UID=UID; PWD=PASS;"

The PROJECT and COMPONENT_CATEGORY tables from the Oracle Database are used to initialize this form. The Oracle service and an instance should be started and the user should have permission to query the tables.

 

Figure 1 - Server, Login, and Password should be correct in ini file, Driver is read from registry and Type must be Oracle