473,789 Members | 2,893 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Stream size limitation

Hi all,
I am new to the ADODB.Stream
I am using following code

lRecordset.Open "Select * from <some table-name>"
'this query return more than 1000 records
dim lstream as new ADODB.stream
'assigning the recordset data to the stream
lrecordset.save lstream
lStream.Positio n = 0
Dim lRecordset2 As New ADODB.Recordset
lRecordset2.Ope n lstream
MsgBox lRecordset2.Rec ordCount

my problem is that query is returning say 1500 records but when i am
again assigning the same stream to another recordset it is copying
only 485 records
that is lstream is saving only 485 records...is there any size limit
on stream...?
how i can do this using stream only....
If u have any solution plz reply back..
Thanks in advance...
Jul 20 '05 #1
1 2916
Hi all,
I solved the problem
We just need to put
lRecordset.Curs orLocation = adUseClient
before putting the recordset into Stream
Anyway thanks to all

sd*******@yahoo .com (Sandeep) wrote in message news:<33******* *************** ***@posting.goo gle.com>...
Hi all,
I am new to the ADODB.Stream
I am using following code

lRecordset.Open "Select * from <some table-name>"
'this query return more than 1000 records
dim lstream as new ADODB.stream
'assigning the recordset data to the stream
lrecordset.save lstream
lStream.Positio n = 0
Dim lRecordset2 As New ADODB.Recordset
lRecordset2.Ope n lstream
MsgBox lRecordset2.Rec ordCount

my problem is that query is returning say 1500 records but when i am
again assigning the same stream to another recordset it is copying
only 485 records
that is lstream is saving only 485 records...is there any size limit
on stream...?
how i can do this using stream only....
If u have any solution plz reply back..
Thanks in advance...

Jul 20 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
7889
by: Rick Brough | last post by:
I'm in the early stages of researching the migrating of an OLTP Oracle database (size 200+ GB) and still growing to PostgreSQL 8.x. Before I spend alot of time documenting the migration path, I'd like to know if there is a limitation to the size of a PostgeSQL database. If so, what is the limitation? Any feedback would be greatly appreciated Thanks, Rick
2
1818
by: Anurag | last post by:
This simple one beats me all ends up(sincerely). I have been doing DB2 UDB for some time now, reading a lot of good discussions in this forum, writing some answers, asking a lot more but this simple question has floored me completely. Either I pretend that I know or I could let the kowledgable ones pass on some wisdom to me :-) When we say that: (1) "CLP in Db2 V8.2 still imposes a limit of 64K on the stored proc size;
5
7976
by: praveen | last post by:
Hello Folks; I am working in ASP.NET application. I would like to know how much characters ( OR How much Size?) I can keep in View State variable. I want the limitation in its size. Is there any way to change/set this view state value. Thanks in advance! Posted Via Usenet.com Premium Usenet Newsgroup Services
2
14346
by: Joseph Geretz | last post by:
I'm developing a Web Service using DIME to download and upload files from and to an IIS server. In order to increase the download filesize to unlimited, I have the following block in my App.config and Web.config files: <messaging> <maxRequestLength>-1</maxRequestLength> </messaging> The largest file I've downloaded is 70 meg and that's more than plenty for me. However, I'm finding that on upload, if I attempt to upload greater than
6
2716
by: AB | last post by:
Hello all, I heard once that there is a limitation on the number of lines of code that a program can have when using C, but not for C++. Is this true? Any ideas?
9
3705
by: anachronic_individual | last post by:
Hi all, Is there a standard library function to insert an array of characters at a particular point in a text stream without overwriting the existing content, such that the following data in appropriately moved further down? From a cursory search of the libc documentation I can't find such a function. Will I have to write it myself? Thanks.
4
3803
by: AviCoh | last post by:
Hi, Let me start with the question and then describe my case : Is there a way to read the raw contents of an HTTP request in PHP as a stream (i.e. not get it all at once from Apache) ? In my case I am implementing an API for my server side app. One of the actions in the API allows the posting of binary contents as application/octet-stream. The size of this binary contents can get up to several MBs.
4
1487
by: Craig Buchanan | last post by:
I am trying to save a MemoryStream (the attachment's Data property) to disk using a FileStream. It seems that the MemoryStream's Read method is the issue. The MemoryStream's size is 6680 bytes and its Position is 0. Here's the code: .... For Each attachment As Attachment In Attachments Using FS As New FileStream(app_data & fileName, FileMode.Create)
4
2552
by: leegold58 | last post by:
Hi, Is there a "way around" the size limitation for Access? I'm thinking of something like spanning a huge table accross multiple databases... Something simple and that would preserve the integrity of the DB yet let me overcome the size limitation. Is there any best practice or technique?
0
9665
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9511
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,...
0
9983
tracyyun
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...
0
9020
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7529
isladogs
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...
0
6768
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5417
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5551
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3697
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.