- - Connection timeouts is being developed now.
+
- Have a working mono and mcs installed
+
+ - Have access to a Microsoft SQL Server database
+ or either download it:
+
+
+
+ - IMPORTANT: If using Microsoft SQL Server 2000, make sure
+ you are using at least Service Pack 3 for Microsoft SQL Server 2000. If using
+ MSDE 2000, make sure you have the special Service Pack 3 for MSDE 2000. You
+ can get it from here
+
+ - For those that only have MSDE installed. You can change the authentication mode
+ from Windows Only Authentication to SQL Server and Windows Authentications (also knows as Mixed-mode authentication)
+ via the registry
. It is
+ the LoginMode you need to change. By default,
+ MSDE is installed with Windows Only Authentication. If you want SqlClient to work with MSDE via SQL Server authentication, you will
+ need to change the setting. Otherwise, you wil have to use NT Authentication.
+
+ - If using MSDE, you might need to create a new user with password. Give
+ this user access to various databases in this MSDE instance. Also, for each
+ database, give this new user at least SELECT access to the various tables you want
+ to retrieve data from.
+
+ - If you have Enterprise Manager, you can easily change the authentication mode
+ for both MSDE and Microsoft SQL Server. To change the authentication mode in
+ Enterprise Mananger, select the instance, right-click on it, and select properites.
+ The SQL Server properties dialog for that instance will pop up. Choose the Security
+ tab. Change the Authentication from Windows Only to SQL Server and Windows. If
+ the instance of your database does not show up in Enterprise Manager, Register first
+ by selecting the Action menu and choosing New SQL Server Registration.
+
+ - Located at mcs/class/System.Data/Test is a test for System.Data.SqlClient
+ named SqlTest.cs and you could use this as a basis for your test.
+
+ - If you want to use Integrated Security (aka NT Authentication aka Trusted Connection aka Domain Login), you
+ will need to specify the Domain User ID and Password. This is because Mono is not integrated with Windows
+ nor SQL Server.
+
+ - Has a connection string format for SQL Server Authentication:
+
+ Server=hostname;
+ Database=databaseName;
+ User ID=sqlServerUserid;
+ Password=sqlServerPassword
+
+
+ - Has a connection string format for NT Authentication:
+
+ Server=hostname;
+ Database=databaseName;
+ User ID=windowsDomain\windowsUserid;
+ Password=windowsPassword;
+ Integrated Security=SSPI
+
+
+
+ - The Server part can be used three ways:
+
+
+
+ | Server Definition | Example |
+
+
+
+ | hostname | Server=MYHOST |
+
+
+
+ | hostname,port | Server=MYHOST,1433 |
+
+
+
+ | hostname\instance | Server=MYHOST\NETSDK |
+
+
+
+
+ - C# Example using SQL Server Authentication:
+
+ using System;
+ using System.Data;
+ using System.Data.SqlClient;
+
+ public class Test
+ {
+ public static void Main(string[] args)
+ {
+ string connectionString =
+ "Server=MyServer;" +
+ "Database=pubs;" +
+ "User ID=MySqlServerUserId;" +
+ "Password=MySqlServerPassword;";
+ IDbConnection dbcon;
+ dbcon = new SqlConnection(connectionString);
+ dbcon.Open();
+ IDbCommand dbcmd = dbcon.CreateCommand();
+ string sql =
+ "SELECT fname, lname " +
+ "FROM employee";
+ dbcmd.CommandText = sql;
+ IDataReader reader = dbcmd.ExecuteReader();
+ while(reader.Read()) {
+ string FirstName = (string) reader["fname"];
+ string LastName = (string) reader["lname"];
+ Console.WriteLine("Name: " +
+ FirstName + " " + LastName);
+ }
+ // clean up
+ reader.Close();
+ reader = null;
+ dbcmd.Dispose();
+ dbcmd = null;
+ dbcon.Close();
+ dbcon = null;
+ }
+ }
+
+
+
+ - C# Example using NT Authentication (Integrated Security)
+
+ using System;
+ using System.Data;
+ using System.Data.SqlClient;
+
+ public class Test
+ {
+ public static void Main(string[] args)
+ {
+ string connectionString =
+ "Server=MyServer;" +
+ "Database=pubs;" +
+ "User ID=MyWindowsDomain\\MyWindowsUserid;" +
+ "Password=MyWindowsPassword;" +
+ "Integrated Security=SSPI";
+ IDbConnection dbcon;
+ dbcon = new SqlConnection(connectionString);
+ dbcon.Open();
+ IDbCommand dbcmd = dbcon.CreateCommand();
+ string sql =
+ "SELECT fname, lname " +
+ "FROM employee";
+ dbcmd.CommandText = sql;
+ IDataReader reader = dbcmd.ExecuteReader();
+ while(reader.Read()) {
+ string FirstName = (string) reader["fname"];
+ string LastName = (string) reader["lname"];
+ Console.WriteLine("Name: " +
+ FirstName + " " + LastName);
+ }
+ // clean up
+ reader.Close();
+ reader = null;
+ dbcmd.Dispose();
+ dbcmd = null;
+ dbcon.Close();
+ dbcon = null;
+ }
+ }
+
+
+
+ - Building C# Example:
+
+
+ - Running the Example:
+
+mono TestExample.exe
+
+
- - TODO
+