• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 289
  • Last Modified:

Cannot open SQL server in VB

This is extremely strange.
I have CR8.0  VB 6.0
I have a report in crystal report which I access through VB.
For some reason it keeps getting corrupted.
Each time I step through the code, when I hit preview on the report I get 'Cannot open SQL server.' Server.
So what I do is bring up the .rpt file from the back up area double click it and connect to oracle and I verify database.
It says the database is structure is changed  do you want to update? I click on Yes/OK button and it updates the report.
I am able to see the data. Then I close the report.
Now I run the VB program and again I get the same error.
If go back double click on the .rpt file the file is ok ie I am able to view the data.  Only through VB I get this error.
I am not sure If I explained corrrectly.
It will be a great help if any one you experts have ever encountered this type of problem.
1 Solution
What edition of CR8 Standard, Pro, or Developer?
  You need developer to call the reports from an application

Is this on the development machine with CR installed or another machne?

If another machine, how did you install the application?

What code are you using?

Have you checked the report file being used?

ALad2005Author Commented:
I found it.  The view had changed in Oracle and I wasn't looking at the right report.

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now