Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2015
    Posts
    1

    Unanswered: shutdown dbf file

    I have been having problem where files are left open and on shutdown it corrupts the file.
    is there a way to open c connection to dbf table and read the data like in .net So that as soon as you read the data you can close the connection?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I've never seen any of the C libraries that I've used damage a DBF file that is only opened for reading. All of the damage that I've seen occurs after a write/update/delete operation. As long as your application only needs to read the data, you should be able to cache the data in RAM when the application starts running and then close the DBF file to avoid any damage.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Nov 2002
    Posts
    128
    Provided Answers: 1
    is there a way to open c connection to dbf table

    I assume that was a typo and you meant
    is there a way to open a connection to dbf table

    If so, sure.
    Assuming that you are accessing your DBF table via ODBC, you merely need to write your .Net DataAccess routine to Close the ODBC connection after you acquire the data via your SQL Query.

    Our routines are VB.Net (VS2008 & VS2010) and they run all the time.
    Unless someone has crashed the web site causing the Connection to remain Open, there is no problem with left Open DBF tables.

    Good Luck

Posting Permissions

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