Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    Pakistan
    Posts
    15

    Unanswered: using sql and vb i get "out of memory" message

    i am using sql server and vb for my s/w and during execution of the software access becomes slow and i get "out of memory" message inspite of having 60gb hard disk and 128 of ram.
    plz tell me how to solve the probelem and why this probelem is?
    mishi

  2. #2
    Join Date
    Mar 2004
    Location
    www.scirocco.ca
    Posts
    346

    Re: using sql and vb i get "out of memory" message

    Take a look at you SQL statements you could have an incorrect join that creates millions of records which fills up your tempdb on SQL server and hence the message. I cannot be more precise as you have not posted any code.
    http://www.scirocco.ca/images/banner...occobanner.gif

    Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!

    Or try our Ask An Expert service to answer any of your questions!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •