Data Connectivity
 Crystal Reports Forum : Crystal Reports .NET 2003 : Data Connectivity
Message Icon Topic: ODBC Query Post Reply Post New Topic
Author Message
jain_rohit7
Newbie
Newbie


Joined: 09 Oct 2007
Location: India
Online Status: Offline
Posts: 2
Quote jain_rohit7 Replybullet Topic: ODBC Query
    Posted: 10 Oct 2007 at 5:42am

Hi,

 

We have an urgent issue related to Crystal Report in our application. We want to use ODBC connection for connecting to the SQL server instead of currently used OLEDB connection, to make the connection dynamic. We have created the DSN for the server connection and also mapped the report to the created DSN.

 

When we run the report in the crystal report environment, it runs fine. But when we try to run the same through our VB.NET application, it asks for the User Id and Password for SQL Server authentication which is already provided in the DNS. And, even after entering the required details, we are unable to get the report displayed and the control is redirected to the same page.

 

Any inputs for the above issue will be highly appreciated
IP IP Logged
wattsjr
Groupie
Groupie
Avatar

Joined: 25 Jun 2007
Location: United States
Online Status: Offline
Posts: 51
Quote wattsjr Replybullet Posted: 15 Oct 2007 at 11:55am
Hi jain_rohit_7,
 
Your problem looks similar to one that I had.  When running a report through VB.NET you have to login to each table used in the report.  This may explain why you keep seeing thee ODBC Login screen. 
 
Logging into the tables is done through a "For each" looping process using the ReportDocument oibject to retrieve the tables in the report and log into them. 
 
Brian shows you how to do this in his book "CRYSTAL REPORTS .NET Programming" in Chapter 17 - pages 357-360.
 
I hope that this helps,
-jrw
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.016 seconds.