add myself

[mono.git] / doc / tdsclient

diff --git a/doc/tdsclient b/doc/tdsclient
index c5f494a7c66135a80f88ffa21bfd19c6144ade04..56629335caf93368be29a7cdadae09129d2efc78 100755 (executable)
--- a/doc/tdsclient
+++ b/doc/tdsclient
@@ -19,6 +19,13 @@
        <li>Uses TDS Protocol Version 4.2 by default</li>
        
        <li>Does not support trusted connections</li>
+       
+       <li>Bugs with Mono or the data provider should be reported 
+       in Mono's Bugzilla <a href="http://bugzilla.ximian.com/">here</a>.  If you
+       do not have Bugzilla user account, it is free 
+       and easy to 
+       create one <a href="http://bugzilla.ximian.com/createaccount.cgi">here</a>.</li>
+
 </ul>
 
 ** Current Status
@@ -65,10 +72,24 @@
                        <li><a href="http://www.sybase.com/downloads">Sybase</a></li>
                </ul>
        </li>
+       <li>If using Microsoft SQL Server 2000, make sure
+       you are using at least Service Pack 3 for Microsoft SQL Server 2000</li>
        
        <li>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.</li>
        
+               <li>Has a connection string format:
+<pre>
+ Server=hostname;Database=databaseName;User ID=userid;Password=password
+</pre>
+       </li>
+       <li>The Server part can be used two ways:
+               <ul>
+                       <li>hostname - "Server=MYHOST"</li>
+                       <li>hostname,port - "Server=MYHOST,1533"</li>
+               </ul>
+       </li>
+       
        <li>C# Example:
 <pre>
  using System;
@@ -82,15 +103,16 @@
        string connectionString = 
           "Server=localhost;" +
           "Database=pubs;" +
-          "User ID=sa;" +
-          "Password=;";
+          "User ID=myuserid;" +
+          "Password=mypassword;";
        IDbConnection dbcon;
        dbcon = new TdsConnection(connectionString);
+       dbcon.Open();
        IDbCommand dbcmd = dbcon.CreateCommand();
        string sql = 
            "SELECT fname, lname " +
            "FROM employee";
-       dbcmd.ConnectionString = sql;
+       dbcmd.CommandText = sql;
        IDataReader reader = dbcmd.ExecuteReader();
        while(reader.Read()) {
             string FirstName = reader["fname"];