Oracle Support
Note: Oracle is not supported in the current open source version of ID.
Installation Instructions
- Install ODAC 11.1.0.7.20 with Xcopy Deployment (Oracle .NET classes and Instant client) in a directory (for example C:\Oracle\ODAC) in the IIS machine
- Make sure you update your PATH environment variable according to the ODAC readme.
- Copy the DALServicesOracle.cs into the app_code directory
- Either add OracleDataAccess.dll by referencing it in Visual Studio or by adding the following line to the web.config
<add assembly="Oracle.DataAccess, Version=2.111.6.20, Culture=neutral, PublicKeyToken=89B483F429C47342"/>
- Configure your Oracle Data Source by adding this line to the web.config
<connectionStrings>
....
<add name="OracleTest" connectionString="Data Source=HOST\INSTANCENAME;User Id=scott;Password=tiger;"/>
</connectionStrings>
- When you want to use the Oracle connection in the javascript side use the following
options = { 'URL': '../../../DALService.svc/CallProcedure'
, 'DatabaseConnectionParams': {
'Engine': 'Oracle'
, 'ConnectionStringName': 'OracleTest'
, 'Procedure': 'Scott.pcGetCitiesList.spGetCitiesList'
, 'TablesCount': 1
}
};