JamesonJendreas
asked on
ODBC SQL Connection Error - Crystal Reports - Vendor Code 4060
Here goes:
I'm having issues currently with a specific database in Crystal Designer 11 (and on CSXI R2 - InfoView) where anytime a user attempts to run a report on our new database, we get a login error"SQLConnectAttr Failed.... Vendor code 4060". All security looks to be setup just fine - we have 4 other databases on the save server that work (each database is relatively the same, they are setup each for their own sister company)
Any Suggestions?
I'm having issues currently with a specific database in Crystal Designer 11 (and on CSXI R2 - InfoView) where anytime a user attempts to run a report on our new database, we get a login error"SQLConnectAttr Failed.... Vendor code 4060". All security looks to be setup just fine - we have 4 other databases on the save server that work (each database is relatively the same, they are setup each for their own sister company)
Any Suggestions?
What database are you using?
Does the report run against other databases?
How are you connecting to the database?
What code are you using to select the database?
Any better description than 4060?
mlmcc
Does the report run against other databases?
How are you connecting to the database?
What code are you using to select the database?
Any better description than 4060?
mlmcc
ASKER
OK - this is an MSSQL 2005 database. Users can run reports on any other database (we have 5 that are commonly used). We can setup the ODBC connection without issue, but we can't run the reports, unless we connect using the SA login (and we don't want to be passing that out).
Reports run with SA login?
Do users have permissions to the tables, views, stored procedures the reports use?
mlmcc
Do users have permissions to the tables, views, stored procedures the reports use?
mlmcc
ASKER
Each user has an account under "Users" under the database, and each user looks to have "owner" by default, although each user is username_sql
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Since it displays only the vendor code and not any additional information, I would request you to check with your vendor on this aspect.
If you have any additional errors, post it out so that it might help analyzing the problem..