Help !!! Crystal Reports 7

preeti

10-04-2001, 10:18 PM

I am having a problem using CR 7 and Access 2000. My CR is having a String parameter field, which I pass thru VB. But when I say CRControl.Action = 1 , it generates an error, "Cannot open SQL server". . SQL is not installed on My PC . The error seems to be of DSN may be. Can anyone please tell me how do I take care of it.!!!!

Strat

10-05-2001, 04:41 PM

CR seems to show that generic error message whenever it can't find the database. Try either verifying the database or re-setting the database location (I think they're under the Database menu in CR7).

rodfiuza

10-05-2001, 07:52 PM

If you have vb 6 i wolud suggest you to use data report instead of cr.Much better and easy to use...

if you want to hit the stars,shoot to the sky.

preeti

10-07-2001, 10:51 PM

Thanks !!
It was problem in finding database .
I connected using a DSN, and now it is working fine...!!!

Preeti