VB6, Crystal Reports 8, with SQL Server 2005

  • I am working on an application that is developed in Visual Basic 6, and is using Seagate Crystal Reports 8 for reporting. The client wants the Database to be SQL Server 2005, however we have had some issues with our application and had to install SQLServer 2000 for the reports to work.

    The issue was the "Physical Database was not found", and installing SQL 2000 fixed this problem.

    Given that the client only wishes to use SQL2005, is there any way we can get these to work in conjunction without a code-base rewrite?

    Thanks!

  • I know of no reason that they should not work.

    Was your error message from Crystal Reports or VB6? Can post the code that caused the error?

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

  • I am working on getting that information now.

    thanks!

  • okey-dokey.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

  • After several different research methods, I found that it was a SINGLE DLL was missing. If you run into this type of problem, make sure that you have

    NTWDBLIB.dll in C:\Windows\System32

    its unable to be registered by regsvr32.exe

    It's description is as follows:

    Description: SQL Server Client Library

    Company: Microsoft Corporation

    File Version: 2000.80.194.0

    I'm thinking it is a DLL from SQLServer 2000.

    This works without any other part of SQL2000 installed.

    Thanks again for your help!

  • I think that that is the SQL native-Client library.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply