Infralution Support Forum Index Infralution Support
Support groups for Infralution products
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Cannot open any more tables

 
Post new topic   Reply to topic    Infralution Support Forum Index -> Virtual Data Objects Support
View previous topic :: View next topic  
Author Message
rp
Guest





PostPosted: Mon Dec 05, 2005 9:15 pm    Post subject: Cannot open any more tables Reply with quote

How can I avoid receiving this error? I have 164 "VirtualData Query" messages in the output window, so I'm assuming that means 164 recordsets...is that too many? The majority of these queries return 0 records--is it possible to tell VDO to release the recordset if it contains 0 records?
Back to top
Infralution



Joined: 28 Feb 2005
Posts: 5027

PostPosted: Mon Dec 05, 2005 9:45 pm    Post subject: Reply with quote

Virtual Data has an in-built recordset caching mechanism that should limit the number of recordsets open - what are you setting the RecordsetCacheSize to when you open the connection? This is the maximum number of recordsets that will be opened for the connection. You need to set this to something that your database can handle.
_________________
Infralution Support
Back to top
View user's profile Send private message Visit poster's website
rp
Guest





PostPosted: Mon Dec 05, 2005 11:11 pm    Post subject: Reply with quote

Thank you!! That solved it -- I had set RecordsetCacheSize far too high.
Back to top
Display posts from previous:   
Post new topic   Reply to topic    Infralution Support Forum Index -> Virtual Data Objects Support All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group