- <li>Here is a ConnectionString format if you do not have a DSN (have not
- gotten this to work though, so, I am open to suggestions):
-<pre>
- "DRIVER={DB2 Driver};SERVER=localhost;DATABASE=test;UID=myuserid;PASSWORD=mypassword"
-</pre>
- </li>
-
- <li>In mcs/class/Mono.Data.DB2Client/Test/DBConnTest, you will find
- a DBConnTest.cs.</li>
-
- <li>To build DBConnTest:
- <ul>
- <li>On Unix:</li>
-<pre>
-mcs DBConnTest.cs -r System.Data.dll -r Mono.Data.DB2Client.dll
-</pre>
- </li>
- <li>On Windows via Cygwin:
-<pre>
-mono C:/cygwin/home/MyHome/mono/install/bin/mcs.exe DBConnTest.cs \
- -lib:C:/cygwin/home/MyHome/mono/install/lib \
- -r System.Data.dll -r Mono.Data.DB2Client.dll
-</pre>
- </li>
- <li>To run it on mono:
-<pre>
-mono DBConnTest.exe database userid password
-</pre>
- </li>
- </ul>
- </li>
-
- <li>C# Example:
-<pre>
- using System;
- using System.Data;
- using Mono.Data.DB2Client;
-
- public class Test
- {
- public static void Main(string[] args)
- {
- string connectionString =
- "DSN=sample;UID=db2admin;PWD=mypass";
- IDbConnection dbcon = new DB2ClientConnection(connectionString);
- dbcon.Open();
- IDbCommand dbcmd = dbcon.CreateCommand();
- string sql =
- "CREATE TABLE mono_db2_test1 ( " +\r
- " testid varchar(2), " +\r
- " testdesc varchar(16) " +\r
- ")";
- dbcmd.CommandText = sql;
- dbcmd.ExecuteNonQuery();
- dbcmd.Dispose();
- dbcmd = null;
- dbcon.Close();
- dbcon = null;
- }
- }
-</pre>
- </li>
- <li>Building C# Example:
- <ul>
- <li>Save the example to a file, such as, TestExample.cs</li>
- <li>Build on Linux:
-<pre>
- mcs TestExample.cs -r System.Data.dll \
- -r Mono.Data.DB2Client.dll
-</pre>
- </li>
- <li>Build on Windows via Cygwin:
-<pre>
- mono C:/cygwin/home/MyHome/mono/install/bin/mcs.exe \
- TestExample.cs \
- -lib:C:/cygwin/home/MyHome/mono/install/lib \
- -r System.Data.dll -r Mono.Data.DB2Client.dll
-</pre>
- </li>
- </ul>
- </li>
- <li>Running the Example:
-<pre>
-mono TestExample.exe
-</pre>
- </li>
-