Daab Set-up for Oracle

microsoft.public.dotnet.framework.adonet

13 Nov 2005 11:07 PM

Larry

I am able to get Sql server working fine but I am having difficulty getting
oracle vrsion 9i to work.

I receive the same error when I change the datbase instance name and
connection string name from MYOracleDBInstance to database.

The error is
Keyword not supported: 'database'.
or
Keyword not supported: 'MYOracleDBInstance'.

CODE:
      'Dim sdatabaseInstance = "MYOracleDBInstance"
        'Dim db As Database =
DatabaseFactory.CreateDatabase(sdatabaseInstance)
        Dim db As Database = DatabaseFactory.CreateDatabase()
        Dim sqlCommand As String = "Select ids_edition_key From IDS_EDITION;"
        Dim dbCommandWrapper As DBCommandWrapper =
db.GetSqlStringCommandWrapper(sqlCommand)

        DataGrid1.DataSource = db.ExecuteReader(dbCommandWrapper)
        DataGrid1.DataBind()
Stack Trace:

[ArgumentException: Keyword not supported: 'database'.]
   System.Data.OracleClient.DBConnectionString.ParseInternal(Char[]
connectionString, UdlSupport checkForUdl, NameValuePair& keychain)
   System.Data.OracleClient.DBConnectionString..ctor(String
connectionString, UdlSupport checkForUdl)
   System.Data.OracleClient.OracleConnectionString..ctor(String
connectionString)
   System.Data.OracleClient.OracleConnectionString.ParseString(String
connectionString)
   System.Data.OracleClient.OracleConnection.set_ConnectionString(String
value)
   System.Data.OracleClient.OracleConnection..ctor(String connectionString)

Microsoft.Practices.EnterpriseLibrary.Data.Oracle.OracleDatabase.GetConnection()
   Microsoft.Practices.EnterpriseLibrary.Data.Database.OpenConnection()

Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteReader(DBCommandWrapper command)

Microsoft.Practices.EnterpriseLibrary.Data.Oracle.OracleDatabase.ExecuteReader(DBCommandWrapper commandWrapper)
   oracle_daab_testing.WebForm1.Page_Load(Object sender, EventArgs e) in
c:\inetpub\wwwroot\oracle_daab_testing\WebForm1.aspx.vb:39
   System.Web.UI.Control.OnLoad(EventArgs e)
   System.Web.UI.Control.LoadRecursive()
   System.Web.UI.Page.ProcessRequestMain()

Thanks,
Larry