4 <li>ADO.NET Provider for older Sybase and Microsoft SQL Server databases</li>
6 <li>Exists in namespace Mono.Data.TdsClient and assembly Mono.Data.TdsClient</li>
8 <li>Created by Tim Coleman</li>
10 <li>Used the <a href="http://www.freetds.org/">FreeTDS</a> and
11 <a href="http://jtds.sourceforge.net/">jTDS</a> projects as resources.</li>
13 <li>Implemented in 100% C#</li>
15 <li>Is similar to the Mono.Data.SybaseClient and System.Data.SqlClient providers.</li>
17 <li>Requires the assembly Mono.Data.Tds.dll which implements the TDS protocol in 100% C#.</li>
19 <li>Uses TDS Protocol Version 4.2 by default</li>
21 <li>Does not support trusted connections</li>
23 <li>Bugs with Mono or the data provider should be reported
24 in Mono's Bugzilla <a href="http://bugzilla.ximian.com/">here</a>. If you
25 do not have Bugzilla user account, it is free
27 create one <a href="http://bugzilla.ximian.com/createaccount.cgi">here</a>.</li>
35 <li>Only builds on Windows currently due to mcs does not support modules and mcs
36 has problems with code that is internal.</li>
38 <li>Able to connect to Microsoft SQL Server and Sybase databases</li>
40 <li>SQL commands can be executed
41 via ExecuteNonQuery() of a TdsCommand.</li>
43 <li>SQL aggregates can be executed and a single row and single column
44 result can be retrieved via ExecuteScalar() of a TdsCommand</li>
46 <li>SQL queries can be executed via ExecuteReader() and results
47 can be retrieved via TdsDataReader.</li>
49 <li>a DataTable with schema info about a result can be gotten via GetSchemaTable()
50 in a TdsDataReader</li>
52 <li>Data can be filled in a DataTable in a DataSet via a TdsDataAdapter</li>
58 <li>Connection timeouts is being developed now.</li>
66 <li>Have a working mono and mcs installed</li>
68 <li>Have access to a Sybase or Microsoft SQL Server database
69 or either download it:
71 <li><a href="http://www.microsoft.com/sql/default.asp">Microsoft SQL Server</a></li>
72 <li><a href="http://www.sybase.com/downloads">Sybase</a></li>
75 <li>If using Microsoft SQL Server 2000, make sure
76 you are using at least Service Pack 3 for Microsoft SQL Server 2000</li>
78 <li>Located at mcs/class/System.Data/Test is a test for System.Data.SqlClient
79 named SqlTest.cs and you could use this as a basis for your test.</li>
81 <li>Has a connection string format:
83 Server=hostname;Database=databaseName;User ID=userid;Password=password
86 <li>The Server part can be used two ways:
88 <li>hostname - "Server=MYHOST"</li>
89 <li>hostname,port - "Server=MYHOST,1533"</li>
97 using Mono.Data.TdsClient;
101 public static void Main(string[] args)
103 string connectionString =
104 "Server=localhost;" +
106 "User ID=myuserid;" +
107 "Password=mypassword;";
109 dbcon = new TdsConnection(connectionString);
111 IDbCommand dbcmd = dbcon.CreateCommand();
113 "SELECT fname, lname " +
115 dbcmd.CommandText = sql;
116 IDataReader reader = dbcmd.ExecuteReader();
117 while(reader.Read()) {
118 string FirstName = (string) reader["fname"];
119 string LastName = (string) reader["lname"];
120 Console.WriteLine("Name: " +
121 FirstName + " " + LastName);
134 <li>Building C# Example:
136 <li>Save the example to a file, such as, TestExample.cs</li>
139 mcs TestExample.cs -r System.Data.dll \
140 -r Mono.Data.TdsClient.dll
143 <li>Build on Windows via Cygwin:
145 mono C:/cygwin/home/MyHome/mono/install/bin/mcs.exe \
147 -lib:C:/cygwin/home/MyHome/mono/install/lib \
148 -r System.Data.dll -r Mono.Data.TdsClient.dll
153 <li>Running the Example: