|
-
Feb 3rd, 2006, 07:18 AM
#1
Thread Starter
Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|