Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ODBC error using Crystal report 8.5 and SQL server 2000

Status
Not open for further replies.

psperry2

Programmer
Nov 7, 2007
141
0
0
US
The ODBC Driver version is SQL Server 2000.85.1117.00

I get this error when using a stored procedure as a data source for my crystal report.

ODBC error: [Microsoft][ODBC SQL Driver] Invalid character value for cast specification.

So I tried the following:

1) removed all the cast conversions in the stored procedure and replaced with convert. Still get this error
2) Ran the stored procedure in the Query analyzer and it runs without error and returns correct data.
 
Posted a response in the SQL Server forum - this is a duplicate post....

Always remember that you're unique. Just like everyone else.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top