| View previous topic :: View next topic |
| Author |
Message |
rp
Guest
|
 Posted: Mon Dec 05, 2005 9:15 pm Post subject: Cannot open any more tables |
 |
|
| 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
|
| Posted: Mon Dec 05, 2005 9:45 pm Post subject: |
|
|
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 |
|
|
rp
Guest
|
| Posted: Mon Dec 05, 2005 11:11 pm Post subject: |
|
|
| Thank you!! That solved it -- I had set RecordsetCacheSize far too high. |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
