SAP Knowledge Base Article - Public

1218023 - Err Msg: "Data source name not found and no default driver specified"

Symptom

A Microsoft Visual Studio .NET application uses Crystal Reports 10 for Visual Studio .NET (CR 10 for VS .NET) as the reporting development tool.

The report connects through ODBC without using a data source name (DSN). When the connection properties are changed through code the following error message appears:

"An unhandled exception of type 'Systam.Runtime.InteropServices.COMException' occurred in crystaldecisions.crystalreports.engine.dll

Details: Data source name not found and no default driver specified."

Why does this error message appear?

Resolution

This error message appears because you cannot change the connection properties of a report with a DSN-less ODBC connection through code. This is by design.

More Information

---------------------

For more information on creating a report with a DSN-less ODBC connection, search for the related knowledge base article c2014473 on our support site at:

http://support.businessobjects.com/search

Keywords

DSN-LESS DSNLESS DSN LESS RDC .NET DOTNET DOT NET CONNECTION PROPERTIES CODE Crystal Reports DSN-less connection Error Message , c2016574 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports 10.0 ; SAP Crystal Reports, developer version for Microsoft Visual Studio ; SAP Crystal Reports, version for Visual Studio .NET 2005 ; SAP Crystal Reports, version for Visual Studio .NET 2008