Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.
View products that this article applies to.
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
Keywords: KB179236, kbinfo, kb3rdparty