Crystal Reports from VB 6 1

[chindas]

Hi all,

I have a embedded Crystal Reports working fine in my VB6 app.

When I try to change the database name to 'database_test', then the report still is trying to connect to the initial database I used in the reports designer from VB.


CRREP.Database.Tables(1).ConnectionProperties.Item("initial catalog") = "database_test"


When I check the SQL query string asking from VB inmediate window after setting connection property, it shows every field preceeded with the database I used initially when I designed the report ie, "DATABASE"."DBO"."MY_TABLE" in place of "DATABASE_TEST"."DBO"."MY_TABLE"

How could I change the database prefix on every field from "database" to "database_test"?

Thanks all

 

[vidru]

Have a look at faq768-5374 for an option that uses the SetLogOnInfo method instead of ConnectionProperties.

SetLogOnInfo is deprecated, but still works up to CR XI.

-dave

 

[chindas]

Thanks vidru,

problem solved!!