cancel
Showing results for 
Search instead for 
Did you mean: 

Failed to open connection. xxx.rpt - OLE DB

0 Kudos
260

Hy,

after many hours searching, I figured out that report that uses OLE DB connection doesn't work in InfoView, neither CMC, with the error, "Failed to open the connection. xxx.rpt".

The error occurs on the server machine and on the client machine, but on the client machine I can view the report on the crystal reports designer.

The report is base in a business view, that connects through OLE DB for analysis service with MSQL2005 and through repository to the crystal reports desinger.

This only occurs in reports through OLE DB, because I developed other reports through ODBC and there's no error.

The report OLE DB doesn't have subreports.

Can anyone give me any suggestion to indentify this problem?

Crystal Reports Server 2008, 12.1.0

CR2008 12.3.0.601

Microsoft SQL Server 2005 SP2

Client/Server OS:Windows Xp and Windows Server 2003, all recent updates applied

Thank you

Accepted Solutions (1)

Accepted Solutions (1)

former_member59613
Contributor
0 Kudos

Hi Pedro,

I found 1 bug filed that sounds similar to what you are seeing. It's possible that this is a bug and you should investigate this with SAP BusinessObjects support. The ADAPT number that I found is: ADAPT01360053.

There currently is no fix for this issue but if you work with support, a work-around may be found. Is there a reason why you do not want to use ODBC?

Thanks

Jonathan

Answers (0)