Top menu

‘Data source name not found and no default driver specified’ error when testing connection to SQL Server

DESCRIPTION

The connection test fails returning ‘Data source name not found and no default driver specified’ error when testing connection to SQL Server by pressing ‘Test connection' button either during the installation of DeviceLock Enterprise Server, or in DeviceLock Management Console -> DeviceLock Enterprise Server options.

COMMENTS

The error indicates that the ‘System Data Source’ connection type has been selected, and either no, or a non-existing name has been specified in ‘Data Source Name’ field.

RECOMMENDATIONS

1.  To define data sources, use the Data Sources (ODBC) applet from Control Panel -> Administrative Tools;
2. Refresh the ‘Data Source Name’ list by pressing the Refresh button to select  a data source from the drop list.