Solved

Error '20527'

Posted on 1998-11-15
7
1,528 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
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 
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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

914 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now