SetupAltConnection

Structure

SetupAltConnection(sTier, sServerURI, sDBType, sServerOrSID, sDatabaseorHostIP, sUser, sEncryptedPass, sWindowsAuth, sOracleMode, sOraclePort, sOracleHome)

Type

Function

Return Value

String (Blank if succesfful, 'ERROR' if connection fails)

Description

This procedure will initiate a 2nd unique connection that can then be pointed towards 1 or more of the 10 td* datasets with the tdUseAltConnection procedure

Parameters: 11

sTier = 3 or 2

sServerURI = If sTier is a 3, then this setting should point to the server URI for the connection to the middle tier. If sTier is 2, then this parameter is ignored.

sDBType = ORACLE, FIREBIRD, or MSSQL

sServerOrSID = If sTier is 2 and MSSQL Server, then this parameter should be the Database Server Name. If sTier is 2 and Oracle (OCI or Direct), this should be the Oracle SID. If sTier is 2 and Firebird, this should be specified as SERVER:DATABASE. If sTier is 3, then this parameter is ignored.

sDatabaseOrHostIP = If sTier is 2 and MSSQL Server, then this parameter should be the Database Name. If sTier is 2 and Oracle Direct mode, this should be the Host IP. If sTier is 2 and Firebird, this should be blank. If sTier is 3, then this parameter is ignored.

sUser = If sTier is a 2, then this parameter should be the User Name to be used when logging into the database. If sTier is 3, then this parameter is ignored.

sEncryptedPass = If sTier is a 2, then this parameter should contain the encrypted password to be used when logging into the database. To create a encrypted password, use the DatabaseSettings.exe application to enter the password then have it encrypted. If sTier is 3, then this parameter is ignored.

sWindowsAuth = If sDBTYPE is MSSQL, then if this parameter is TRUE then SQL Server will attempt to login with Windows Authentication - in this case, sUser and sEncryptedPass are not required.

sOracleMode = If sTier is a 2, then this parameter should be the type of Oracle connection to use. If OCI is passed, then the Oracle OCI client will be used. If anything else, then the Oracle database will be connected to directly using TCP/IP. If sTier is 3 or DBTYPE is not Oracle, then this parameter is ignored.

sOraclePort = If sTier is a 2 and sOracleMode is not OCI, then this is used to indicate the Oracle Port # to use.

sOracleHome = If sTier is a 2, then this parameter can contain an optional HOME value for Oracle. If sTier is 3 or DBTYPE is not ORACLE, then this parameter is ignored. |