Skip to Content
author's profile photo Former Member
Former Member

Server Native Client 10.0 incorrect syntex DateTime

Dear Experts

We are having a problem with Crystal Reports 2008 SP2 when attempting to generate the report to stored procedure using the u201CSQL Server Native Client 10.0u201D provider. we use a stored procedure that takes a date parameter the following error is produced:

Database Connector Error: 'ADO Error Code: 0x

Source: Microsoft SQL Server Native Client 10.0

Description: Incorrect syntax near the keyword 'CONVERT'.

SQL State: 42000

Native Error: 156 Database Vendor Code: 156 '

We are using SQL Server 2008 and Crystal Reports 2008.

We are upgrading SAP from 2007B to 8.81 Patch - 06. all the crystel reports are generated in SAP 2007B. while generating the crystel report in 8.81 we are having the above mentioned issue let me help to solve the issue asap

Regards

Shamseer

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Oct 17, 2011 at 03:03 PM

    hi,

    You are using SQL Native Client as your data source, since during 2007 version Crystal report is Add-on. since now you are using 8.81 Crystal report is fully integrated to SBO. try to change your Data Source to SAP Business One.

    regards,

    Fidel

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 14, 2011 at 09:02 PM

    Shamseer,

    I had the same issue that you were having. The workaround is to replace your Stored Procedure and use the Crystal report Command and add the datetime parameters in the Command function. Here is a sample method to create commands in Crystal Reports

    http://www.youtube.com/watch?v=BHNHsIUbcn8

    Once I recreated the Stored Procedure using Command, it worked correctly.

    Hope this helps

    Krishnan

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.