SQL 2014 not shown in database driver window

Posts   
 
    
kakaiya
User
Posts: 161
Joined: 20-Mar-2004
# Posted on: 13-Sep-2014 16:21:28   

Hi,

We are in a process to update to SQL2014 but do not see option for SQL 2014.

Could you please let me know.

Regards,

Attachments
Filename File size Added on Approval
SQL2014.png 8,171 13-Sep-2014 16:21.40 Approved
Otis avatar
Otis
LLBLGen Pro Team
Posts: 39614
Joined: 17-Aug-2003
# Posted on: 14-Sep-2014 11:03:56   

Just pick that driver, it will work with 2014, as nothing really changed for 2014 compared to 2012. I assume you're not on 4.2?

Frans Bouma | Lead developer LLBLGen Pro
kakaiya
User
Posts: 161
Joined: 20-Mar-2004
# Posted on: 17-Sep-2014 05:29:46   

Hi Otis,

Thanks.

Using LLBLGen 4.2 at the moment.

Also in Web.config, using key <add key="SqlServerDQECompatibilityLevel" value="6"/>

Is different value instead of 6 is required for SQL2014 compatibility level?

Regards.

Walaa avatar
Walaa
Support Team
Posts: 14950
Joined: 21-Aug-2005
# Posted on: 17-Sep-2014 07:33:44   

6 is correct, that's the one used for SQL Server 2012, nothing else is required for connecting to SQL Server 2014.

Posts: 18
Joined: 26-Jun-2006
# Posted on: 04-Apr-2015 15:24:27   

Hi

I have an application that use LLBLGEN Pro 2.0 and sql sever 2005, I am migrating project to SQL server express 2014.

problem is "Catalog Refresh" failed, LLBLGEN can not see sql server,

is there a restriction for LLBLGEN to see sql server 2014?

Please help me

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 05-Apr-2015 03:41:47   

Hi cadolfo, v2.x drivers don't have support anymore, as they have +7 years old. So no adjustments will me made for the driver for sqlserver 2014. v3.x and higher versions do have support for SQL Server 2014.

So, you can resolve this in two ways:

A) Update to v3.x or v4.x

B) Refresh catalog against a SQLServer 2000/2005/2008/2010/2012 DB. Then in your generated projects, point to the new 2014 DB. In other words: use the old version to refresh the schema, and the new version for runtime.

P.S.: Please don't re-open old threads, instead create a new one wink : http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=7722

David Elizondo | LLBLGen Support Team