Solved

Error '20527'

Posted on 1998-11-15
7
1,536 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

630 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