Home > Crystal Reports > Crystal Reports Database Connector Error 42000

Crystal Reports Database Connector Error 42000

Well I recently learned that this is not precisely true. I would suggest adding the ODBC Command like this: SELECT I.I4201 FROM mt.inventory I WHERE I.I4240 = "mt" AND I.I4201 = "sample-11" share|improve this answer answered Sep 26 '13 at 19:30 RE: Database Connector Error: ‘42S02:[Microsoft][ODBC SQL Server Driver][S Hviezdoslav (TechnicalUser) (OP) 17 Feb 11 12:41 - - -This is me again, the one who posted this thread to ask.I tried the Already a member? Check This Out

Does every root have an assigned primary use? 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) My short version of this was to say "a SQL Expression can't do a "SELECT". What happens if BB-8 rolls the wrong way? her latest blog

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... 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 There has to be something in the way the report is passing data to the stored procedure that is causing the issue. Can my employer see what I do on the internet when I am connected to the company network?

Using a blank report template I have prepared a report in crystal repot and everything has been fine. For reference, here's the header of the Stored Procedure: create or replace PROCEDURE HDT_CORE_GETDATA_DDS_V110 ( DataReturn IN OUT HDT_CORE_MAIN_V110.CORE_REC_CURSOR , ParamOrgCode IN VARCHAR2 DEFAULT NULL , ParamCourseNumber IN VARCHAR2 DEFAULT NULL Edited by BrianBischof - 30 Aug 2007 at 4:54pm Please support the forum! Posted on 2008-11-18 Crystal Reports Query Syntax 26 1 solution 3,718 Views Last Modified: 2012-08-13 The following is my SQL Expression: (select distinct count("x"."evid_id") from "reptext" "x" INNER JOIN "evidence" "e"

Did people in China resort to cannibalism during the reign of Mao? Not the answer you're looking for? I unable to understand if data is coming duringMain ReportPreviewasso why this error occured. I would copy the SQL into the Query Analyzer to get a better error message.

mlmcc 0 LVL 34 Overall: Level 34 Crystal Reports 33 Query Syntax 6 Message Active 1 day ago Accepted Solution by:James06282008-11-21 James0628 earned 500 total points Comment Utility Permalink(# a23018961) Do I need to install it on my machine or the server? –Pat Apr 24 '15 at 17:23 Are you using windows authentication? Should someone know little about SQL to query the database in CR . When i tried creating an sql command, it works perfectly, but when i just create sql expressions thats when i get the error message..

Some components may not be visible. 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_ Join them; it only takes a minute: Sign up Crystal Reports 14.0.2.364 + Oracle 11g Stored Proc + ODBC Connection Error 42000 up vote 0 down vote favorite I have developed Ialso checked parameterorder which I had passed in CR13.

I am trying to create a report for a web application. http://swirlvision.com/crystal-reports/crystal-reports-database-connector-error-42s02.html Download drive from here microsoft.com/en-us/download/details.aspx?id=29065 –Hiten004 Apr 24 '15 at 16:30 What will this do for me? I think so! But all of the examples I've seen are written as {Inventory.I4201} but I haven't been able to get any SQL to run an example of this would be: SELECT "Inventory"."I4201", "Inventory"."I4240"

Sounds to me like something went wrong in your stored procedure. 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. It's quick & easy. http://swirlvision.com/crystal-reports/crystal-reports-database-connector-error-hy007.html I can't see any way to get that to work.

SQL Analyzer doesn't know about the other query or the fields in it. Not sure if i'm typing it correctly or if CR uses different syntax. 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.

What I'm seeing that I cannot explain is this.

Join them; it only takes a minute: Sign up Crystal Reports SQL and Fluke MetTrack up vote 0 down vote favorite I have a database running Fluke MetTrack v8.1, this runs We have verified the username we're logging in as has the correct privileges to run the Oracle Stored Procedure. I can run my stored procedure without error in SQL Server. Try: (select distinct count(x.evid_id) from reptext x INNER JOIN evidence e ON e.evid_id=x.evid_id INNER JOIN dnaProfile d ON x.result_id=d.Result_id where x.req_id = [REPTEXT.req_id] ) 0 LVL 29 Overall: Level 29

No. Reply bbcompent1 All-Star 33790 Points 9458 Posts Moderator Re: Failed to retrieve data from the database. Msg 102, Level 15, State 1, Line 8 Incorrect syntax near 'sqllims'. 0 LVL 100 Overall: Level 100 Crystal Reports 94 Query Syntax 8 Message Active today Expert Comment by:mlmcc2008-11-18 http://swirlvision.com/crystal-reports/crystal-reports-database-connector-error-hy010.html I see.

So is the problem with the connection or with the query i wrote. Browse other questions tagged oracle stored-procedures oracle11g crystal-reports or ask your own question. My question is : Is there any way to extract the data in Sql server database using Crystal Reports. but i got the same result.

thanks for the help again IP Logged BrianBischof Admin Group Joined: 09 Nov 2006 Online Status: Offline Posts: 2460 Posted: 01 Sep 2007 at 1:49am Oh.