Oracle Odbc Driver Configuration Fetch Buffer Size
The default value of JDBC fetch size property is driver specific and for Oracle driver it is 10 indeed. For some queries fetch size should be larger, for some smaller. I think a good idea is to set some global fetch size for whole project and overwrite it for some individual queries where it should be bigger. The information contained in this document The Setup Routines For The Oracle In Oraclient10g_home1 Odbc Driver Could Not when the file was named rdbodbc.ini. Fetch Buffer Size Set the Fetch Buffer Size in the Oracle Options tab This tool uses JavaScript and much of from MSQRY32 when expanding the list of columns within a table.
Oracle Odbc Driver Configuration
Command Line To create the response file for Oracle Client 11.2g I had to call Setup.exe without any command line parameters. On the 6th dialog window there was a button to save the response file. The silent installation worked with the command line: ' server share Setup.exe' -waitforcompletion -responseFile ' server share file.rsp' -force -silent -noconsole To uninstall it I had to download the uninstall tool from Oracle (credentials required): or http://download.oracle.com/otn/nt/oracle11g/112010/win6411gR2deinstall.zip. Note Oracle 11g R1 is not supported with Windows 7, R2 supports it.
Oracle Odbc Driver Configuration Fetch Buffer Sizes
R1 will still install by hand on Windows 7 after failed prerequisites and checking the corresponding check box. If you try to automate it will not finish because of the same failed prerequisites. I found a work around for this: Add a Windows 7 entry into the refhost.xml Location of this file on my system: c: unpackedclientinstallation win3211gR1client client stage prereq client refhost.xml newly edited refhost.xml file: New lines are added at the end of this excerpt after
Notice version value=6.1. With new refhost.xml file all checks passed.