[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Crystal Report Embedded in aspx With Two ODBC Connections

Posted on 2013-10-24
4
Medium Priority
?
539 Views
Last Modified: 2013-10-28
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
Comment
Question by:Carla Romere
  • 2
  • 2
4 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 39599331
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
 

Author Comment

by:Carla Romere
ID: 39605580
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
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 39605588
The problem is the SDK doesn't support 2 data sources so there is no way to set the second source.

mlmcc
0
 

Author Comment

by:Carla Romere
ID: 39605706
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

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
There is a wide range of advantages associated with the use of ASP.NET. This is why this programming framework is used to create excellent enterprise-class websites, technologies, and web applications.
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses
Course of the Month10 days, 3 hours left to enroll

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question