Report Design
 Crystal Reports Forum : Crystal Reports .NET 2003 : Report Design
Message Icon Topic: ODBC Error Post Reply Post New Topic
Author Message
phil22046
Newbie
Newbie
Avatar

Joined: 07 Nov 2007
Online Status: Offline
Posts: 1
Quote phil22046 Replybullet Topic: ODBC Error
    Posted: 07 Nov 2007 at 7:11am

I am getting an ODBC error when I use a SQL Server 2000 Stored procedure as my data source.  The error Msg is: ODBC error; [Microsoft][ODBC SQL Driver] Invalid character value for cast specification.

I can run the stored procedure in the query analyzer and I get data returned without any errors reported.   I examined my data and found no anomalies.   Also I removed all Cast conversions from the SQL and replaced with convert.  I still get the same error message.
 
The ODBC driver version is SQL Server 2000.85.1117.00
 
 
IP IP Logged
jkwrpc
Senior Member
Senior Member


Joined: 19 Jun 2007
Location: United States
Online Status: Offline
Posts: 432
Quote jkwrpc Replybullet Posted: 07 Nov 2007 at 1:08pm
This is  a pretty basic idea and one you likely have tried. 
 
I dont know how large your stored proc is, but you might try commenting out the individual variables (if any) and related datafields then add them back at one at a time until you find the offending problem or get a more descriptive error message.  It does seem to be in the stored proc.  If you are passing any parameters or variables to it and the data types dont convert could be a cause. Specifically data typing the parameters and variables could resolve the problem.
 
 
Regards,
 
John W.

 

IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.