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

Crystal Reports Database Connector Error 42s02

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 I open up SQL Query Analyzer and run the called stored procedure, pass the required parameters, and it works fine, bringing back a recordset. Then use the Database: Set Datasource Location to point the subreport to the correct Excel file. What it is telling you is that there is NOT a table named: WORKS.dbo.POP10100 0 Message Active today Author Comment by:rayluvs2009-06-18 Comment Utility Permalink(# a24660089) Sorry for the delay...been out check my blog

Join & Write a Comment Already a member? All Rights Reserved. Get 1:1 Help Now Advertise Here Enjoyed your answer? 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 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 Covered by US Patent. I changed it to an SA id to give it full run of the database, again, same error.

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. Some components may not be visible. How to easily fix Crystal Reports Database Connector Error 42s02 error? 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

Is this due to OLE DB having improved software components compared to the older ODBC?Also, this problem does not occur on CR 9 - it does occur on CR XI and Join and Comment By clicking you are agreeing to Experts Exchange's Terms of Use. 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! In the sub rpt using Database Expert, I tried Left Outer Join, Enforced From, and !=, and again I get all of the acct numbers in the XLS file including accounts

The Business Objects Crystal group is no longer active. Oracle Database Databases How Joins Work Video by: Steve Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected 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_ 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.

Join & Write a Comment Already a member? https://www.experts-exchange.com/questions/24432051/Crystal-Report-Failed-to-retrieve-on-a-change-database.html Join our community for more solutions or to ask questions. Connect with top rated Experts 15 Experts available now in Live! The Crystal Reports Database Connector Error 42s02 error is the Hexadecimal format of the error caused.

Join Now For immediate help use Live now! http://ogdomains.com/crystal-reports/crystal-reports-database-connector-error-hy007.php I tried in sub rpt via Database Expert to link the XLS to the SQL Server tbl using Left Outer Join, Enforced Both, and !=, but the first account # in Then we may decide what is exact reason of the "Not a table" bug. An incomplete installation, an incomplete uninstall, improper deletion of applications or hardware.

Re[2]: crw32.exe error in Crystal Reports XI crystal reports White Papers & Webcasts IDC Analyst Connection: Server Refresh Cycles: The Costs of Extending Life Cycles Buy/Market/Sell/Service Smarter eBook Putting mobile first: 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. Equations, Back Color, Alternate Back Color. news DATABASE --> SHOW SQ SUERY mlmcc 0 Message Active today Author Comment by:rayluvs2009-06-18 Comment Utility Permalink(# a24663190) My programmer just finished informing me that he redid the entire report over

Some of the things introduced in later version NOT compatible with ODBC are: DBC events (open database, create table etc cause stored procs to run). What causes Crystal Reports Database Connector Error 42s02 error? Suggested Solutions Title # Comments Views Activity microsoft access question 8 41 43d compre toata in where clue oracle 4 32 15d Managing SQL log files, SQL Server 2014 6 36

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

All product names are trademarks of their respective companies. Or it maybe that the tables have switched schemas/have a different owner? Join and Comment By clicking you are agreeing to Experts Exchange's Terms of Use. The main report is easy and I can show the records that are both in the XLS file AND in the SQL Server table.

My main report links the two via the Database Expert with Inner Join, Not Enforced, and the = Link Type. I would like to open this question again or please advice on how to continue. which is valid for driver creation date 2004. 0 Message Author Closing Comment by:makingitbig2009-10-18 Comment Utility Permalink(# a31641429) I give this an 'A' because it solved my issue. http://ogdomains.com/crystal-reports/crystal-reports-database-connector-error-im006.php It can also be caused if your computer is recovered from a virus or adware/spyware attack or by an improper shutdown of the computer.

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 You may have to do the update for each table. 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... 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

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 report is being called by an ASP page that has several dropdowns in it. Join your peers on the Internet's largest technical computer professional community.It's easy to join and it's free. I setup an ODBC connection to both SQL servers on the user's PC (Windows XP SP3) using Admin.

SolutionsBrowse by Line of BusinessAsset ManagementOverviewEnvironment, Health, and SafetyAsset NetworkAsset Operations and MaintenanceCommerceOverviewSubscription Billing and Revenue ManagementMaster Data Management for CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning We had a problems with SQL server and restores the DB but to another name. This corrupted system file will lead to the missing and wrongly linked information and files needed for the proper working of the application. Does anybody know by chance how I can resolve this?I would be very grateful.