Crystal Reports8.5 error Cannot open SQL server

90 pts.
Tags:
Crystal Reports8.5 error
When you print using Windows10 Crystal Reports8.5, the "Cannot open SQL server" error message appears.
Asked: Last updated:
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Previously, it was working well in a Ms sql server 32bit environment on Windows7 32bit. “Cannot open SQL server” occurs in the Windows10 64bit Computer list.

Discuss This Question: 12  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    We need a few more details on your server and network connection. Has this worked in the past and now has stopped or is this a new connection being used for the first time ?

    135,525 pointsBadges:
    report
  • carlosdl
    You didn't even ask a question.

    As mentioned by Todd, you really need to provide more details.  Otherwise, it will be really difficult for anyone to help you.
    85,480 pointsBadges:
    report
  • Subhendu Sen
    Are you sure all of the configurations are perfect? Have you checked logon & authentication issue? Are you sure there is no missing if Windows installer cache files? You mentioned it was running successfully on Windows 7. However, please link here for Microsoft support, https://support.microsoft.com/en-in/help/2681562/using-sql-server-in-windows-8-and-later-versions-of-windows-operating
    141,290 pointsBadges:
    report
  • carlosdl
    Crystal Reports 8.5 is a very old product, and has probably been unsupported for more than a decade, so I wouldn't be surprised if it had compatibility problems with Windows 10.

    You didn't mention the SQL Server version you are using, but I would assume it is also an old version.

    You might be able to make them work by playing with compatibility settings, but first you need to identify which one of the involved applications is causing the problem.

    Can you connect to SQL Server from the Management Studio?
    85,480 pointsBadges:
    report
  • carlosdl
    And, by the way, please use the discussion section to answer our questions or provide more information, not the Answer Wiki.

    Thanks.
    85,480 pointsBadges:
    report
  • ToddN2000
    what version of SQL server, 2000 2005 2008 or something else ? I find a few versions have issues running under Win10..For some things I need to have multiple versions of SSMS on my Win10 machine.  Older version like SSMS 2008 will allow me to script a table to a new window where the newer SSMS 2017 fails. This makes it a pain when you need to change and recreate large tables. There may be some work around for you if you let us know what version you are on. 
    135,525 pointsBadges:
    report
  • lee5675

    Previously, it was working well in a Ms sql server2005 32bit environment on Windows7 32bit. "Cannot open SQL server" occurs in the Windows10 64bit Computer list.

    VB6.0 executes well and error "Cannot open SQL server" message occurs when printing Crystal Reports8.5

    90 pointsBadges:
    report
  • lee5675
    ERROR occurs on some computers using WINDOWS10.
    90 pointsBadges:
    report
  • carlosdl
    It's good to know the environment on which it was working correctly before, but you did not answer the question about what version of SQL Server is being used now, on Windows 10.

    Is it version 2005 too?

    You also didn't answer the question about being able to connect to the database from Management Studio.  If you can't try that, can you at least confirm that the application is able to print the reports from other computers running the same edition of Windows 10, and the same versions of the other pieces of software involved?

    And an additional question:  Did you have to create an ODBC data source on the client computers?  If so, what type of DSN did you create?

    Also, if you already tried to troubleshoot the problem, it would be good to know what you did, so we don't end up suggesting things you already tried.
    85,480 pointsBadges:
    report
  • lee5675
    While using Ms sql server2005 32bit with Windows10 64bit, some computers are experiencing an error.
    Install to vb6.0 setup.exe
    Some part of the 64 10 windows bit error in.
    90 pointsBadges:
    report
  • lee5675
    On some Windows10 64-bit computers
    That's what's happening.
    90 pointsBadges:
    report
  • carlosdl
    I'm sorry, I don't completely understand what you are saying, and I suppose you didn't understand my previous messages either, because you didn't answer most of my questions/doubts.

    I know the language can be a barrier sometimes.  Maybe you can have someone help you understand and respond to our questions.  That would be of great help.
    85,480 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: