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

Crystal Reports Database Connector Error 42s02

I cannot figure out how to use a Crystal Report to show the records in the Excel file that are NOT in the SQL Server table for the sub report. 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 There are two (2) ways to fix Crystal Reports Database Connector Error 42s02 Error: Advanced Computer User Solution (manual update): 1) Start your computer and log on as an administrator. This website should be used for informational purposes only. Check This Out

I am trying for the sub rpt to enter into Add Command the following to link the XLS file and the SQL Server table with the following code:Select Sheet1_.Account_No From Sheet1_ 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 Maybe the mysterious "42S02" code error is a database error code. 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... https://archive.sap.com/discussions/thread/1528450

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 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 Thanks, Hviezdoslav IP Logged hilfy Admin Group Joined: 20 Nov 2006 Online Status: Offline Posts: 3507 Posted: 18 Feb 2011 at 4:36am Don't use Then at some point the Set Datasource Location command was used to point to the current Excel file.

Join and Comment By clicking you are agreeing to Experts Exchange's Terms of Use. What causes Crystal Reports Database Connector Error 42s02 error? mlmcc 0 LVL 29 Overall: Level 29 FoxPro 23 Databases 7 Crystal Reports 1 Message Accepted Solution by:Olaf Doschke2009-10-15 Olaf Doschke earned 500 total points Comment Utility Permalink(# a25578755) The The OLEDB Provider supports all VFP DBFs, all that ODBC supports and more.

Any suggestions??? ‹ Previous Thread|Next Thread › This site is managed for Microsoft by Neudesic, LLC. | © 2016 Microsoft. Thanx 0 Message Active today Author Comment by:rayluvs2009-06-18 Comment Utility Permalink(# a24662547) Understood. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic… Concerto Cloud Services How Joins Work Video by: Steve Using examples as well as descriptions, step http://www.tek-tips.com/viewthread.cfm?qid=1638697 Actually, the better question is are you using the latest driver?

Yes, what you said worked. 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. What is the source database - DB2/Oracle/SQL Server? Join our community for more solutions or to ask questions.

I would like to open this question again or please advice on how to continue. https://www.experts-exchange.com/questions/24432051/Crystal-Report-Failed-to-retrieve-on-a-change-database.html What version of Designer?_________________My latest idea....and this one is a winner! I tried in sub rpt in Database Expert to link XLS to SQL Server table using Inner Join, Not Enforced, and != as the Link Type, but I still get in Cancel Red Flag SubmittedThank you for helping keep Tek-Tips Forums free from inappropriate posts.The Tek-Tips staff will check this out and take appropriate action.

DB Reporting Tools Introduction to Oracle APEX SQL Workshop- The object browser Article by: Swadhin APEX (Application Express) is used to develop a web application from Oracle. http://swirlvision.com/crystal-reports/crystal-reports-database-connector-error-hy007.html mlmcc 0 LVL 17 Overall: Level 17 Crystal Reports 17 DB Reporting Tools 7 Databases 2 Message Active 3 days ago Assisted Solution by:MIKE2009-05-24 MIKE earned 100 total points Comment There are queries involved, but again, they are pointing to tables, no database name is being specified No stored procedure/view being used. Back to top bernard timbalForum AddictJoined: 26 May 2003Posts: 3868Location: Paris - FRANCE Posted: Tue Jul 05, 2005 9:50 amPost subject: Re: Invalid Object name......state: 42S02 Yes, what rdbms are you

in Crystal Reports XI Developer Solved Database Connection Error: '42S02... Covered by US Patent. Tighten space to use less pages. http://swirlvision.com/crystal-reports/crystal-reports-database-connector-error-42000.html My main report links the two via the Database Expert with Inner Join, Not Enforced, and the = Link Type.

In the sub report, I had nothing in the Select Expert. To troubleshoot this problem, we created a very basic report based on a few fields from a single view that exists in both SQL db. How does it work?

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).

All rights reserved.Unauthorized reproduction or linking forbidden without expressed written permission. I setup an ODBC connection to both SQL servers on the user's PC (Windows XP SP3) using Admin. 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 An incomplete installation, an incomplete uninstall, improper deletion of applications or hardware.

The most probable reason is the one described by Olaf. Join & Ask a Question Need Help in Real-Time? Take yourself to another level. http://swirlvision.com/crystal-reports/crystal-reports-database-connector-error-hy010.html An "SQL Native Client" - Connection will be used.On Crystal Report XI it works fine, but with Crystal Reports 2008 an error occurs (same ODBC, stored procedure and DB):Error: 42S02 [SQL

Database Vender code: 123' This is a headache and any assistance in solving this problem would be greatly appreciated. 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 Details: 42000:[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1:Incorrect syntax near ''', [Database Vendor Code:170]So I tried the following in the Add Command under the SQL Server CRSS Database in the Database Expert Unknown replied Oct 15, 2009 Which FoxPro driver are you using?

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 want to show only the acct numbers in the XLS file that are not in the SQL Server table. 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 The report is being called by an ASP page that has several dropdowns in it.

When I try in Database Expert of sub rptto link XLS file to SQL Server tbl using Inner Join, Enforced To, and != for not equal Link Type, I get the All rights reserved. So I added the SQL Server table and field (Pt_User_Defined_Fields.Account) to the Select Expert. Note: The manual fix of Crystal Reports Database Connector Error 42s02error is Only recommended for advanced computer users.Download the automatic repair toolinstead.

Bye, Olaf. 0 Featured Post How to improve team productivity Promoted by Quip, Inc Quip adds documents, spreadsheets, and tasklists to your Slack experience - Elevate ideas to Quip docs - All rights reserved.