Article ID: 179236
Article Last Modified on 12/3/2003
Setting Max Default Valid Setting
Name Len Value Values Description
------------------------------------------------------------------
BufferSize 7 65535 1000 Minimum fetch buffer size.
to
65535
CatalogCap 2 1 0 or 1 1 means convert non-quoted
identifiers to upper case in
the catalog functions.
ConnectString 128 "" A/N Connection string. Required
method of specifying the server
name with the Msorcl10.dll
driver.
Description 256 "" A/N Description.
DSN 33 "" A/N Data source name.
NumberFloat 2 "" 0 or 1 0 means FLOAT columns are
treated as SQL_FLOAT. 1 means
FLOAT columns are treated as
SQL_DOUBLE.
PWD 30 "" A/N Password.
RDOSupport 2 "" 0 or 1 Allows RDO to call Oracle
procedures.
Remarks 2 0 0 or 1 Include REMARKS in Catalog
functions.
RowLimit 4 "" 0 Maximum number of rows returned
to by a select. A zero length
999 string or 0 means there is no
limit applied.
Server 128 "" A/N Oracle server name.
SynonymColumns 2 1 0 or 1 Include SYNONYMs in SQLColumns.
SystemTable 2 "" 0 or 1 0 means do not display system
tables. 1 means display system
tables.
TranslationDLL 33 "" A/N Translation DLL name.
TranslationName 33 "" A/N Translation name.
TranslationOption 33 "" A/N Translation option.
TxnCap 2 "" A/N Transaction capable. 0 means
the driver reports that it does
not support transactions. 1
means the driver reports it is
capable of performing
transactions.
UID 30 "" A/N User name.
// START CODE SAMPLE
#include <windows.h>
#include <odbcinst.h>
#include <stdio.h>
#include <conio.h>
void main()
{
BOOL fResult = FALSE;
// Drop and re-create a Msorcl10.dll (version 1.0) data source.
fResult = SQLConfigDataSource( NULL,
ODBC_REMOVE_DSN,
"Microsoft ODBC Driver for Oracle",
"DSN=MSORCL10_DSN\0"
);
fResult = SQLConfigDataSource( NULL,
ODBC_ADD_DSN, /* OR ODBC_ADD_SYS_DSN */
"Microsoft ODBC Driver for Oracle",
"BufferSize=40000\0"
"CatalogCap=1\0"
"ConnectString=MyConnectString\0"
"Description=My Description Text\0"
"DSN=MSORCL10_DSN\0"
"NumberFloat=0\0"
"PWD=MyPassword\0"
"RDOSupport=0\0"
"Remarks=0\0"
"RowLimit=0\0"
"SynonymColumns=1\0"
"SystemTable=1\0"
"TranslationDLL=\0"
"TranslationName=\0"
"TranslationOption=\0"
"TxnCap=1\0"
"UID=MyUserID\0"
);
// Display success/failure.
printf( "MSORCL10.DLL SQLConfigDataSource returned %s\n",
(fResult) ? "TRUE" : "FALSE" );
// Drop and re-create a Msorcl32.dll (version 2.0) data source.
fResult = SQLConfigDataSource( NULL,
ODBC_REMOVE_DSN,
"Microsoft ODBC for Oracle",
"DSN=MSORCL32_DSN\0"
);
fResult = SQLConfigDataSource( NULL,
ODBC_ADD_DSN, /* OR ODBC_ADD_SYS_DSN */
"Microsoft ODBC for Oracle",
"BufferSize=40000\0"
"CatalogCap=1\0"
"ConnectString=MyConnectString\0"
"Description=My Description\0"
"DSN=MSORCL32_DSN\0"
"NumberFloat=0\0"
"PWD=MyPassword\0"
"RDOSupport=0\0"
"Remarks=0\0"
"RowLimit=0\0"
"Server=MyOracleServer\0"
"SynonymColumns=0\0"
"SystemTable=0\0"
"TranslationDLL=\0"
"TranslationName=\0"
"TranslationOption=\0"
"TxnCap=0\0"
"UID=MyUserID\0"
);
// Display success/failure.
printf( "MSORCL32.DLL SQLConfigDataSource returned %s\n",
(fResult) ? "TRUE" : "FALSE" );
printf( "Press any key to exit.\n" );
_getch();
}
// END CODE SAMPLE
Additional query words: Msorcl32.dll kbODBC kbDatabase kbOracle kbDriver
Keywords: kbinfo kb3rdparty KB179236