Unexpected Database Login form - Crystal Report based on DataSet

[david risby]

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

[BuddyHome]

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