Improve company productivity with a Business Account.Sign Up

x
?
Solved

Error '20527'

Posted on 1998-11-15
7
Medium Priority
?
1,542 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
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

 
LVL 2

Expert Comment

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

Accepted Solution

by:
tchalkov earned 40 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

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

608 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