Problem in database connection (9981)

Archived Forums Questions & Answers
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: Code:

1.System.ArgumentException: Invalid ConnectionString format for parameter "Server : localhost" at Mono.Data.Sqlite.SqliteConnection.ParseConnectionString () [0x00000] in :0 at Mono.Data.Sqlite.SqliteConnection.Open () [0x00000] in :0 at (wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteConnection:Open () at commonDatabaseScript.openConnection () [0x00011] in E:\sriram\projects\databa\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)

can any one say wat's going on pls???

2

Your connection string is using the wrong syntax. This is an example how it should look like:

string Server = "localhost";
string Username = "my_username";
string Password = "my_password";
string Database = "my_database";

string ConnectionString = "Data Source=" + Server + ";";
ConnectionString += "User ID=" + Username + ";";
ConnectionString += "Password=" + Password + ";";
ConnectionString += "Initial Catalog=" + Database;
3

ya i got the clear ans now.....these errors are came from "connectionString " syntax.The exact code for when you pass it from a function is,

public void OpenDB(string localhost, string db, string name,string password,string false)
{
   connectionString = "host= " +localhost + ";Database= " +db + ";User ID= " +name + ";Password= " +password +";Pooling= " +false+ ";"; 
}