VB & Database, Microsoft ODBC Driver for Oracle : RowLimit

Microsoft ODBC Driver for Oracle : RowLimit

Author	Message
Simon Cha #1 / 4	Microsoft ODBC Driver for Oracle : RowLimit I'm working on a VB program to interface with Oracle 8i with Microsoft ODBC Driver for Oracle (MDAC 2.6). The program works fine if the number of records returned is less than 10,000. I studied Microsoft documentation and found that there was a setting called RowLimit which specified number of rows returned by a SELECT statement. However, it seemed like that the Microsoft ODBC Driver for Oracle ignored this setting. I've tried to set the RowLimit to a null string, 0 or even 99; the limit was always 10,000. http://www.--*.com/ Thanks. Simon Chan
Sat, 31 May 2003 09:44:04 GMT

Lau, Hon Wa #2 / 4	Microsoft ODBC Driver for Oracle : RowLimit Try this, set adoRS = new adodb.recordset adoRS.MaxRecords=20 adoRS.Open sSQL, adoConn Thanks. Quote: > I'm working on a VB program to interface with Oracle 8i with Microsoft ODBC > Driver for Oracle (MDAC 2.6). The program works fine if the number of > records returned is less than 10,000. > I studied Microsoft documentation and found that there was a setting called > RowLimit which specified number of rows returned by a SELECT statement. > However, it seemed like that the Microsoft ODBC Driver for Oracle ignored > this setting. I've tried to set the RowLimit to a null string, 0 or even 99; > the limit was always 10,000. > http://support.microsoft.com/support/kb/articles/Q179/2/36.ASP > Thanks. > Simon Chan
Sun, 01 Jun 2003 17:11:14 GMT

Carlos J. Quinter #3 / 4	Microsoft ODBC Driver for Oracle : RowLimit I think Simon wants more than 10000 records which seems to be a limit imposed by the ODBC driver, not to limit the number of records to a given number. -- Best regards, Carlos J. Quintero Freeware "all-in-one" Add-In for VB6: TabIndex Assistant, Procedure Callers, Find in All Projects, Close Windows, Review TabIndex, Review Collections, Add Property or Function, Add Error Handler, Add Header Comment, Clear Immediate Window, Project Statistics: www.mztools.com Quote: > Try this, > set adoRS = new adodb.recordset > adoRS.MaxRecords=20 > adoRS.Open sSQL, adoConn > Thanks. > > I'm working on a VB program to interface with Oracle 8i with Microsoft ODBC > > Driver for Oracle (MDAC 2.6). The program works fine if the number of > > records returned is less than 10,000. > > I studied Microsoft documentation and found that there was a setting called > > RowLimit which specified number of rows returned by a SELECT statement. > > However, it seemed like that the Microsoft ODBC Driver for Oracle ignored > > this setting. I've tried to set the RowLimit to a null string, 0 or even 99; > > the limit was always 10,000. > > http://support.microsoft.com/support/kb/articles/Q179/2/36.ASP > > Thanks. > > Simon Chan
Sun, 01 Jun 2003 17:33:02 GMT

Michael D. Lon #4 / 4	Microsoft ODBC Driver for Oracle : RowLimit I've pulled back over 100,000 rows via the Microsoft ODBC Driver for Oracle. Note that this was for testing only, and that I would question this practice in a production app. -- Michael D. Long http://extremedna.homestead.com Quote: > I'm working on a VB program to interface with Oracle 8i with Microsoft ODBC > Driver for Oracle (MDAC 2.6). The program works fine if the number of > records returned is less than 10,000. > I studied Microsoft documentation and found that there was a setting called > RowLimit which specified number of rows returned by a SELECT statement. > However, it seemed like that the Microsoft ODBC Driver for Oracle ignored > this setting. I've tried to set the RowLimit to a null string, 0 or even 99; > the limit was always 10,000. > http://support.microsoft.com/support/kb/articles/Q179/2/36.ASP > Thanks. > Simon Chan
Mon, 02 Jun 2003 09:47:10 GMT

Page 1 of 1

[ 4 post ]