fixed suse links

[mono.git] / web / oledb

diff --git a/web/oledb b/web/oledb
index a4f80e53d474bfc889dee53370473aa856e0117d..caa032fd8bb868e9a07b98ee5fee167a6b6904e1 100755 (executable)
--- a/web/oledb
+++ b/web/oledb
@@ -27,6 +27,14 @@
        </li>
        
        <li>Does not support trusted connections</li>
+       
+       <li>Bugs with Mono or the data provider should be reported 
+       in Mono's Bugzilla <a href="http://bugzilla.ximian.com/">here</a>.  If you
+       do not have Bugzilla user account, it is free 
+       and easy to 
+       create one <a href="http://bugzilla.ximian.com/createaccount.cgi">here</a>.</li>
+
+       
 </ul>
        
 ** Current Status
@@ -82,9 +90,12 @@
        string connectionString = 
           "Provider=PostgreSQL;" +
           "Addr=127.0.0.1;" +
-          "Database=rodrigo";
+          "Database=test;" +
+          "User ID=postgres;" +
+          "Password=fun2db";
        IDbConnection dbcon;
        dbcon = new OleDbConnection(connectionString);
+       dbcon.Open();
        IDbCommand dbcmd = dbcon.CreateCommand();
        // requires a table to be created named employee
        // with columns firstname and lastname
@@ -95,7 +106,7 @@
        string sql = 
             "SELECT firstname, lastname " + 
             "FROM employee";
-       dbcmd.ConnectionString = sql;
+       dbcmd.CommandText = sql;
        IDataReader reader = dbcmd.ExecuteReader();
        while(reader.Read()) {
             string FirstName = reader["firstname"];