Active TopicsMemberlistSearchHelpRegisterLogin

Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: V.NET/Access DB Connection issues Post Reply Post New Topic
Author Message
dogboy
Newbie
Newbie


Joined: 02 Feb 2011
Online Status: Offline
Posts: 1
Quote dogboy Replybullet Topic: V.NET/Access DB Connection issues
    Posted: 02 Feb 2011 at 12:42pm

Hi,

 

I have a VB.net application that is connected to an Access database. In the application I am running a Crystal Report that is connected to the same database. In order to be able to add a custom command, I had to connect to the database directly through the CR database expert since using the ADO connection provided by Visual Studio does not allow me to create custom commands.

Everything works just fine inside the Visual Studio 2010 environment, but once deployed on a test machine the report does not work anymore. Setting up the database connection through a ConnectionInfo does not work (CR keeps on asking for a user/pass and there is no pass to the database.

Can anyone tell if it is at all possible to add a custom command to an ADO.NET dataset? If not, what is the proper syntax to connect CR to an Acces database (by providing the Access file name)?

 

Cheers
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 03 Feb 2011 at 3:22am

you could query the database from your application, and then if you want you can append the data to your dataset...you can add the table that your custom query returns. 

My company uses wizards that we designed for gathering the parameters for our reports.  Once we have the parameters, we get the dataset as well. This way, only our app talks to the database and Crystal (or any other reporting tool) just processes the resulting dataset.
 
HTH
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.063 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.