From: "Simon Chan" Newsgroups: comp.database.oracle,comp.databases.oracle,comp.databases.oracle.misc,comp.databases.oracle.tools Subject: Microsoft ODBC Driver for Oracle : RowLimit Lines: 17 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Message-ID: Date: Tue, 12 Dec 2000 01:45:42 GMT NNTP-Posting-Host: 24.114.54.72 X-Complaints-To: abuse@home.net X-Trace: news3.rdc1.on.home.com 976585542 24.114.54.72 (Mon, 11 Dec 2000 17:45:42 PST) NNTP-Posting-Date: Mon, 11 Dec 2000 17:45:42 PST Organization: Excite@Home - The Leader in Broadband http://home.com/faster 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