Step 4: Update Your PC Device Drivers 42S02 errors can be related to corrupt or outdated device drivers. That is: Old DB = WORKS (which doesn't exist in the new SQL server) New DB = WORKING Now we get this error: Failed to retrieve --------------------------- Crystal Reports --------------------------- Database Join & Ask a Question Need Help in Real-Time? Here's Why Members Love Tek-Tips Forums: Talk To Other Members Notification Of Responses To Questions Favorite Forums One Click Access Keyword Search Of All Posts, And More... Check This Out
Get 1:1 Help Now Advertise Here Enjoyed your answer? First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. Click the Uninstall button on the top menu ribbon. Runtime Errors Knowledgebase Article ID: 122855 Article Author: Jay Geater Last Updated: 21-07-2016 Popularity: star rating here Download NowError Fix Learn More Tweet Recommendation: Scan your PC for computer errors. https://archive.sap.com/discussions/thread/1528450
RE: Database Connector Error: ‘42S02:[Microsoft][ODBC SQL Server Driver][S Hviezdoslav (TechnicalUser) (OP) 21 Feb 11 12:17 Hello,I have figured out how to do what I wanted.In the main report, I have what Login with LinkedIN Or Log In Locally Email Password Remember Me Forgot Password?Register ENGINEERING.com Eng-Tips Forums Tek-Tips Forums Search Posts Find A Forum Thread Number Find An Expert Resources Jobs mlmcc 0 Featured Post What Should I Do With This Threat Intelligence? To run System File Checker (Windows XP, Vista, 7, 8, and 10): Click the Start button.
Join our community for more solutions or to ask questions. What is the source database - DB2/Oracle/SQL Server? Keeping track of when and where your 42S02 error occurs is a critical piece of information in troubleshooting the problem. Reinstalling Windows will erase everything from your hard drive, allowing you to start again with a fresh system.
Connect with top rated Experts 15 Experts available now in Live! Click Control Panel on the right side menu. After you have successfully uninstalled your Error 42S02-associated program (eg. http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=12358 Some components may not be visible.
Login. Therefore you're on the good side with OLEDB, that's only not supporting clipper DBFs and such, but all foxpro or foxbase and of course visual foxpro DBFs including all IDX and Does anybody know by chance how I can resolve this?I would be very grateful. Check the boxes of the categories you want to clean and click OK.
Click on the Crystal Reports-associated entry. http://www.solvusoft.com/en/errors/runtime-errors/sap-se/crystal-reports/42s02-crystal-reports-error-42s02/ Furthermore, there's a possibility that the 42S02 error you are experiencing is related to a component of the malicious program itself. Yes, what you said worked. Furthermore, a clean install of Windows will also quickly clean out any and all "junk" that has accumulated over the normal usage of your computer.
You may have to do the update for each table. his comment is here This step is your final option in trying to resolve your Error 42S02 issue. Follow the on-screen commands. Step 1: Repair Registry Entries Associated with Error 42S02 Manually editing the Windows registry to remove invalid Error 42S02 keys is not recommended unless you are PC service professional.
Locate Crystal Reports Error 42S02-associated program (eg. Using a registry cleaner automates the process of finding invalid registry entries, missing file references (like the one causing your 42S02 error), and broken links within the registry. I decided to check the stored procedure to make sure it was working correctly. http://digitalezines.com/crystal-report/crystal-report-dll-win-xp.html Covered by US Patent.
Could someone advise why this would resolve the problem? Login. The report does not have subreport?
Bye, Olaf. 0 LVL 41 Overall: Level 41 FoxPro 30 Databases 18 Crystal Reports 1 Message Active 1 day ago Expert Comment by:pcelba2009-10-15 Comment Utility Permalink(# a25579528) Are you able Any additional information on this point would be appreciated. 0 LVL 29 Overall: Level 29 FoxPro 23 Databases 7 Crystal Reports 1 Message Expert Comment by:Olaf Doschke2009-10-18 Comment Utility Permalink(# I open up SQL Query Analyzer and run the called stored procedure, pass the required parameters, and it works fine, bringing back a recordset. DriverDoc updates all of your PC device drivers, not just those associated with your 42S02 error.
These troubleshooting steps get progressively more difficult and time consuming, so we strongly recommend attempting them in ascending order to avoid unnecessary time and effort. If updates are available, click the Install Updates button. Back to top Nick DanielsForum AficionadoJoined: 15 Aug 2002Posts: 13291Location: England Posted: Tue Jul 05, 2005 9:47 amPost subject: Re: Invalid Object name......state: 42S02 Welcome to BB! navigate here mlmcc Go to Solution 6 3 +1 4 Participants rayluvs(6 comments) mlmcc(3 comments) LVL 100 Crystal Reports94 DB Reporting Tools31 Databases13 Guy Hengel [angelIII / a3] LVL 142 Databases41 DB Reporting
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Business Objects: Crystal The Disk Cleanup dialog box will appear with series of checkboxes you can select. I am very grateful to you, Dell. Click Control Panel.
Join Now For immediate help use Live now! Does the report have a subreport?