I have a Quartz for .Net service that retrievs data from an Oracle 12c database using
. I am able to connect and get values when attempting this from a Console application but once i migrate the code and bundle it into a Quartz scheduler service i get the error
Connection parameter not supported: 'DATABASE'
when the job runs.
I have implemented the service on several Quartz.net jobs that connect to Sql Server without such issues. It appears this problem is particular to connection strings for the Oracle provider.
My Quartz service implementation is taken from the example here :
and my connection string is as below :
<add name="FCUBS" connectionString="user id=MYUSERNAME;password=mypassword*;data source=10.167.67.667:6767/COMPANYLIVE" />
and for context the accompanying query operation is :
public static double GetExchangeRate()
var flex = new FrontOfficeTransaction();
double rate = 0.00;
using (OracleConnection connp = new OracleConnection(FCUBSConnection))
OracleCommand cmd1 = new OracleCommand("select * from fgpreprod.xxxx_rates where ccy4 in ('USD','GBP') AND ccy2 in ('USD','GBP') and branch_code='089' and RATE_TYPE='MIDRATE'", connp);
OracleDataReader dr1 = cmd1.ExecuteReader();
flex.ExchangeRate = Convert.ToDouble(dr1["MID_RATE"]);
rate = flex.ExchangeRate;
catch (Exception ex)
What I have tried:
I have tried using Serve
r instead of data source
as per suggestions from some sources but im still getting the error :
<add name="FCUBS" connectionString="user id=MYUSERNAME;password=mypassword*;Server=10.167.67.667:6767/COMPANYLIVE" />