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.!!!!
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).
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.
10-07-2001, 10:51 PM
It was problem in finding database .
I connected using a DSN, and now it is working fine...!!!