[Mono-bugs] [Bug 58820][Maj] New - A DataSet is empty after a call to the Fill method of OdbcDataAdapter

[bugzilla-daemon@bugzilla.ximian.com]

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 sebastien.robitaille@croesus.com.

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

--- shadow/58820	2004-05-21 17:31:01.000000000 -0400
+++ shadow/58820.tmp.4684	2004-05-21 17:31:01.000000000 -0400
@@ -0,0 +1,58 @@
+Bug#: 58820
+Product: Mono: Class Libraries
+Version: unspecified
+OS: Red Hat 9.0
+OS Details: 
+Status: NEW   
+Resolution: 
+Severity: 
+Priority: Major
+Component: Sys.Data
+AssignedTo: mono-bugs@ximian.com                            
+ReportedBy: sebastien.robitaille@croesus.com               
+QAContact: mono-bugs@ximian.com
+TargetMilestone: ---
+URL: 
+Cc: 
+Summary: A DataSet is empty after a call to the Fill method of OdbcDataAdapter
+
+Description of Problem:
+
+A DataSet is always empty (0 row) after calling odbcAdapter.Fill(dataSet)
+The same code compiled and executed with Microsoft .NET 1.1 is fine.
+
+Steps to reproduce the problem:
+1. Use the following code:
+
+string connectionString = "DSN=<MyDSN>;UID=<MyUID>;PWD=<MyPWD>;";
+OdbcConnection connection = new OdbcConnection(connectionString);
+connection.Open();
+
+OdbcDataAdapter dataAdapter = new OdbcDataAdapter("SELECT * FROM 
+<TABLENAME>", connection);
+
+DataSet dataSet = new DataSet();
+dataAdapter.Fill(dataSet);
+
+foreach(DataTable myTable in dataSet.Tables)
+{
+    Console.WriteLine("Row count: " + myTable.Rows.Count);
+}
+connection.close();
+
+
+Actual Results:
+Row count: 0
+
+Expected Results:
+Row count: 2038
+
+How often does this happen? 
+Always
+
+Additional Information:
+
+Sybase database
+freetds-0.62.3
+unixODBC-2.2.8
+mono-0.91