database vendor code 4060

I am having trouble with one report out of many that I have written so far. I have a .Net app using the crystalreportviewer. I set the logoninfo (which I have verified a dozen times as correct) at runtime and I still get the following when trying to run the report against a sql server database:

Failed to Open the Connection
Details: [Database Vendor Code 4060]

 

Now, according to SQL Server, this is an authentication error. However, when I run this exact same .rpt file in the report designer, it comes up just fine.

I verified that the stored procedure I'm running up against is correct and that basically everything I can think of is correct...yet this one report gives that error.

Has anybody else encountered this and does anybody know if this is some sort of setting in the report or something



Answer this question

database vendor code 4060

  • dexxter

    I am also having this problem.

    I put together a .NET app that opens Crystal Reports in a simple viewer, and it works just fine on my PC, but I have a single report that fails to open when someone else runs it. Other reports open for them just fine. I use .NET version 7.1.3088 with Crystal XI & connect via ODBC to SQL Server 2000. The error message that pops up is:

    Crystal Report Windows Forms Viewer

    Failed to open the connection.

    Failed to open the connection.

    C:\DOCUME~1\username\LOCALS~1\Temp\{##@@##@@-##@@-...}.rpt

    Hopefully someone can pinpoint the problem soon!


  • rickm2005

    My problem wound up being a security issue after all. Basically, my user did not have execute permissions on the stored procedure that drove the report. I would triple-check that you have sql server security set up right.
  • database vendor code 4060