Oracle 12c with LLBLGen Pro 2.6

Posts   
 
    
PRG
User
Posts: 3
Joined: 28-Jun-2016
# Posted on: 28-Jun-2016 11:45:35   

Hello,

We are currently using LLBLGen Pro 2.6 with Oracle 10.2.0.4 on the server. We plan to move to Oracle 12c.

Is LLBLGen Pro 2.6 compatible with Oracle 12c?

I understand full Oracle 12c support comes with LLBLGen Pro 4.1, but we will not use the new Oracle 12c functionality. We are trying to minimize the application changes required by the migration to Oracle 12c.

Regards Philippe

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39614
Joined: 17-Aug-2003
# Posted on: 28-Jun-2016 15:13:01   

PRG wrote:

Hello,

We are currently using LLBLGen Pro 2.6 with Oracle 10.2.0.4 on the server. We plan to move to Oracle 12c.

Is LLBLGen Pro 2.6 compatible with Oracle 12c?

No. The driver/DQE aren't compatible, you have to recompile the driver and DQE code and reference the 12c odp.net provider assembly. The source code is available on the website under 'my account -> 2.6' after you've logged in. We haven't tested this so it might be other things won't work as well as ODP.NET has changed over the years.

Frans Bouma | Lead developer LLBLGen Pro
PRG
User
Posts: 3
Joined: 28-Jun-2016
# Posted on: 30-Jun-2016 12:19:13   

Thanks for your answer.

If I'm correct, we're not using ODP.NET in our project. We are using the Microsoft Oracle provider (System.Data.OracleClient version 2.0.0.0), with an Oracle 11.2 client. Could that work with Oracle 12?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39614
Joined: 17-Aug-2003
# Posted on: 30-Jun-2016 21:03:43   

If System.Data.Oracle supports 12c's CLI client. System.Data.Oracle has been deprecated by Microsoft. You could try with the 12c client and 2.6, if that can connect with the 12c DB and work with it.

Frans Bouma | Lead developer LLBLGen Pro
PRG
User
Posts: 3
Joined: 28-Jun-2016
# Posted on: 15-Sep-2016 10:30:40   

The following combination works for us: * Oracle 12c database * Oracle 11.2 client (supported with Oracle 12c by Oracle) * System.Data.OracleClient * llblgen 2.6

It's clearly not the best combination, but it works and that's what we need for now.