Daab Set-up for Oracle


G

Guest

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DAAB with Oracle ref cursors 2
Trying to use Nile Oracle DAAB in VB 1
DAAB 3.0 2
Using DAAB 0
DAAB and datagrid 4
TableMappings in DAAB 1
Setting Oracle Schema 1
ParameterDirection.ReturnValue parameters in DAAB 2

Top