2 // OdbcTest.cs - Test for the ODBC ADO.NET Provider in System.Data.Odbc
\r
4 // The test works on Windows XP using Microsoft .NET Framework 1.1 Beta
\r
6 // To compile under Windows using Microsoft .NET 1.1
\r
7 // E:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\csc OdbcTest.cs /reference:System.Data.dll
\r
9 // To compile under Windows using Mono:
\r
10 // mcs OdbcTest.cs -r System.Data.dll
\r
12 // I have not tested it on Linux using unixODBC
\r
15 // Daniel Morgan <danmorg@sc.rr.com>
\r
20 using System.Data.Odbc;
\r
22 namespace Test.OdbcTest
\r
27 static void Main(string[] args)
\r
29 OdbcConnection dbcon = new OdbcConnection();
\r
30 // connection string to a Microsoft SQL Server 2000 database
\r
31 // that does not use a DSN
\r
32 //dbcon.ConnectionString =
\r
33 // "DRIVER={SQL Server};" +
\r
34 // "SERVER=(local);" +
\r
35 // "Trusted_connection=true;" +
\r
36 // "DATABASE=pubs;";
\r
38 // connection string that uses a DSN.
\r
39 dbcon.ConnectionString =
\r
40 "DSN=LocalServer;UID=sa;PWD=";
\r
44 OdbcCommand dbcmd = new OdbcCommand();
\r
45 dbcmd.Connection = dbcon;
\r
46 dbcmd.CommandType = CommandType.Text;
\r
47 dbcmd.CommandText = "SELECT lname FROM employee";
\r
49 OdbcDataReader reader;
\r
50 reader = (OdbcDataReader) dbcmd.ExecuteReader();
\r
52 while(reader.Read()) {
\r
53 Console.WriteLine("Last Name: " + reader[0].ToString());
\r