ADODB RecordSet Object

The ADODB.RecordSet provides methods to fetch the column values. Also execute SQL Command by using ADODB.Connection Object.

Remarks

ADODB RecordSet is dependent on ADODB.Connection Object. Because it can be return value of Connection Object’s Execute method or filled when RecordSet Opened with exiting Connection Object.

The following code illustrates how to create ADODB RecordSet object:

Object Name: ADODB.RecordSet

Dim Obj   ' Create a variable.
Set Obj = CreateObject("ADODB.RecordSet")

Note:

Currently HFM follows a standard way to get a connection string from preconfigured DB information in xml configuration file. ( For more information, see Wshell.Script Object).

Connection string mainly contain fields like these.

SQL DB Connection String:

Provider=2;DRIVER={<DRIVER_NAME>};SERVER=<DB_SERVER_NAME>;PORT=<DB_SERVER_PORT>;Database=<DATABASE_NAME>;UID={<USERNAME>};PWD={<PASSWORD>}

Oracle DB Connection String:

Provider=1;DRIVER={<DRIVER_NAME>};HOST=<DB_SERVER_NAME>;PORT=<DB_SERVER_PORT>;SN=<DB_SERVICE_NAME>;UID={<DB_SCHEMA_NAME>};PWD={<DB_SCHEMA_PWD>}"