Cav IT
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
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
Here is info and a link to a download: https://msdn.microsoft.com/en-us/library/cc280510.aspx
ASKER
That is the download for Native Client 11, I need 12.
Look under Install Instructions on this page: https://www.microsoft.com/en-us/download/details.aspx?id=29065
ASKER
Tried that, it also installs version 11
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad you got it working. It does require the exact name of the driver.
Yeaktom, do you still need help with this question?
ASKER
The solution was vendor spesific