[Mono-bugs] [Bug 74300][Min] New - Mono.Data.SqliteClient does not support spaces in Connection string

bugzilla-daemon@bugzilla.ximian.com bugzilla-daemon@bugzilla.ximian.com
Fri, 1 Apr 2005 05:42:45 -0500 (EST)


Please do not reply to this email- if you want to comment on the bug, go to the
URL shown below and enter your comments there.

Changed by appasamy@rediffmail.com.

http://bugzilla.ximian.com/show_bug.cgi?id=74300

--- shadow/74300	2005-04-01 05:42:45.000000000 -0500
+++ shadow/74300.tmp.4466	2005-04-01 05:42:45.000000000 -0500
@@ -0,0 +1,77 @@
+Bug#: 74300
+Product: Mono: Class Libraries
+Version: 1.1
+OS: Red Hat 9.0
+OS Details: 
+Status: NEW   
+Resolution: 
+Severity: 
+Priority: Minor
+Component: Sys.Data
+AssignedTo: mono-bugs@ximian.com                            
+ReportedBy: appasamy@rediffmail.com               
+QAContact: mono-bugs@ximian.com
+TargetMilestone: ---
+URL: 
+Cc: 
+Summary: Mono.Data.SqliteClient does not support spaces in Connection string 
+
+Description of Problem:
+Mono.Data.SqliteClient does not support spaces in Connection string .
+
+Steps to reproduce the problem:
+1. 
+
+Create a program with the following connection string specification for
+Sqlite database:
+
+		
+		-------
+		static void Main(string[] args)
+		{
+			
+
+			SqliteConnection dbcon = new SqliteConnection();
+			string connectionString =
+				" URI=file:SqliteTest.db, version=3";
+			dbcon.ConnectionString = connectionString;
+			dbcon.Open();
+                        Console.WriteLine("Connection Status: "+dbcon.State);
+                        ----
+                        ---
+                }
+
+
+
+
+
+			
+
+2. Run the program
+ 
+
+Actual Results:
+
+Unhandled Exception: System.InvalidOperationException: Invalid connection
+string: no URI
+in <0x00321> Mono.Data.SqliteClient.SqliteConnection:SetConnectionString
+(string)
+in <0x00010> Mono.Data.SqliteClient.SqliteConnection:set_ConnectionString
+(string)
+in <0x000c8> Test.Mono.Data.SqliteClient.SqliteTest:Main (string[])
+
+
+Expected Results:
+
+Connection Status : Open
+
+
+How often does this happen? 
+Always
+
+Additional Information:
+
+If the connection string has no embedded space like the following then it
+works properly
+
+string connectionString ="URI=file:SqliteTest.db,version=3";