Hi, I'm having an issue with adding tables from an Oracle database in the DataConnections Server Explorer column. I have added the Properties 'Connection String' attribute under 'Roundtripping' to be:
Data Source=MEMS.ADMIN;User ID=admin;Password=*****;Unicode=True
and it doesn't matter if I specify something in that row or not, it keeps giving me the following Exception (please note the password above was cleared and is correctly specified in the solution):
Any help would be greatly appreciated. Thank You.
Exception while processing Server Explorer drag: Mindscape.LightSpeed.Generator.Model.GenerationException: Couldn't connect to the database. Check that the connection information is correct. ---> System.Data.OracleClient.OracleException: ORA-01005: null password given; logon denied
at System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc)
at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
at System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
at System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OracleClient.OracleConnection.Open()
at Mindscape.LightSpeed.Generator.Extraction.Oracle9.OpenConnection()
--- End of inner exception stack trace ---
at Mindscape.LightSpeed.Generator.Extraction.Oracle9.OpenConnection()
at Mindscape.LightSpeed.Generator.Extraction.Provider`1.ExtractModel(Boolean pluralise, IList`1 tablesToFullyPopulate)
at Mindscape.LightSpeed.Generator.Integration.EntityExtractor.PopulateTypeModel(ILightSpeedDataSource connection, IList`1 tableNames, Boolean pluralisedInDatabase)
at Mindscape.LightSpeed.Generator.Integration.EntityBuilder.AddTablesToModel(Model model, ILightSpeedDataSource connection, IEnumerable`1 tableNames, IGenerationLog log)
at Mindscape.LightSpeed.Generator.Integration.DiagramDragDropHandler.<>c__DisplayClass4.<OnDragDrop>b__3(DragObject dragObject, IGenerationLog log)
at Mindscape.LightSpeed.Generator.Integration.ServerExplorer.IfIsServerExplorerDrag(DragEventArgs e, DragAction action)
