Home > Crystal Reports > Crystal Reports Database Connector Error 42s02

Crystal Reports Database Connector Error 42s02

These dropdowns make up the parameters that are then passed back to the report via session variables. Hewlett Packard View All Topics View All Members View All Companies Toolbox for IT Topics Business Intelligence Groups Ask a New Question Business Objects Crystal For discussion on Business Objects Crystal Crystal Reports Database Connector Error 42s02 Error Codes are caused in one way or another by misconfigured system files in your windows operating system. I would like to open this question again or please advice on how to continue. his comment is here

Then at some point the Set Datasource Location command was used to point to the current Excel file. You can try ODBC drivers of Advantage Database by Sybex, which is an inofficial VFP9 ODBC driver set or you can use Microsofts OLEDB Provider for VFP9 to access this DBF. Join Now For immediate help use Live now! These logged on successfully.However, when a report's data source is changed from the TEST db to the LIVE db, a 'database connector error: '42S02: [Microsoft][ODBC SQL Server Driver][SQL Server][Invalid Object Name https://archive.sap.com/discussions/thread/1528450

DBFs of newer foxpro versions can be downward compatible if no newer feature eg filetype is used, but most probably that is the case here. More Business Intelligence Groups Your account is ready. But there is the tables in the database. Instructions To Fix (Crystal Reports Database Connector Error 42s02) error you need to follow the steps below: Step 1: Download (Crystal Reports Database Connector Error 42s02) Repair Tool

I setup an ODBC connection to both SQL servers on the user's PC (Windows XP SP3) using Admin. What is the source database - DB2/Oracle/SQL Server? First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. in Crystal Reports XI Developer Solved Database Connection Error: '42S02...

All rights reserved. I decided to check the stored procedure to make sure it was working correctly. To unlock all features and tools, a purchase is required. http://www.tek-tips.com/viewthread.cfm?qid=1638697 Join and Comment By clicking you are agreeing to Experts Exchange's Terms of Use.

Some components may not be visible. Take yourself to another level. The curious thing is that the report was not changed only Set Database Location. 0 LVL 100 Overall: Level 100 Crystal Reports 94 DB Reporting Tools 31 Databases 13 Message If yes then tell us what is in the first byte.

Does the report have a subreport? Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. 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... Crystal Reports XI Developer Bob Amiral asked Oct 14, 2009 | Replies (2) I get the above error within CR XI Developer when I try to connect an ODBC link to

If you're using the VFP ODBC driver, the latest one does only support up to VFP6 DBFs. this content Sometimes when you do this the name of the current location isn't updated, even though the report is using the correct data source. Connect with top rated Experts 15 Experts available now in Live! Join & Write a Comment Already a member?

The full messsage is: Database Connection Error: '42S02:MicrosoftODBC Visual FoxPro Driver Not a table. This corrupted system file will lead to the missing and wrongly linked information and files needed for the proper working of the application. Login. weblink DBFs Go to Solution 2 +1 4 Participants Olaf Doschke(2 comments) LVL 29 FoxPro23 Databases7 Crystal Reports1 mlmcc LVL 100 Crystal Reports94 Databases13 FoxPro3 pcelba LVL 41 FoxPro30 Databases18 Crystal Reports1

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | JAVASCRIPT FORUM © 2004-2016 Brian Bischof. Close Reply To This Thread Posting in the Tek-Tips forums is a member-only feature. search in your database doc the error linked with it_________________Bernard TIMBAL DUCLAUX de MARTIN BusinessObjects Platform Certified Consultant Image link (Co)author of 2 books about SAP BusinessObjects XI3.x and BI4.x Administration

Privacy Policy Site Map Support Terms of Use MenuExperts Exchange Browse BackBrowse Topics Open Questions Open Projects Solutions Members Articles Videos Courses Contribute Products BackProducts Gigs Live Courses Vendor Services Groups

This article contains information that shows you how to fix Crystal Reports Database Connector Error 42s02 both (manually) and (automatically) , In addition, this article will help you troubleshoot some common Alun Davies replied Oct 15, 2009 Bob, I would go with Christopher Reed's post however it may also be worth checking the ODBC with someting like Excel to check it works www.decisionfirst.com IP Logged Hviezdoslav Newbie Joined: 19 Jul 2010 Location: United States Online Status: Offline Posts: 9 Posted: 18 Feb 2011 at 5:19am Thank you, Dell! SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.

I open up SQL Query Analyzer and run the called stored procedure, pass the required parameters, and it works fine, bringing back a recordset. Decided to check the ID/PW of the calling ASP - (again, this should not matter, as I did not change anything on either the report or asp). Could someone advise why this would resolve the problem? check over here www.decisionfirst.com IP Logged Hviezdoslav Newbie Joined: 19 Jul 2010 Location: United States Online Status: Offline Posts: 9 Posted: 18 Feb 2011 at 3:20am Greetings Dell, I thank you very

Quote: Please Help...It is an urgentpleas... HviezdoslavEdited by Hviezdoslav - 17 Feb 2011 at 7:18am IP Logged hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3507 Posted: 17 Feb 2011 at 9:14am Instead Already a member? Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We

Registration on or use of this site constitutes acceptance of our Privacy Policy. In the sub report, in Database Expert, I linked the XLS file to the SQL Server table using Left Outer Join, Not Enforced, and the = or EQUAL for the Link Join this group Popular White Paper On This Topic Best Practices for a BI and Analytics Strategy 2Replies Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't in Crystal Reports XI Developer Posted on 2009-10-14 Crystal Reports FoxPro Databases 5 1 solution 1,285 Views Last Modified: 2012-05-08 I get the above error within CR XI Developer when I

How does it work?