Cannot open SQL server in VB

Posted on 2005-05-13
Last Modified: 2012-06-27
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.
Question by:ALad2005
    LVL 100

    Accepted 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?


    Author Comment

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now