Randall R Anthony
RRANTHON at sentara.com
Wed Sep 7 09:18:54 CDT 2005
Jim, Your first paragraph has been verified. However, it's the second I'm having problems with. I've changed the datasource with a different login to the report, yet I still get the error 'login failed for "bob"'... It's like I'm overlooking a switch or something. I'm assuming if I see the references in the list, they're registered? I've got CR 9 ActiveX Designer and Runtime Lib, CR 9 ActiveX Designer Runtime Lib and CR Report Viewer Control 9. >>> accessd at shaw.ca 09/07/05 9:40 AM >>> Hi Randall: Have you tested the SQL server separately to see if you can login using user name Bob... I am assuming you are not using not using Windows authentications. If that works, test to see that Crystal Report components are working and installed on the customer's computer and registered in your application. HTH Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Randall R Anthony Sent: Wednesday, September 07, 2005 6:12 AM To: accessd at databaseadvisors.com Subject: [AccessD] OT: Crystal Reports 9 and VB6 Problem with SQL Login 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. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com