Summary
The article describes the various database connection strings that may be used when connecting InfoBurst to a database. Database connections strings are used when connecting InfoBurst to the database where the InfoBurst repository is hosted or when creating a Database Connection.
Connection Strings
A connection string defines the location of the target database. String syntax may vary based and type and configuration of the target database. Known connection strings are listed below. Consult your DBA for the appropriate connection string if none of those listed work in your environment.
SQL Server
A port number should only be provided when the port is other than the SQL Server default.
- <SERVER>
- <SERVER>\<INSTANCE>
- <SERVER>:<PORT>
- <SERVER>:<PORT>\<INSTANCE>
- <SERVER>,<PORT>
- <SERVER>\<INSTANCE>,<PORT>
Oracle
InfoBurst uses the Microsoft Oracle Managed Data Access driver which requires a connection string. A port number should only be provided when the port is other than the Oracle default.
- <HOST>/<SID>
- <HOST>:<PORT>/<SID>
- //<HOST>/<SID>
- //<HOST>:<PORT>/<SID>
- //<HOST>:<PORT>:<SID
Custom Oracle Connections
See Custom Oracle Connections for details for about using Oracle connection aliases and parameters.