Print Page | Close Window

ADO Error on OLE

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17473
Printed Date: 16 May 2024 at 3:19pm


Topic: ADO Error on OLE
Posted By: sharona
Subject: ADO Error on OLE
Date Posted: 31 Aug 2012 at 5:15am
I have a report in which uses integrated security accounts to log in.
I created the account in sql with windows authentication.
The report uses and OLE DB ADO to connect.
I have one user who can run the report
I have another user who can not run the report using the same login.
It seems to be hanging on to the users actual login and not using the integrated security.
He receives this error
ADO ERROR
OLE DB
USER(XXXXXXX)
SQL 412000
VENDOR CODE 18456

any ideas what would cause this and how to fix it?



-------------
sharona



Print Page | Close Window