problem in database connection

Unity Engine
1

hi guys,

I’m trying to connect Sqlite database into “server : localhost” and i’m getting some strange errors…can any one explain what mistake i have done??

the error is:

 1.System.ArgumentException: Invalid ConnectionString format for parameter "Server : localhost"
                 at Mono.Data.Sqlite.SqliteConnection.ParseConnectionString () [0x00000] in <filename unknown>:0 
                 at Mono.Data.Sqlite.SqliteConnection.Open () [0x00000] in <filename unknown>:0 
                 at (wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteConnection:Open ()
                 at commonDatabaseScript.openConnection () [0x00011] in E:\sriram\projects\database\Assets                  \commonDatabaseScript.cs:40 
UnityEngine.MonoBehaviour:print(Object)
commonDatabaseScript:openConnection() (at Assets/commonDatabaseScript.cs:45)
commonDatabaseScript:insertData(String) (at Assets/commonDatabaseScript.cs:52)
commonDatabaseScript:OnGUI() (at Assets/commonDatabaseScript.cs:109)

2.InvalidOperationException: Database is not open
Mono.Data.Sqlite.SqliteCommand.InitializeForReader ()
Mono.Data.Sqlite.SqliteCommand.ExecuteReader (CommandBehavior behavior)
Mono.Data.Sqlite.SqliteCommand.ExecuteReader ()
(wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteCommand:ExecuteReader ()
commonDatabaseScript.doQuery () (at Assets/commonDatabaseScript.cs:70)
commonDatabaseScript.OnGUI () (at Assets/commonDatabaseScript.cs:110)

hlp me…

2

and here is my code:

public static void openConnection()
{
string connectionString = "Server : localhost ; Database = testdata.db ";
try
{
dbConnection = new SqliteConnection (connectionString);
dbConnection.Open();
}
catch(Exception e)
{
string temp1 = e.ToString();
print(temp1);
}
Debug.Log(“Database connected”);
}

public static void insertData(string x)
{
openConnection();
SqliteCommand dbCommand = dbConnection.CreateCommand();
dbCommand.CommandText = “INSERT into nametable(name1) values ('”+x+“');”;
dbCommand.Dispose();

dbCommand = null;

dbConnection.Close();

dbConnection = null;

}

3

connecting to SQLITE looks like headache and it would be nice as an embedded part of Unity, for those who agree, I opened a feedback on it : http://feedback.unity3d.com/forums/15792-unity/suggestions/1251047-sqlite-embed-in-unity?ref=title