"Provider cannot be found. Ensure that the provider has been installed properly" when double-click on UDL file on 64-bit operating system

Technote (troubleshooting)


Problem(Abstract)

Administrator is troubleshooting a connection problem by double-clicking on the UDL file stored inside the data folder. An error message appears.

Symptom

Microsoft Data Link

Provider cannot be found. Ensure that the provider has been installed properly.
[OK]

Cause

When double-clicking on a UDL file, Windows opens the "Microsoft Data Access - OLE DB Core Services" ('Data Link Properties') utility.

  • On a 64-bit operating system it will open the 64-bit version of "OLE DB Core Services"
  • However, Controller is a 32-bit application and therefore it creates/uses 32-bit database connectors. These are not visible to 64-bit programs.

Environment

Controller application server based on 64 bit operating system (for example Windows 2008 R2).

Resolving the problem

Open the UDL file inside the 32-bit version of the "OLE DB Core Services" ('Data Link Properties') utility.

Steps:

Method #1

  1. Click "Start - Run"
  2. Type a command similar to the following:
C:\Windows\syswow64\rundll32.exe "C:\Program Files (x86)\Common Files\System\Ole DB\oledb32.dll",OpenDSLFile C:\Program Files (x86)\cognos\c8\data\oracletest.udl

TIP: Modify the file name/path (in the final part of this command) to point to your UDL file.

Method #2

  1. Click "Start - Run"
  2. Type a command similar to the following:
c:\windows\syswow64\cmd.exe C:\Program Files (x86)\cognos\c8\data\oracletest.udl

TIP: Modify the file name/path (in the final part of this command) to point to your UDL file.

Related information

1470517 - Cannot create new Controller Database Connect
THIRD PARTY - How to run 32-bit UDL file on a 64-bit Op
THIRD PARTY - Creating and Editing .udl files in 64-bit

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Cognos Controller
Controller

Software version:

8.5.1, 10.1

Operating system(s):

Windows

Reference #:

1503768

Modified date:

2011-06-24

Translate my page

Machine Translation

Content navigation