Wayback Machinekoobas.hobune.stream
May JUN Jul
Previous capture 13 Next capture
2021 2022 2023
1 capture
13 Jun 22 - 13 Jun 22
sparklines
Close Help
  • Products
  • Solutions
  • Made with Unity
  • Learning
  • Support & Services
  • Community
  • Asset Store
  • Get Unity

UNITY ACCOUNT

You need a Unity Account to shop in the Online and Asset Stores, participate in the Unity Community and manage your license portfolio. Login Create account
  • Blog
  • Forums
  • Answers
  • Evangelists
  • User Groups
  • Beta Program
  • Advisory Panel

Navigation

  • Home
  • Products
  • Solutions
  • Made with Unity
  • Learning
  • Support & Services
  • Community
    • Blog
    • Forums
    • Answers
    • Evangelists
    • User Groups
    • Beta Program
    • Advisory Panel

Unity account

You need a Unity Account to shop in the Online and Asset Stores, participate in the Unity Community and manage your license portfolio. Login Create account

Language

  • Chinese
  • Spanish
  • Japanese
  • Korean
  • Portuguese
  • Ask a question
  • Spaces
    • Default
    • Help Room
    • META
    • Moderators
    • Topics
    • Questions
    • Users
    • Badges
  • Home /
avatar image
1
Question by Mystes · May 12, 2015 at 09:59 AM · c#androiddatabaseunity 4sqlite

Unity 4 Android Game cannot access SQLite DB (C# Script)

I'm currently developing a simply android game and I'm using SQLite as a means to save the high scores in it. When I run it on the editor it works fine and is immediately able to access the data of the table inside it but whenever I have built it into an apk already and run it on my phone it doesn't work anymore. My speculations tell me that the problem is that a connection could not be established to the SQLite database that I added under Assets/StreamingAssets

Likewise I have done a whole bunch of researching already and still no luck. Here's the big bunch of libraries that I am currently using with all the methods possible that I have researched:

using UnityEngine;

using System.Collections;

using System.Collections.Generic;

using UnityEngine.UI;

using System.Data;

using System.Configuration;

using System.EnterpriseServices;

using System.Security;

using System;

//using Mono.Data.Sqlite; (commented out as I thought SQLiteClient would be the fix)

using Mono.Data.SqliteClient;

I have referred to this guide initially: http://answers.unity3d.com/questions/743400/database-sqlite-setup-for-unity.html

as basis for the code for connecting it and it did work in the editor but not when running on my phone.

And here's all the connection methods that I have used so far but off to no success at all D:

  1. string conn = "URI=file: jar:file://" + Application.dataPath + "/HighScores.s3db";

  2. string conn = "URI=file:" + Application.dataPath + "/StreamingAssets" + "/HighScores.s3db";

  3. string conn = "URI=file:" + "jar:file:" + Application.dataPath + "!/assets/" + "HighScores.s3db";

  4. string conn = "URI = jar:file:" + Application.dataPath + "!/assets/" + "HighScores.s3db";

  5. string conn = "URI = jar:file:" + Application.dataPath + "!/assets/" + "HighScores";

  6. string conn = "URI=file:" + "jar:file://" + Application.dataPath + "!/assets/" + "HighScores.s3db";

  7. string conn = "URI=file:" + "jar:file://" + Application.dataPath + "!/assets/" + "/HighScores.s3db";

  8. string conn = "URI=file:HighScores.s3db"; //Path to database.

IDbConnection dbconn; dbconn = (IDbConnection) new SqliteConnection(conn); dbconn.Open(); //Open connection to the database.

I'm currently using the latest version of SqliteBrowser in order to make the database, create its tables, and populate it with sample data. It creates a file with no filetype and a .s3db file whenever I use its create database functionality. Both of which could have its different set of tables and data which is weird and confusing.

Comment
Add comment
10 |3000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

1 Reply

· Add your reply
  • Sort: 
avatar image
1

Answer by Mystes · May 16, 2015 at 05:46 PM

This problem is now Solved. This good guy here that posted this thread has clearly solved my problems using the most efficient way involving SQLite Queries :D

http://forum.unity3d.com/threads/unity-3d-android-sqlite-examples.114660/

Comment
Add comment · Show 1 · Share
10 |3000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image DeveshPandey · Sep 08, 2015 at 05:50 PM 0
Share

You should look at this plugin http://u3d.as/content/devesh-pandey/sqlite-database

Your answer

Hint: You can notify a user about this post by typing @username

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this Question

Answers Answers and Comments

3 People are following this question.

avatar image avatar image avatar image

Related Questions

how to access and modify my existing database made by DB browser for SQLite in unity after build 0 Answers

Should I load all the database items on my android device? 1 Answer

why sqlite can't conneted after build in PC (.exe) 0 Answers

Sqlite RANDOM() function not working on Android? 0 Answers

Multiple Cars not working 1 Answer


Enterprise
Social Q&A

Social
Subscribe on YouTube social-youtube Follow on LinkedIn social-linkedin Follow on Twitter social-twitter Follow on Facebook social-facebook Follow on Instagram social-instagram

Footer

  • Purchase
    • Products
    • Subscription
    • Asset Store
    • Unity Gear
    • Resellers
  • Education
    • Students
    • Educators
    • Certification
    • Learn
    • Center of Excellence
  • Download
    • Unity
    • Beta Program
  • Unity Labs
    • Labs
    • Publications
  • Resources
    • Learn platform
    • Community
    • Documentation
    • Unity QA
    • FAQ
    • Services Status
    • Connect
  • About Unity
    • About Us
    • Blog
    • Events
    • Careers
    • Contact
    • Press
    • Partners
    • Affiliates
    • Security
Copyright © 2020 Unity Technologies
  • Legal
  • Privacy Policy
  • Cookies
  • Do Not Sell My Personal Information
  • Cookies Settings
"Unity", Unity logos, and other Unity trademarks are trademarks or registered trademarks of Unity Technologies or its affiliates in the U.S. and elsewhere (more info here). Other names or brands are trademarks of their respective owners.
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Default
  • Help Room
  • META
  • Moderators
  • Explore
  • Topics
  • Questions
  • Users
  • Badges