Results 1 to 5 of 5

Thread: Crystal Reports 9.2 and Stored Procedure Problems II

Threaded View

  1. #1

    Thread Starter
    Member
    Join Date
    Sep 2005
    Posts
    59

    Crystal Reports 9.2 and Stored Procedure Problems II

    I'm working with:
    VB6
    Crystal Reports 9.2.2.693
    SQL Server
    I connect via OLEDB
    I already have added Crystal Reports 9 ActiveX Designer RunTime Library and Crystal Reports Viewer 9 to References as well as Crystal Report Viewer 9 to Components.

    Ok, I have setup my report all from within the report. The database, the stored procedure, and the fields I'm going to display.

    I'm passing parameters via a stored procedure from VB6 to SQL

    One of the setups at the report is the initial values for the parameters at the stored procedure. Suppouse I choose '0' and '0'.

    When I call the report it display all ok but if I send anything different to these values like '0' and '1' it will throw me the following error:

    "
    Logon failed.
    Details: ADO Error Code: 0x80040e4d
    Source: Microsoft OLE DB Provider for SQL Server
    Description: Login failed for user 'sa'.
    SQL State: 42000
    Native Error: 18456
    "

    I've tried to authenticate in both ways: SQL Authentication and Windows Integrated. Same problem.

    Why could this be?

    Hope you can help me figure this out.

    Marcelo.
    Last edited by techuser; Feb 3rd, 2006 at 07:26 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width