Solved

Error '20527'

Posted on 1998-11-15
7
1,531 Views
Last Modified: 2012-06-21
Hi all,
    I'm having this problem.  When I print from my VB application to Crystal Reports, I get this error message..

"SQL Server Error '20527'"

    Any idea as to what's causing this?  Thanks!

    Puay Aun
0
Comment
Question by:palim
7 Comments
 
LVL 2

Expert Comment

by:aliciaam
ID: 1091312
No such an error on SQL Server
0
 

Author Comment

by:palim
ID: 1091313
Sheesh!  Why does it say SQL Server Error then????
0
 
LVL 2

Expert Comment

by:aliciaam
ID: 1091314
If you are more explicit on what you want to do. We may be able to help. But, such an error number DOES NOT exist on SQL. You are trying to print, but what else?
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
LVL 2

Expert Comment

by:aliciaam
ID: 1091315
Is that SQL 6.5?
0
 
LVL 7

Accepted Solution

by:
tchalkov earned 10 total points
ID: 1091316
this is not an error code from sql server but from crystal reports. it means that there is a problem connecting with sql server - check the odbc settings of the datasource you use(i.e. login name,password,sqlserver name ...). It is possible that you developed the report on one computer and tryied to use it on another where the required odbc data source is not defined.
0
 

Author Comment

by:palim
ID: 1091317
got it.. thanks
0
 

Expert Comment

by:treasuryit
ID: 24451269
what solved the issue? correcting the odbc?
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question