Provider error '8007000e' - ASP / Active Server Pages

Dayron

Hi, I use ASP code to generate report that I retrieve about 100,000 to
800,000 records from database using ADODB.Recordset . But when i run the
code, it show me the following error.

Provider error '8007000e'
Not enough storage is available to complete this operation.
/e-survey/progress3.asp, line 192
Here is my code:
L188: Set rst = server.CreateOb ject("ADODB.Rec ordSet")
L189: rst.Open strSQL, connection, 3, 3

L191: iProcessedSoFar = 0

L192: If Not rst.EOF Then
L193: arrRecords = rst.GetRows
L194: iTotalRecords = Ubound(arrRecor ds,2) + 1
L195: rst.MoveFirst
L196: End If

Wat does the error message means? is it memory error or coding error?
can anyone pls let me know?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 19 '05 #1

Subscribe Reply

9374

joker

I'd suggest the following articles since you didn't post enough
information for me to say just one of them.

http://www.aspfaq.com/show.asp?id=2131
http://www.aspfaq.com/show.asp?id=2301
http://www.aspfaq.com/show.asp?id=2355

Hopefully one of those will help you with this error.

Dayron wrote:

Hi, I use ASP code to generate report that I retrieve about 100,000 to
800,000 records from database using ADODB.Recordset . But when i run the
code, it show me the following error.

Provider error '8007000e'
Not enough storage is available to complete this operation.
/e-survey/progress3.asp, line 192
Here is my code:
L188: Set rst = server.CreateOb ject("ADODB.Rec ordSet")
L189: rst.Open strSQL, connection, 3, 3

L191: iProcessedSoFar = 0

L192: If Not rst.EOF Then
L193: arrRecords = rst.GetRows
L194: iTotalRecords = Ubound(arrRecor ds,2) + 1
L195: rst.MoveFirst
L196: End If

Wat does the error message means? is it memory error or coding error?
can anyone pls let me know?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 19 '05 #2

Carol Carrot

I had that error, and it was a networking error. not an asp error.

Could that be true for you?

"joker" <no*****@netzer o.com> wrote in message
news:O5******** ******@tk2msftn gp13.phx.gbl...

I'd suggest the following articles since you didn't post enough
information for me to say just one of them.

http://www.aspfaq.com/show.asp?id=2131
http://www.aspfaq.com/show.asp?id=2301
http://www.aspfaq.com/show.asp?id=2355

Hopefully one of those will help you with this error.

Dayron wrote:
Hi, I use ASP code to generate report that I retrieve about 100,000 to
800,000 records from database using ADODB.Recordset . But when i run the
code, it show me the following error.

Provider error '8007000e'
Not enough storage is available to complete this operation.
/e-survey/progress3.asp, line 192
Here is my code:
L188: Set rst = server.CreateOb ject("ADODB.Rec ordSet")
L189: rst.Open strSQL, connection, 3, 3

L191: iProcessedSoFar = 0

L192: If Not rst.EOF Then
L193: arrRecords = rst.GetRows
L194: iTotalRecords = Ubound(arrRecor ds,2) + 1
L195: rst.MoveFirst
L196: End If

Wat does the error message means? is it memory error or coding error?
can anyone pls let me know?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 19 '05 #3

Similar topics

860

Provider error '8007000e'

by: app1lsb | last post by:

I am getting the following error: Provider error '8007000e' Not enough storage is available to complete this operation. /apps/seas/EmpAssocView.asp, line 21 The line number refers to the execution of a stored procedure in package in Oracle. Any page that tries to use one of the store

ASP / Active Server Pages

5782

Microsoft OLE DB Provider for ODBC Drivers error

by: Rajiv | last post by:

hi all , i m trying to coneect to a access database Using DSN dim rcon set rcon = server.CreateObject("ADODB.CONNECTION") rcon.mode = 1 ' adModeRead rcon.ConnectionString ="DSN=report" rCon.Open

ASP / Active Server Pages

14117

registering an Ole Db provider

by: Duncan Winn | last post by:

I have written an Ole Db provider. It seems to be registered in the Operating system to a degree, but not fully, i.e. I can access it from a client that I have written. But it does not appear in Database Explorer's list of viable Ole Db drivers... Any suggestions??

.NET Framework

909

please help me with aspnet_wp.exe error.

by: Miller Lee | last post by:

My server run normally for some time, but today an error occured, this is the message I found with EventLog: Event Type: Error Event Source: ASP.NET 1.0.3705.288 Event Category: None Event ID: 1082 Date: 2004-05-25 Time: 19:09:11

ASP.NET

3560

Custom membership provider problem

by: John | last post by:

Hi I was working fine with create user wizard and the default membership provider. I have now customised the membership provider as per attached web.config. The create user wizard picks up the custom membership provider fine and removes the security question/answer fields as designated in the custom provider. The problem is that when I try to create a new user in the create user wizard by entering the info and pressing the 'create...

ASP.NET

1675

Trouble connecting to remote db using the .NET data provider for Sql Server

by: acwomble | last post by:

I am working with a database on another system via a ssh tunnel using plink. We have setup an alias the local system for the remote database. I am able to connect and work from within Visual Studio if I connect to the remote database using with "SQL Server" as the data source and ".NET Framework Data Provider for OLEDB" as the data provider . If I change the data provider to ".NET Framework Data Provider for SQL Server" I get the...

Microsoft SQL Server

1966

Retrieving the COM class factory for component with CLSID error,pls help me

by: orieni | last post by:

Hi, I have writen a code to take snapshot of Internet Explorer. The code works fine when run in the debug mode. But once I publish the site I get the following error for: Retrieving the COM class factory for component with CLSID {9BA05972-F6A8-11CF-A442-00A0C90A8F39} failed due to the following error:

C# / C Sharp

13362

ERROR: Provider Management - Could not establish a connection to the database.

by: Ted | last post by:

In WSAT, I get the following error when trying to set up my provider: Could not establish a connection to the database. If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider. On Windows XP Pro, I am using MS Visual Studio 2005, and I am using the developer's edition of...

ASP.NET

9593

Error 500.13 (Server too busy) and Event 4689

by: jn00s | last post by:

I am running a windows 2003 server with close to 150 websites. The majority of the sites, which are all running the same very complex classic ASP portal application using ASPImage/ASPMail/ASPUpload, are receiving the vast majority of the traffic and all are working fine. However all of my smaller websites that do not use this application or any of those 3rd party COM DLL's, and only get a tiny bit of traffic across just a few simple ASP scripts,...

ASP / Active Server Pages

9480

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10313

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10147

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10081

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9946

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7494

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5511

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4044

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2875

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General