CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2008
    Location
    India
    Posts
    780

    Problem in CRecordset::Open.

    Hi all,

    i m using Access databse and ODBC connection to connectivity with the database.
    there is number of tabels approx 36 tabels.

    Each n every table have separate CRecordset derived class.

    at one point when i m using many of these table,firstly its working fine but after some time
    CRecordset::Open takes so much time to open recordset and between this duration application looks like not responding.

    please help me how can i resolve this.

    please help for this.

    thanks in advance.
    IN A DAY, WHEN YOU DON'T COME ACROSS ANY PROBLEMS - YOU CAN BE SURE THAT YOU ARE TRAVELLING IN A WRONG PATH

  2. #2
    GCDEF is offline Elite Member Power Poster
    Join Date
    Nov 2003
    Location
    Florida
    Posts
    12,635

    Re: Problem in CRecordset::Open.

    No telling what's going on. If your query returns a lot of records, try using a dynaset instead of a snapshot.

  3. #3
    Join Date
    Jan 2008
    Location
    India
    Posts
    780

    Re: Problem in CRecordset::Open.

    I m already using dynaset.
    IN A DAY, WHEN YOU DON'T COME ACROSS ANY PROBLEMS - YOU CAN BE SURE THAT YOU ARE TRAVELLING IN A WRONG PATH

  4. #4
    Arjay's Avatar
    Arjay is offline Moderator / EX MS MVP Power Poster
    Join Date
    Aug 2004
    Posts
    13,490

    Re: Problem in CRecordset::Open.

    If the database fetch operation takes a while and you are doing it in the main UI thread, it's going to make the app non-responsive.

    To fix this, put the database operation into a secondary thread.

Posting Permissions

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





Click Here to Expand Forum to Full Width

Featured