Print Page | Close Window

crystal report -odbc error for datetime conversion

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15200
Printed Date: 18 May 2024 at 8:37pm


Topic: crystal report -odbc error for datetime conversion
Posted By: sent
Subject: crystal report -odbc error for datetime conversion
Date Posted: 20 Dec 2011 at 7:50am
Hi,

I have a crystal report when opened in the server gives the result properly. My DB server has 2 databases (SQL server 2005). In the database server the report opens fine for both db. I access the .rpt file via VB code.
 
When tried from another machine it throws error 527. I tried opening the .rpt file and passed the input parameters. It gives "It failed in conversion while converting it from the character string into the datetime type" error. This error comes for only one database. If I point the report to another db it works fine.

Can anyone help please ?


Print Page | Close Window