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

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