Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Failed to open the connection Post Reply Post New Topic
Author Message
crystal2012
Newbie
Newbie


Joined: 17 Apr 2012
Online Status: Offline
Posts: 36
Quote crystal2012 Replybullet Topic: Failed to open the connection
    Posted: 18 Jun 2012 at 9:27am
I got" Failed to open the connection" error message when adding a crystal report to BO environment.
 
Here is the steps I took before receiving the error message
 
1. Select a folder from public folder that I want to a crystal report ito be added
2. Select a crystal report which needs to be added and check box “Use description from report”, and then click “OK”
 
Does anyone know who to fix the problem? Thanks!
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 19 Jun 2012 at 3:30am
What type of connection are you using in the report?  If it's ODBC, is the same ODBC connection set up on the BO server? (MUST be 32-bit connection unless you're on the latest version of BO.)  Whether it's ODBC or not, is the database client software installed on the BO server? (Again, MUST be 32-bit unless you're on the latest version of BO.)
 
-Dell
IP IP Logged
Chid
Newbie
Newbie
Avatar

Joined: 19 Jun 2012
Location: India
Online Status: Offline
Posts: 3
Quote Chid Replybullet Posted: 19 Jun 2012 at 3:49am
Hi,
 
As in the above mentioned try using ODBC connection or else try OLAP connection any one should work. Please use appropriate credentials as required by the connection.
 
Regards,
Chid


Thanks and Regards,
Chid
IP IP Logged
crystal2012
Newbie
Newbie


Joined: 17 Apr 2012
Online Status: Offline
Posts: 36
Quote crystal2012 Replybullet Posted: 19 Jun 2012 at 7:33am
I use ODBC connection. Our BO is connected to database called "A", my crystal report is connected to a different database called "B". Is that possible to add a crystal report pointed to a different database than BO.  Thanks so much for your time and help!
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 19 Jun 2012 at 7:49am
You have to have an 32-bit ODBC connection to database B set up on your BO server so that the server can connect to B.  Reports in BO run on the BO Server so the server has to have the connections set up for the reports it's responsible for running.
 
-Dell
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.