X-Git-Url: http://wien.tomnetworks.com/gitweb/?a=blobdiff_plain;f=doc%2Ftdsclient;h=56629335caf93368be29a7cdadae09129d2efc78;hb=de6d7a5ccedda43516abba47206a2a834ad6a475;hp=c5f494a7c66135a80f88ffa21bfd19c6144ade04;hpb=c40860f8f6073bf2e89beb08857b7e5b1cfb39bc;p=mono.git diff --git a/doc/tdsclient b/doc/tdsclient index c5f494a7c66..56629335caf 100755 --- a/doc/tdsclient +++ b/doc/tdsclient @@ -19,6 +19,13 @@
  • Uses TDS Protocol Version 4.2 by default
  • Does not support trusted connections
  • + +
  • Bugs with Mono or the data provider should be reported + in Mono's Bugzilla here. If you + do not have Bugzilla user account, it is free + and easy to + create one here.
  • + ** Current Status @@ -65,10 +72,24 @@
  • Sybase
  • +
  • If using Microsoft SQL Server 2000, make sure + you are using at least Service Pack 3 for Microsoft SQL Server 2000
  • 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.
  • +
  • Has a connection string format: +
    + Server=hostname;Database=databaseName;User ID=userid;Password=password
    +
    +
  • +
  • The Server part can be used two ways: + +
  • +
  • C# Example:
      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"];