Urgent.

Unity Engine
1

Hi,
please I need your help in one day my university starts and I have to finish this project before 15 october.
I have a project with no errors and everything is great but when I move this project to another computer the game is not able to access the SQLite database. and I saw the file log of the game and it’s the attached file I copied the message in the log file so they told me to solve this problem you have to access the IIS manager… and enable the 32 bits application.
but I couldn’t do it cz I have to install the IIS Manager in some laptops and in mine I enabled it but it was already working so I didn’t need it.
I tried to create an XML database and I wrote the code and there is no error but there is no access to the database the messages aren’t being output and I don’t like XML database so I don’t want to continue working on it.

Does anyone know if there is a solution to make the other computers read the SQLite database.

703191–25342–$output_log(vista laptop).txt (2.91 KB)

2

Any help please?

3

SQLite databases are local in application databases, other computers don’t talk to it, not even other applications normally.
That would be a remote database normally done through MySQL, MSSQL, Oracle or through a webservice that binds to any local or remote database (talking to webservice would be done through WWW → PHP / ASP.NET)

The only thing needed for an SQLite db to work are:

  1. That the sqlite library is present at all (thats where you fail. you likely didn’t put the sqlite3 dll into the Assets/Plugins folder so its not present anymore on the other systems unless sqlite was installed on the system itself. The log already points that out at its very beginning that the wrapper fails to find sqlite3)
  2. That you don’t forget to move the DB along the application as it will not magically be present there at all

As such i don’t see what IIS has to do with it at all.

4

I copied the database and it didn’t work but I am going to try to copy the dll.
thank you.

5

put it into Assets/Plugins and it will be copied along the build automatically.

6

ok thank you. Even the database or just the dlls?
and that should solve my problem?

7

there isn’t any plugins folder in the asset!!

8

Note: Plugins are a Pro-only feature. For desktop builds, plugins will work in standalones only. They are disabled when building a Web Player for security reasons

9

Hey I didn’t find the plugins folder but I copied it to the game’s folder but that didn’t work so any help please?!!

10

You have to create the Plugins folder.

11

ok I will see if that will work.thank you.

12

Hey, I created the folder and it worked.
but I am getting some new messages in the log file of the game when I moved it to the other computer: it’s the document attached.

703316–25351–$output log.txt (4.86 KB)

13

I searched the web and I found that the SQLite.dll should be other version.
but this version is working perfectly on my laptop which version should I get to the other laptops?

14

Hey I need the v3.6.16 but I can’t find it or a sqlite.dll wich is latest then v3.5.0 please if anyone has it I need it.
and I don’t need the windows 7 sqlite3 I need an older one please!!!

15

Hey it’s me again I found the v3.6.16 but it didn’t work so if anyone has the v3.5.0 please!!!

16

Hey finally I needed to upgrade both the sqlite.dll and the sqlite3.dll that was the prblem so if someone ever needed those dlls I attached them :

703395–25357–$System.Data.zip (1.21 MB)