//***app.config***** <databases> <add key="PERP\Connection" value="Data Source=perp;Persist Security Info=True;User ID=SomePass;Unicode=True" /> <add key="PERP\DataAccessClass" value="DataAccessOracle" /> </databases>This is what is in my BuisnessObject.cs
public ABusinessObject() { this.DatabaseKey = "PERP"; *****this.RetrieveAutoIncrementPK = true; I am not using this line because ***** I will take care of the key in the trigger. }>Secondly, I took a look at the Business Layer Generator source code and I see the current version you have does not instantiate a data access class for Oracle. We are getting ready to release a new version in a matter of days and this version will work properly with the Oracle .NET Data Provider.
'PERP'
In the Connection String it hasData Source=perp;Persist Security Info=True;User ID=rfi;Password=xxxxx;Unicode=Truewhen I don't put the password in there it grips that the password is null.
.NET Framework Data Provider for OracleWhen I press the Get Data Button I get these errors
**** 1st Error ***** --------------------------- Add-in Exception --------------------------- Message: ORA-00933: SQL command not properly ended Source: System.Data.OracleClient Stack Trace: at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc) at System.Data.OracleClient.OracleCommand.Execute (OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals) at System.Data.OracleClient.OracleCommand.Execute (OciStatementHandle statementHandle, CommandBehavior behavior, ArrayList& resultParameterOrdinals) at System.Data.OracleClient.OracleCommand.ExecuteReader(CommandBehavior behavior) at System.Data.OracleClient.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal (DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at OakLeaf.MM.Main.Data.mmDataAccessOracle.GetListOfTableFields(String tableName) at MMBusinessLayerGenerator.mmWizardPageSelectData.GetDatabaseObjectColumns (mmDatabaseObjectKind databaseObjectKind, String objectName) in C:\Program Files\Mere Mortals .NET Framework 2005 \MMBusinessLayerGenerator\MMBusinessLayerGenerator\mmWizardPageSelectData.cs:line 1233And the Second Error:
***** 2nd Error --------------------------- Add-in Exception --------------------------- Message: Object reference not set to an instance of an object. Source: MMBusinessLayerGenerator Stack Trace: at MMBusinessLayerGenerator.mmWizardPageSelectData.ProcessDBCObjects(DataTable dtDatabaseObjects, mmDatabaseObjectKind databaseObjectKind, Hashtable databaseObjectColumns, List`1 physicalObjectNames, List`1 businessClassNames, List`1 businessRuleNames, List`1 defaultValueClassNames, List`1 entityNames, List`1 businessObjectDisplayNames, List`1 primaryKeys, String businessObjectPrefix, String businessObjectSuffix, String businessRulePrefix, String businessRuleSuffix, String defaultsPrefix, String defaultsSuffix, String entityPrefix, String entitySuffix, String tableStripPrefix) in C:\Program Files\Mere Mortals .NET Framework 2005 \MMBusinessLayerGenerator\MMBusinessLayerGenerator\mmWizardPageSelectData.cs:line 1115 at MMBusinessLayerGenerator.mmWizardPageSelectData.GetDatabaseObjects() in C:\Program Files\Mere Mortals .NET Framework 2005 \MMBusinessLayerGenerator\MMBusinessLayerGenerator\mmWizardPageSelectData.cs:line 965Kevin, We don't know what else to do. Dan and I are very new to .Net and MM.Net.