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
|