1210392 - How to use Crystal Reports with OLE DB Microsoft Data Link (UDL) Files

SAP Knowledge Base Article - Public

1210392 - How to use Crystal Reports with OLE DB Microsoft Data Link (UDL) Files

Symptom

How do I use Crystal Reports with OLE DB Microsoft Data Link (UDL) Files?

Cause

Microsoft Data Link (or UDL) Files are comparable to File DSNs in ODBC. The UDL files store connection information to be used by the OLE DB layer. They are available with OLE DB 2.0, which is installed by MDAC 2.x. Crystal Reports has been able to use UDL files since Crystal Reports 8.

Resolution

To create a UDL file

  1. Right-click on the Windows desktop.
  2. Click New > Text Document from the menu. A new text file appears on the desktop.
  3. Rename the file's extension from ".txt" to ."udl". This causes it to become a Data Link file.
    It is a good idea to rename the file to something relevant to its use, such as "MySQLServer.udl" or similar.
  4. Right-click the file > click Properties to configure the connection.
  5. Click the appropriate OLE DB provider in the Provider tab before entering information in the Connection tab.

The template for the Connection tab changes based on the OLE DB provider used. Enter any connection information relevant to this provider, such as logon credentials.

See also: Microsoft KB 189680 - How To Use Data Link Files with ADO

Keywords

MICROSOFT DATA LINK FILES UDL FILES OLE DB MDAC Crystal Reports Connectivity_OLEDB General Issues Connection Strings for Provider , c2004153 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports XI ; SAP Crystal Reports XI R2 ; 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 ; SAP Crystal Reports, version for Visual Studio .NET 9.1