Announcement

Collapse
No announcement yet.

Problem in database communication using SQLite3

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

  • Problem in database communication using SQLite3

    Hi everyone.

    I am having a problem to open a database placed on a server with SQLite3.
    The path to the Database on the server is as follows:
    SDatabase = _SourceFolder .. "\\ I.P. \ home \ systems \ dbAgendaCBTU \ DataBase \ Bank.db"
    It turns out that when you run the application created on the workstations, it opens without giving any error message but does not show any recorded contents of the Database, leaving the screen blank.
    If some noble member of this forum can give me a light on how to solve this problem, I thank you immensely.

  • #2
    If this is a network location, the path should not start with "_SourceFolder". If using a UNC path does not work, you need to map the network share to a drive, and use that instead.

    Ulrich

    Comment


    • #3
      Thanks for the info Ulrich. I will do the correction and test the operation. If the problem persists, I'll ask for help here again.

      Comment


      • #4
        It's still the same, if I change the address using the UNC path or mapping the share, it seems the program connects because there is no error message, but it does not import the data from the database and it does not write anything new.

        Comment


        • #5
          I would use a local copy of the file, to make sure that the database can indeed be opened and read properly.If it works locally but not over the network, it may be an access rights, locking or mapping issue. If it also does not work with a local copy, then most likely the database is not in the expected format.

          Ulrich

          Comment


          • #6

            Finally solved. The problem was permissions for non-server users.




            Comment

            Working...
            X