ODBC Error Run-Time Error '-2147467259 (80004005)

Vinh Dang 1 Reputation point
2021-02-18T18:40:12.123+00:00

Hello,

I am hoping someone could provide me with some insight to as to what drive/install/dictate the following registry value.

69688-capture3.jpg

We have been having issue with a few users who were unable to open a custom excel spreadsheet an run a custom script. The following message typically pops up when they try to run the macro "Run-Time Error '-2147467259 (80004005): [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

69716-capture.jpg

The solution, was to import that SQL Server registry value from a working machine into workstation with this issue and it appear to have resolve the problem.

69756-capture1.jpg

Therefore, I hope someone could point me in the right direction as to what set those values? Is it out of the box windows installation? or by a different Microsoft product such as SQL.

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
10,938 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,067 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,669 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Castorix31 82,321 Reputation points
    2021-02-18T18:58:18.73+00:00

  2. Erland Sommarskog 103.5K Reputation points MVP
    2021-02-18T22:18:26.59+00:00

    The driver "SQL Server" comes with the OS, but this is a very old driver that lacks support for several features in modern versions of SQL Server

    You would be somewhat better off using SQL Server Native Client 11.0, which you also seem to have.

    Even better may be to download and install the ODBC 17 SQL Server driver, which is the most recent.