Home > Crystal Reports > Crystal Reports Database Connector Error 42000

Crystal Reports Database Connector Error 42000

If you'd like some more details on the subreport idea, just holler. :-) James 0 Message Author Closing Comment by:cheyanne0402772008-11-23 Comment Utility Permalink(# a31517920) Thanks for verifying what I thought, Is there ferry service from Vietnam to Borneo? Contrary to what mlmcc said, in the SQL expression you Go to Solution 12 6 6 +1 4 Participants cheyanne040277(12 comments) mlmcc(6 comments) LVL 100 Crystal Reports94 Query Syntax8 Badotz(6 comments) So once i leave is it possible to do all extarctions using CR. http://comscity.net/crystal-reports/crystal-reports-database-connector-error-42s02.html

Sounds like a typical SQL syntax error. Limits to infinity of a factorial function Why do some stocks have a higher margin requirement? Make a "Ceeeeeeee" program Why are the memory addresses of string literals so different from others', on Linux? Whenever i drag and drop any tables into the report itself, it works fine. https://archive.sap.com/discussions/thread/3202022

None 0 Points 13 Posts Failed to retrieve data from the database. I can run my stored procedure without error in SQL Server. None 0 Points 13 Posts Re: Failed to retrieve data from the database.

Authoritative source that <> and != are identical in performance in SQL Server How to politely decline my salary due to feeling I don't currently deserve it? Error in compiling SQL Expression:Database Connector Error: '42000:[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'select'.[Database Vendor Code:156]'. I accept that is the solution. Using a blank report template I have prepared a report in crystal repot and everything has been fine.

All Rights Reserved. 418,854 Members | 815 Online Join Now login Ask Question Home Questions Articles Browse Topics Latest Top Members FAQ home > topics > microsoft sql server oracle stored-procedures oracle11g crystal-reports share|improve this question asked Nov 19 '14 at 14:19 rcfmonarch 9419 Can you call the stored procedure with static content form SQLPlus or SQLDeveloper? –mmmmmpie It was just a simply select * , to make sure at its working. https://bytes.com/topic/sql-server/answers/647080-extracting-data-sql-server-using-crystal-report If you need to do more with the counts, the subreport can save the count in a shared variable and you can then use that variable in the main report.

For the database connection I am using ODBC and I have configured that from the Administrative Tools -> Data Sources (ODBC) in Crystal Report Machine. 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 Come on over! I thought maybe you had a SQL syntax error.

kid in winter Authoritative source that <> and != are identical in performance in SQL Server Are electric bike speed limitations set in stone? why not find out more I dont know why i am getting this error Error in compiling SQL Expression Database Connector Error:'42000:[Microsoft][ODBC SQL Server Driver][SQL Server][Incorrect sybtax near the keyword 'select'.[Database Vendor Code:156]' May 18 '07 But i got this error. To report only some fields, you choose the database, and the table you want to report (click on the Datatabase Fields item in the Field Explorer panel to open a wizard

How worried should I be about getting hacked with PoisonTap? check over here Both inside SQL Developer and when the report is run through Crystal Reports. Get 1:1 Help Now Advertise Here Enjoyed your answer? Contrary to what mlmcc said, in the SQL expression you have to use the database's syntax, not CR's, so you were OK there.

Extracting data in SQL server using crystal report P: 16 sandyboy Hi All, I am new to sql server. 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 Join them; it only takes a minute: Sign up Attempting to connect to SQL Server through Crystal Reports up vote 0 down vote favorite I am attempting to connect Crystal reports his comment is here I select the server from the drop down list and put in the username and password for the local admin account.

The problem is that CR appears to be checking the SQL expression by itself, without putting it into the context of the main query on the report. IP Logged BrianBischof Admin Group Joined: 09 Nov 2006 Online Status: Offline Posts: 2460 Posted: 30 Aug 2007 at 4:53pm This is a pretty generic error message. Database Vendor Code: 8114 [Answered]RSS 4 replies Last post Sep 01, 2011 11:21 AM by elizabeth.knight ‹ Previous Thread|Next Thread › Print Share Twitter Facebook Email Shortcuts Active Threads Unanswered Threads

Why does the login id has a domain like prefix? –XtremeBytes Apr 24 '15 at 17:24 I am using windows authentication.

Infinite Fibonacci sums - diverge or converge What will you bring for Thanksgiving? But, this talks about the Native Error: 18456 (which is the exact error code you are getting). Megan Thomas July 04, 2012 at 05:18 AM 0 Likes 14 replies Share & Follow Privacy Terms of Use Legal Disclosure Copyright Trademark Sitemap Newsletter Active TopicsMemberlistSearchHelpRegisterLogin Data Connectivity Crystal Reports Is there oscillating charge in a hydrogen atom?

As a limit on our LMS, we're told that we must use ODBC connections instead of a direct Oracle Server connection, but, when I connect the Crystal Report to the Stored Here is the link to the article: Crystal Reports Generating SQL Server Error 18456 Severity 8 Error Logs share|improve this answer answered Apr 24 '15 at 20:45 FutbolFan 3,75421125 add a I don't understand what the syntax should be. weblink First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone.

but i got the same result. SELECT "DNAPROFILE"."CSF1PO", "DNAPROFILE"."TPOX", "DNAPROFILE"."THO1", "DNAPROFILE"."D16S539", "DNAPROFILE"."D7S820", "DNAPROFILE"."D13S317", "DNAPROFILE"."D21S11", "DNAPROFILE"."D8S1179", "EVIDENCE"."evid_num", "EVIDENCE"."origin", "DNAPROFILE"."D3S1358", "DNAPROFILE"."D2S1338", "DNAPROFILE"."D19S433", "DNAPROFILE"."vWA", "DNAPROFILE"."D18S51", "DNAPROFILE"."Amelogenin", "DNAPROFILE"."D5S818", "DNAPROFILE"."FGA", "REPTEXT"."req_id", (select distinct count(x.evid_id) from reptext x INNER JOIN evidence e ON Tell others by linking to it on your blog or website:Crystal Reports Forum IP Logged jjcyeshua Newbie Joined: 22 Mar 2007 Location: United States Online Status: Offline Posts: 30 I have done till here.

When I developed the reports, I used a direct Oracle server connection (server address, username/password, SID, port, etc.) and the report worked perfectly. CONTINUE READING Join & Write a Comment Already a member? Edited by BrianBischof - 30 Aug 2007 at 6:16pm Please support the forum! Is there any other way to do this?

Can my employer see what I do on the internet when I am connected to the company network? For ex, I have to pull all the details of customers whose age is greater than 20.How can i do this in CR. My problem is, now I get 41 records rather than 12, so there is something I'm missing: SELECT "DNAPROFILE"."CSF1PO", "DNAPROFILE"."TPOX", "DNAPROFILE"."THO1", "DNAPROFILE"."D16S539", "DNAPROFILE"."D7S820", "DNAPROFILE"."D13S317", "DNAPROFILE"."D21S11", "DNAPROFILE"."D8S1179", "EVIDENCE"."evid_num", "EVIDENCE"."origin", "DNAPROFILE"."D3S1358", "DNAPROFILE"."D2S1338", "DNAPROFILE"."D19S433", but the sql command that i wrote is working under sql server.

Based on the error message, this looks like the problem on your stored proc or your site code and this has nothing to do with crystal report error. Our new SQL Server Forums are live! So i connected to the database and inside SQL expressions Field i wrote the following query, SELECT name,address,age FROM t1 Is this correct. By joining you are opting in to receive e-mail.

Join the community of 500,000 technology professionals and ask your questions. the option of creating an sql expression disappear.. Magento E-Commerce Advertise Here 694 members asked questions and received personalized solutions in the past 7 days.