Link to home
Start Free TrialLog in
Avatar of Cav IT
Cav ITFlag for South Africa

asked on

SQL Native Driver for SQL 2014

Hi

Trying to restore our ERP software DB to SQL Server 2014 from SQL Server 2008.

Getting a ODBC Driver version error. My understanding is that there isn't a native client 12, only a 11?

The system calls the correct driver from a flat file by using the following command.
dbconnstr=DRIVER={SQL Server Native Client 11.0}

Any suggestions.
CSB-Error.JPG
Avatar of Dave Baldwin
Dave Baldwin
Flag of United States of America image

Here is info and a link to a download: https://msdn.microsoft.com/en-us/library/cc280510.aspx
Avatar of Cav IT

ASKER

That is the download for Native Client 11, I need 12.
Avatar of Cav IT

ASKER

Tried that, it also installs version 11
ASKER CERTIFIED SOLUTION
Avatar of Cav IT
Cav IT
Flag of South Africa image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Glad you got it working.  It does require the exact name of the driver.
Yeaktom, do you still need help with this question?
Avatar of Cav IT

ASKER

The solution was vendor spesific