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

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



More information about the AccessD mailing list