extras/MonoDevelop.Database/MonoDevelop.Database.Sql.Odbc/OdbcConnectionProvider.cs

   1 //
   2 // Authors:
   3 //   Christian Hergert  <chris@mosaix.net>
   4 //   Daniel Morgan <danielmorgan@verizon.net>
   5 //   Ben Motmans  <ben.motmans@gmail.com>
   6 //
   7 // Copyright (C) 2005 Mosaix Communications, Inc.
   8 // Copyright (C) 2005 Daniel Morgan
   9 // Copyright (c) 2007 Ben Motmans
  10 //
  11 // Permission is hereby granted, free of charge, to any person obtaining a copy
  12 // of this software and associated documentation files (the "Software"), to deal
  13 // in the Software without restriction, including without limitation the rights
  14 // to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
  15 // copies of the Software, and to permit persons to whom the Software is
  16 // furnished to do so, subject to the following conditions:
  17 //
  18 // The above copyright notice and this permission notice shall be included in
  19 // all copies or substantial portions of the Software.
  20 //
  21 // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
  22 // IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
  23 // FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
  24 // AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
  25 // LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
  26 // OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
  27 // THE SOFTWARE.
  28 //
  29
  30 using System;
  31 using System.Data;
  32 using System.Data.Odbc;
  33 using System.Collections.Generic;
  34 
namespace MonoDevelop.Database.Sql.Odbc
  35 {
  36         public class OdbcConnectionProvider : AbstractConnectionProvider
  37         {
  38                 public override IPooledDbConnection CreateConnection (IConnectionPool pool, DatabaseConnectionSettings settings, out string error)
  39                 {
  40                         string connStr = null;
  41                         try {
  42                                 if (settings.UseConnectionString)
  43                                         connStr = settings.ConnectionString;
  44                                 else
  45                                         throw new NotSupportedException ();
  46
  47                                 OdbcConnection connection = new OdbcConnection (connStr);
  48                                 connection.Open ();
  49
  50                                 error = null;
  51                                 return new OdbcPooledDbConnection (pool, connection);
  52                         } catch (Exception e) {
  53                                 error = e.Message;
  54                                 return null;
  55                         }
  56                 }
  57         }
  58 }