[AccessD] OT: Crystal Reports 9 and VB6 Problem with SQL Login

Crystal is buggy as a beehive and has its own ideas about a bunch of stuff, 
meaning it tends to not play nice a lot of the time.

It sounds like you're opening a report that has an embedded login that is 
overridden in the application so it runs fine in production but when you open 
it up to work on it in a dev environment the embedded login takes over. But 
that's just a guess. I've had this and all sorts of other hassles with Crystal.

Good luck using it, it's not the friendliest of help sites, but here is the 
Crystal KB. 

http://support.businessobjects.com/search/default.asp?ref=default.asp_shortcuts



> Hi Listers,
> Looking for assistance with login problem with SQL.  App works fine in
> production environment, however when I bring it into a development
> environment, the app fails.
> 
> At the line of code:
> 
> crptReport.ReadRecords, which is calling the Crystal Report I get the
> 'login failed for user "bob"' and a blank report.  However the stored
> procedures run perfectly fine with the user bob account up till invoking
> the CR.  Any clues or ideas where I can research this?
> 
> Thanks for the help.