469,609 Members | 1,166 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,609 developers. It's quick & easy.

Unexpected Database Login form - Crystal Report based on DataSet

I'm getting an unwanted database login form appearing when I set the Data Source of a Crystal report to a .Net dataset

e.g. myReport.SetDataSource(myDataSet

This only occurs on some PCs, works perfectly fine on all my PCs (Windows 2000, XP Pro), and work OK on my clients XP Home machines

Problem only occurs on my clients XP Pro machines, these are out of the box Dell machines with XP Preloaded

Can't understand why only these PCs appear to be affected
I've built a Setup project and used this to install application consistently on all PCs
I've even built a simple report that lists just lists "title" from the "titles" table in the "pubs" database. This throws up the Database Login form on these PCs

Here is my code, the message boxes confirm that the dataset is filled and that there is only the one table in the datase

sqlDataAdapter1.Fill(dsPubs1,"titles")
MessageBox.Show(dsPubs1.Tables.Count.ToString())
MessageBox.Show(dsPubs1.titles.Rows.Count.ToString ())
rptReportTest rpt = new rptReportTest()
rpt.SetDataSource(dsPubs1)
crv.ReportSource = rpt

I think this may be a security issue of some sort (but I'm open to other ideas)
Are datasets held in memory or paged to disk
If they are paged to disk could it be that Crystal does not have access to the location of the dataset

Please Help Thank

I'm david.risby and I'm at dsl.pipex.co
Jul 21 '05 #1
1 2154
Post your question at the Crystal Report Forum. You should get your question
answered from there.

"david risby" <an*******@discussions.microsoft.com> wrote in message
news:5E**********************************@microsof t.com...
I'm getting an unwanted database login form appearing when I set the Data Source of a Crystal report to a .Net dataset.
e.g. myReport.SetDataSource(myDataSet)

This only occurs on some PCs, works perfectly fine on all my PCs (Windows 2000, XP Pro), and work OK on my clients XP Home machines.
Problem only occurs on my clients XP Pro machines, these are out of the box Dell machines with XP Preloaded.
Can't understand why only these PCs appear to be affected.
I've built a Setup project and used this to install application consistently on all PCs. I've even built a simple report that lists just lists "title" from the "titles" table in the "pubs" database. This throws up the Database Login
form on these PCs.
Here is my code, the message boxes confirm that the dataset is filled and that there is only the one table in the dataset
sqlDataAdapter1.Fill(dsPubs1,"titles");
MessageBox.Show(dsPubs1.Tables.Count.ToString());
MessageBox.Show(dsPubs1.titles.Rows.Count.ToString ());
rptReportTest rpt = new rptReportTest();
rpt.SetDataSource(dsPubs1);
crv.ReportSource = rpt;

I think this may be a security issue of some sort (but I'm open to other ideas). Are datasets held in memory or paged to disk?
If they are paged to disk could it be that Crystal does not have access to the location of the dataset?
Please Help Thanks

I'm david.risby and I'm at dsl.pipex.com

Jul 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Brenny | last post: by
3 posts views Thread by Téo | last post: by
2 posts views Thread by Chris Ashley | last post: by
12 posts views Thread by Murali via DotNetMonster.com | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.