Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 538
  • Last Modified:

Crystal Report Embedded in aspx With Two ODBC Connections

I have a Crystal Report developed by someone in house that references two different ODBC connections that are created using Clarion's TopSpeed ODBC connector to connect to *.tps flat files. I need to set this report up embedded in an aspx page OR I need to access the data directory from asp.net c# and rebuild the report in a gridview.

I can't connect to the odbc connectors no matter what I do. I've scoured the internet and not found too much help with this.

Has anyone done this before? Can you point me to a site that explains it?
0
Carla Romere
Asked:
Carla Romere
  • 2
  • 2
1 Solution
 
mlmccCommented:
What version of Crystal?

The versions I am familiar with only really support a single database connection.  Multiple may work in them but the SDK only supports 1 connection so there is no way to pass 2 connections to the report.

The recommended solution has always been use a subreport for one of the connections.

The newest versions may support it but then you will need to be using the versioin that is built for Visual Studio.

mlmcc
0
 
Carla RomereDirector of Information TechnologyAuthor Commented:
I'm using the one for VS 2010 - if I run it purely from Crystal Reports, the report runs fine. When I embed it in an aspx page is when it blows up.
0
 
mlmccCommented:
The problem is the SDK doesn't support 2 data sources so there is no way to set the second source.

mlmcc
0
 
Carla RomereDirector of Information TechnologyAuthor Commented:
Okay, maybe I'll see if I can ditch the Crystal Report and attempt to connect to multiple ODBC connections directly from asp.net. Thanks for your help, mlmcc, - always on the ball!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now