X-Git-Url: http://wien.tomnetworks.com/gitweb/?a=blobdiff_plain;f=web%2Fibmdb2;h=3f148232652e5cb1f3b4f7cadf24a4341471fbd4;hb=0d70288ef4305a7c88b1e63d6909218dd5b04691;hp=6197e49bffb8df3c94bb85baabf820f2dbd6d81f;hpb=726fef391cc423f85f0dd1a40a00c63cdfb7a570;p=mono.git
diff --git a/web/ibmdb2 b/web/ibmdb2
index 6197e49bffb..3f148232652 100755
--- a/web/ibmdb2
+++ b/web/ibmdb2
@@ -1,17 +1,24 @@
* IBM DB2 Data Provider
+ - ADO.NET Data Provider for IBM DB2 Universal Database
+
- Exists in namespace DB2ClientCS and assembly Mono.Data.DB2Client
- The source code exists at mcs/class/Mono.Data.DB2Client
- Requires the Call Level Interface to IBM DB2 shared library. This
is db2cli.dll on Windows. The IBM DB2 CLI API is very similar to the ODBC API. If
- you take a look at Mono's System.Data.Odbc ODBC provider, you will see the
+ you take a look at Mono's System.Data.Odbc ODBC provider, you will see the
DllImport's have similiar function names.
-
- - IBM DB2 Universal Database can be downloaded from IBM.
-
+
- IBM DB2 Provider created by Christopher Bockner.
+
+ - 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
@@ -22,6 +29,8 @@
Able to connect to IBM DB2
Able to execute DML, such as, CREATE TABLE via ExecuteNonQuery()
+
+ Christopher says it can retrieve data via the DB2ClientDataReader
@@ -49,6 +58,21 @@ In order to test.
If you do not have the source to mcs, get the source from
here
+ Has a ConnectionString format like ODBC
+
+ Here is a ConnectionString format if you have a DSN setup:
+
+ "DSN=dataSetName;UID=myuserid;PWD=mypassword"
+
+
+
+ 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):
+
+ "DRIVER={DB2 Driver};SERVER=localhost;DATABASE=test;UID=myuserid;PASSWORD=mypassword"
+
+
+
In mcs/class/Mono.Data.DB2Client/Test/DBConnTest, you will find
a DBConnTest.cs.
@@ -87,6 +111,7 @@ mono DBConnTest.exe database userid password
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 ( " +