Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Server & Application Monitor (SAM) > SAM - Knowledgebase Articles > Data source name not found and no default driver specified messages in SAM

Data source name not found and no default driver specified messages in SAM

Updated August 29, 2018

Overview

In SAM, you may receive a "Data source name not found and no default driver specified" error if a component monitor uses 64-bit polling to collect data from a 32-bit target server. Conversely, this message appears if using 32-bit polling for a 64-bit target server.

Environment

All SAM versions

Cause 

The OS version (32-bit or 64-bit) of the component monitor conflicts with the OS on the target server. For example, an AppInsight application configured for 32-bit polling cannot collect information from a 64-bit server.

Resolution

Change the platform type for polling either at the application or template level.

To change the polling platform type at the application level:

  1. In the Orion Web Console, click My Dashboards > Applications > SAM Summary.
  2. Select an AppInsight Application (Exchange, SQL, IIS) and then click Edit Application Monitor.
  3. Click Advanced to expand the section, and then click Override Template.
  4. In the "Platform to run polling job" field, change the value to match the target server(s).
  5. Click Submit.

To change to 64-bit polling at the template level:

  1. In the Orion Web Console, , click Settings > All Settings > SAM Settings > Manage Templates.
  2. Select an AppInsight application and click Edit to open the template.
  3. Expand Advanced and change the value in the "Platform to run polling job on" field. PollingOS.png
  4. Click Submit.

 

Last modified

Tags

Classifications

Public
/*]]>*/