2005-09-24 Sureshkumar T <tsureshkumar@novell.com>

In sql:

	* sybase.sql: grant permissions on objects

	* sqlserver.sql: change id as int. tiny int won't allow 6000 (the
	tempory updatable limit).

In System.Data.SqlClient:

	* SqlDataAdapterTest.cs (Fill_Test_Exceptions): passing null
	dataset name throws ArgumentNullException in ms.net

	* SqlConnectionTest.cs: HostName compare: convert to uppercase.

	* SqlDataReaderTest.cs: remove Opening connection in few test
	cases as it was done in SetUp.
	- id type change changes


svn path=/trunk/mcs/; revision=50673

3 files changed, 22 insertions, 4 deletions

diff --git a/mcs/class/System.Data/Test/ProviderTests/sql/ChangeLog b/mcs/class/System.Data/Test/ProviderTests/sql/ChangeLog
index b16ad3e8f4d..7d1a0926a6a 100644
--- a/mcs/class/System.Data/Test/ProviderTests/sql/ChangeLog
+++ b/mcs/class/System.Data/Test/ProviderTests/sql/ChangeLog
@@ -1,3 +1,10 @@
+2005-09-24  Sureshkumar T  <tsureshkumar@novell.com>
+
+	* sybase.sql: grant permissions on objects
+
+	* sqlserver.sql: change id as int. tiny int won't allow 6000 (the
+	tempory updatable limit).
+
 2005-09-16  Senganal T  <tsenganal@novell.com>
 
 	* sqlserver.sql: modified. added string_family, datetime_family,
diff --git a/mcs/class/System.Data/Test/ProviderTests/sql/sqlserver.sql b/mcs/class/System.Data/Test/ProviderTests/sql/sqlserver.sql
index 117b41ae1d3..4c1cad0956f 100644
--- a/mcs/class/System.Data/Test/ProviderTests/sql/sqlserver.sql
+++ b/mcs/class/System.Data/Test/ProviderTests/sql/sqlserver.sql
@@ -3,6 +3,7 @@ if exists (select name from sysdatabases where
         drop database [mono-test];
 create database [mono-test];
 grant all privileges on [mono-test] to monotester;
+go
 
 use monotest;
 
@@ -14,7 +15,8 @@ if exists (select name from sysobjects where
 	drop table numeric_family;
 go
 
-create table numeric_family(id tinyint PRIMARY KEY NOT NULL,
+create table numeric_family(
+	id int PRIMARY KEY NOT NULL,
         type_bit bit NULL,
         type_tinyint tinyint NULL,
         type_smallint smallint NULL,
@@ -47,7 +49,7 @@ if exists (select name from sysobjects where
 go
 
 create table binary_family (
-        id tinyint PRIMARY KEY NOT NULL,
+        id int PRIMARY KEY NOT NULL,
         type_binary binary NULL,
         type_varbinary varbinary (255) NULL,
         type_blob image NULL,
@@ -78,7 +80,8 @@ if exists (select name from sysobjects where
 	drop table string_family;
 go
 
-create table string_family(id tinyint PRIMARY KEY NOT NULL,
+create table string_family(
+	id int PRIMARY KEY NOT NULL,
         type_guid uniqueidentifier NULL,
         type_char char(10) NULL,
         type_varchar varchar(10) NULL,
@@ -105,7 +108,7 @@ if exists (select name from sysobjects where
 go
 
 create table datetime_family (
-        id tinyint PRIMARY KEY NOT NULL,
+        id int PRIMARY KEY NOT NULL,
         type_smalldatetime smalldatetime NULL,
         type_datetime datetime NULL);
 
diff --git a/mcs/class/System.Data/Test/ProviderTests/sql/sybase.sql b/mcs/class/System.Data/Test/ProviderTests/sql/sybase.sql
index 2d31ee3ad57..0f84f1091e7 100644
--- a/mcs/class/System.Data/Test/ProviderTests/sql/sybase.sql
+++ b/mcs/class/System.Data/Test/ProviderTests/sql/sybase.sql
@@ -20,6 +20,8 @@ create table numeric_family (
 	type_numeric numeric (38, 0) NULL,
 	type_money money NULL,
 	type_smallmoney smallmoney NULL)
+
+grant all on numeric_family to monotester
 go
 
 insert into numeric_family values (1,1,255,32767,2147483647,9223372036854775807,1000,1000,922337203685477.5807,214748.3647)
@@ -46,6 +48,8 @@ create table binary_family (
 	type_tinyblob image NULL,
 	type_mediumblob image NULL,
 	type_longblob_image image NULL)
+
+grant all on binary_family to monotester
 go
 
 insert into binary_family values (1, convert (binary, '555555'), convert (varbinary, '0123456789012345678901234567890123456789012345678901234567890123456789'), 
@@ -98,6 +102,8 @@ begin
 end
 go
 
+grant all on sp_clean_employee_table to monotester
+go
 
 -- SP : sp_get_age
 if exists (select name from sysobjects where 
@@ -115,6 +121,8 @@ begin
 end
 go
 
+grant all on sp_get_age to monotester
+go
 
 
 -- =================================== END OBJECT EMPLOYEE ============================