Andromo - Start Making Apps - Free Signup

Announcement

Collapse

New Forum Software

If you're here, you've found the new home for our forums. There will be some bugs to iron out, so thanks for your patience...
See more
See less

sql Lite help! - "database disk image is malformed!"

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • sql Lite help! - "database disk image is malformed!"

    I've exported a table from an access database into a delimted text and then imported into sql lite data browser and saved as a .db. The code i've used to open the database is as follows:

    sDatabaseFile = _SourceFolder .. "\\AutoPlay\\Docs\\blah.db";
    db = SQLite.Open(sDatabaseFile);
    nLastError = Application.GetLastError();
    if nLastError ~= SQLite.OK then
    Dialog.Message("Error Opening File", SQLite.GetLastErrorString());

    end


    Upon preview/build I get the error "database disk image is malformed!"

    Where did I go wrong?

  • #2
    What version of the SQLite Browser did you use?

    I had to drop back to an older version (1.1) to create databases that were compatible with the SQLite plugin.

    Comment


    • #3
      Hey Worm...I'm using V 1.2.1. Do you know where I can download the older version?

      Comment


      • #4
        http://sourceforge.net/project/showf...group_id=87946

        Comment


        • #5
          i had the same problem as Worm. version 1.2.1 only make version 3 SQLite databases. i thought i was doing something wrong too. i messed with it for 4 hours!

          Comment


          • #6
            Sorry about that... It never even crossed my mind to post that you needed to get the older version.

            Comment


            • #7
              it worked

              Thanks very much for your help...It's reading the db now. I'm a bit of a rookie at this so I'm sure I'll be running into some other glitches.

              Comment


              • #8
                importing another table...

                am importing a table (.csv) that has about 20000 records into the sqlite browser but it seems to hang. Has anyone also had this problem...any suggestions?

                Comment


                • #9
                  I did the same thing with about 7100 records and it seemed to hang.
                  At first it was fine, then it seemed to hang but it would appear to be doing something .. then eventually it was doing nothing. I figured it had lost it!
                  Cant remember how long I waited but i finally gave up and quit the program. On re-opening, all records had been imported which suggests the problem is more along the refresh stage not the importing.
                  -
                  = Derek
                  ["All glory comes from daring to begin" - fortune cookie]

                  Comment


                  • #10
                    No such luck.

                    I left it for a while and on reopening I had nothing. Are there any other ways of exporting Access tables into sqlite??

                    I know I can try splitting up the tables but I'd rather do that as a last resort.

                    Comment

                    Working...
                    X