Print Page | Close Window

Sybase connection problems 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=4800 Printed Date: 17 May 2024 at 1:24am Topic: Sybase connection problems Posted By: IanH Subject: Sybase connection problems Date Posted: 14 Nov 2008 at 12:55am Using Crystal Reports 2008, I have 2 Sybase (SQL Anywhere 9) databases connected to a single server, one is the original database used by my app, the other is a mirror that I want to run reports against. If I add a new user to both databases, I can connect to the mirror via an OLE DB connection without a problem. However, to prevent users from connecting to and running reports against the main database, I've changed the user so that they have a password in the mirror database, but not in the main database. The problem is, after making this change, when I try to connect to the mirror database I get an "Invalid user ID or password" error. I can connect to the mirror database as this user from other applications, it only seems to be Crystal Reports that has the problem.

Print Page | Close Window