Problem with ConnectionProperties

[korax]

Hey.
Sory for C#...

I have report created in CR 11 Pro:

In Database -> Set datadource location:

MyServer\sql_2005
   -> Properties
        Database Type: ODBC (RDO)
        Connection String: DRIVER={SQL Server};SERVER=MyServer\sql_2005;DATABASE=CRDataBase
        User ID: MyUser
        Database: CRDataBase
        SERVER: MyServer\sql_2005
        Use DSN Default Properties: False

and for each table like this:

   -> Magazyny
        -> Properties
            Table Name: Magazyny 
            Table Type: Tables
            Catalog: CRDataBase
            Owner: MyUser

Setting: Save data with Report = off

Ok. I try to use this file in crystal viewer control.

crReport = crApp.OpenReport(@"C:\Raport1.rpt", 1);

crReport.DiscardSavedData();

k_Viewer.ReportSource = crReport;
k_Viewer.ViewReport();

And the report run fine but when i change (in SQL Server Management Studio) the name of database from CRDataBase to XDataBase i have error:

System.Runtime.InteropServices.COMException (0x80047E48): Logon failed.
Details: 01S00:[Microsoft][ODBC SQL Server Driver]Invalid connection string attribute.

Logon failed couse database name has changed.

so a try to change connection string for each tables:
full code:

crReport = crApp.OpenReport(@"C:\Raport1.rpt", 1);

crReport.DiscardSavedData();

for (int i = 1; i < crReport.Database.Tables.Count; i++)
{
crReport.Database.Tables[i].ConnectionProperties.DeleteAll();
crReport.Database.Tables[i].ConnectionProperties.Add("Connection String", @"Driver=SQL Server;Server=" + _Server + ";Database=" + _DataBase + ";UID=MyUser;PWD=");
}

k_Viewer.ReportSource = crReport;
k_Viewer.ViewReport();

and the next error:

System.Runtime.InteropServices.COMException (0x80047E44): The table '' could not be found.

what the ... ??

ok.. i try to change database name to old "CRDataBase" and all run fine.
so a created new database with name "CRNew" withe the same structures as "CRDataBase".

report run fine but data was loaded from old database.

so i try to change location of all tables:
full code:

crReport = crApp.OpenReport(@"C:\Raport1.rpt", 1);

crReport.DiscardSavedData();

for (int i = 1; i < crReport.Database.Tables.Count; i++)
{
String oldLocation = crReport.Database.Tables[i].Location;

crReport.Database.Tables[i].ConnectionProperties.DeleteAll();
crReport.Database.Tables[i].ConnectionProperties.Add("Connection String", @"Driver=SQL Server;Server=" + _Server + ";Database=" + _DataBase + ";UID=MyUser;PWD=");

String newLocation = _DataBase + "." + "MyUser" + "." + oldLocation;
crReport.Database.Tables[i].Location = newLocation;

}

k_Viewer.ReportSource = crReport;
k_Viewer.ViewReport();

and data from new database was loaded...

ok.. at the and i delete the old database "CRDataBase" i **** the same error:

System.Runtime.InteropServices.COMException (0x80047E44): The table '' could not be found.

what the... ??

what is with this report ??
why after the changing connection string report do not work on other database??

what else i must do ?

2 fu*** day and nothing..

i must figure this today...

[Cristian]

Why you don't try with active data. You only set the setdatasource property to an valid recordset and it will works!!

[brucevde]

Its been a very very long time since I did any C coding and may not remember how the For loop works.

But aren't you missing the last table. Shouldn't it be looping from 1 to Count.

for (int i = 1; i <= crReport.Database.Tables.Count; i++)