We´re developing a system that needs two different databases. Each client has its own old db in Oracle or SQLServer from where we get info, and the new project SQLServer db with migrations.
If the client uses also SQLServer, the project build without problems and can be deployed nicely. But as soon as the system is mixed ( the client uses Oracle) we get an InvalidOperationException when the Database.SetInitializer method is called.
The system tries to execute this select:
Code: Select all
select cast(serverproperty('EngineEdition') as int)
Did anyone deal with something similar or know what can be happening?
Connectionstrings seem to be fine, but we have no idea what can be failing..
Code: Select all
<add name="EPDbConnection" connectionString="Server=DBSERVER;Database=HR.EP;Trusted_Connection = True;MultipleActiveResultSets=True;" providerName="System.Data.SqlClient" />
<add name="ClientDbConnection" connectionString="user id=FOO; password=TOO; Host=172.0.0.1; Service Name=oracle10; Port=1522; Direct=true;" providerName="Devart.Data.Oracle" />