Skip to Content
0
Former Member
May 01, 2014 at 03:49 AM

Crystal Report 2013 Vendor Code 102

467 Views

Hi,

I have been getting this error database vendor code 102 in Crystal Report 2013.

I have written my query in Command and created 2 date prompts of type date / datetime which is passed in query as mentioned below

('?From Date)

('?To Date)

I am using SQL Server 2005 ,

Now SQL Server 2005 stores datetime as yyy-mm-dd hh:mm:ss 000 and when i am selecting the dates in Crystal, it is entered as dd/mm/yyyy or dd/mm/yyyy hh:mm:ss

how do i make both the formats compatible ?

Is this the reason that i am getting Vendor Code 102 error ??

Can anyone suggest ?