Print Page | Close Window

Failed to open connection

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15052
Printed Date: 22 Apr 2025 at 4:08am


Topic: Failed to open connection
Posted By: CoachGBT
Subject: Failed to open connection
Date Posted: 30 Nov 2011 at 4:39am
Good Day,
 
I need help with a connection problem. When attempting to run a report in BO Enterprise (Preview) or InfoView; I get error msg, "Failed to open the connection." The server I'm attempting to connect to is a SQL Server. Now, I can connect and run the report successfully through CR and I can connect successfully through MS Visual Studio to view table data, but it will not connect via BO Enterprise (Preview) or InfoView.
 
Suggestions are greatly appreciated.
 
Thanks,
CoachGBT


Replies:
Posted By: comatt1
Date Posted: 02 Dec 2011 at 5:01am
Had this issue when my ODBC was setup incorrectly

Posted By: CoachGBT
Date Posted: 02 Dec 2011 at 5:04am
What was your solution to resolve the problem?

Posted By: comatt1
Date Posted: 02 Dec 2011 at 5:33am
Had to mark within the ODBC connections to use ANSI quoted identifiers and Use Ansi Nulls, Paddings and Warnings.
 
Hoewver, the possibility exists that the BO server has incorrect settings, is this problem new?


Print Page | Close Window