Quartz.NET using dotConnect for Oracle

Quartz.NET using dotConnect for Oracle

Postby devartRR » Tue 29 Dec 2015 16:42

Has any body tried to use dotConnect for Oracle as the DB provider for Quartz.NET scheduling service? If so what does the configuration in general and connection string in particular look like?
devartRR
 
Posts: 4
Joined: Tue 02 Jun 2015 06:02

Re: Quartz.NET using dotConnect for Oracle

Postby Shalex » Wed 30 Dec 2015 18:52

JIC: our provider supports standard ADO.NET interfaces. If you encounter any provider specific issue, please give us its detailed description.
Shalex
Devart Team
 
Posts: 7533
Joined: Thu 14 Aug 2008 12:44

Re: Quartz.NET using dotConnect for Oracle

Postby devartRR » Fri 08 Jan 2016 19:46

Actually figured it out. Here is how

1. If you are using TNSnames.ora file then use it like this

<add key="quartz.dataSource.default.connectionString" value="Data Source=tnsfile-entry;User Id=xxxxxxxxx;Password=xxxxxxxxx"/>

2. if you do not have tns names file - use it like this
<add key="quartz.dataSource.default.connectionString" value="Data Source = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = service_name)));User Id=xxxxxxx;Password=xxxxxxxxxx;"/>
devartRR
 
Posts: 4
Joined: Tue 02 Jun 2015 06:02


Return to dotConnect for Oracle