I'm a persistent beginner with Azure SQL. Got to step 4 load data into table. Then got this error 'Error = [Microsoft][ODBC Driver 13 for SQL Server][SQL Server].........' So I downloaded & attempted to install the driver from Microsoft & got this Any suggestions ? Should I uninstall the higher version ? |
@Excelaint You should be able to update without uninstalling the previous version but, for the sake of identifying what versions you do have installed, can you identify what you have installed. |
Continued.. Capturing what you have installed for SSMS: Launching the ODBC Data Sources UI: Checking for version installed: |
Thanks Mike, Here's what I've got. |
@Excelaint Thank you for the additional details. We are investigating this and will update you with our findings. |
@Excelaint Additionally, you could uninstall followed by installing ODBC Driver 13 for SQL and note the actual build number. This will hopefully allow you to proceed. |
@CHEEKATLAPRADEEP Can you step through this tutorial and see if you can reproduce this issue. |
@Excelaint I'm able to create Azure SQL Database using SSMS 18.0 and 17.9.1 versions without any issue. As suggested by @Mike-Ubezzi-MSFT, have you tried to uninstall followed by installing ODBC Driver? |
@Excelaint We will now proceed to close this thread. If there are further questions regarding this matter, please comment and we will gladly continue the discussion. |
SQL_COPT_SS_CEKCACHETTL
andSQL_COPT_SS_TRUSTEDCMKPATHS
connection attributes