ADO DM Properties
Note: Some of the following DM properties are marked as deprecated. This is due to the fact that the ADO and FIO driver have been split into two separate driver modules. However, for backward compatibility reasons, the ADO driver still contains the FIO functionalilty but this will be removed in the next major IDX release. Please ensure, if making use of FIO functions, that the new FIO DM is used whenever possible.
|
Registry Key |
Data Type |
Default Value |
Description |
|
ADO_Connection |
REG_SZ |
idx |
The ADO connection string for the primary ADO data source/server. This is a normal connection string to connect to a DB Source. E.g.: Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=IDXONLINE;Initial Catalog=TEMP_TEST;Data Source=APOLLO\IDXMSDE. This string can be generated from a UDL file. |
|
ADO_Connection2 |
REG_SZ |
idx |
The ADO connection string for the secondary/backup ADO data source/server. This should be left blank if no backup server exists. |
|
ADOFIO |
REG_DWORD |
0 |
(Deprecated) Sets the ADO operational mode. Mode 1 = ADO, 2= FIO, 3 = Reserved. |
|
DBG_ADO |
REG_DWORD |
0 |
Sets the debug verbose output level for the ADO driver module. 0 disables verbose logging while 255 sets the most verbose logging. |
|
DBG_FIO |
REG_DWORD |
0 |
(Deprecated) Sets the debug verbose output level for the ADO driver module. 0 disables verbose logging while 255 sets the most verbose logging. |
|
dbgON |
REG_DWORD |
0 |
Debug Flags for ascii file debugging/diagnostic trace |
|
Description |
REG_SZ |
|
SQL Statement Processor |
|
FIO_COLUMNS |
REG_DWORD |
25 |
(Deprecated) The max number of colums in the .csv file. |
|
FIO_ITEMS |
REG_DWORD |
100 |
(Deprecated) The max number of items in the file = Rows * Columns. |
|
FIO_NAME |
REG_SZ |
input.txt |
(Deprecated) The name of the file to read. |
|
FIO_ROWS |
REG_DWORD |
1 |
(Deprecated) The Max number of rows in the .csv file. |
|
Force_ADO_Close |
REG_DWORD |
0 |
If this value is set to a value bigger than 0 the ADO driver will loop for this number of times before it will close the connection and reopen it again. The Force_ADO_Close toggle is then reset. |
|
Password |
REG_SZ |
Not Defined |
Reserved |
|
PollRate |
REG_DWORD |
Not Defined |
Poll Rate in milliseconds. |
|
Read_File_Always |
REG_DWORD |
0 |
Reserved |
|
StartUpDelay |
REG_DWORD |
0 |
Sets the delay, in milliseconds, before the ADO driver begins functioning. |
|
User |
REG_SZ |
Not Defined |
Reserved |