RE: Database Connector Error

[allyne]

Hi Everyone,

I'm currently using Crystal Reports XI and am trying to create a new Crystal report using an ODBC Connection to a SQL Server Database that will connect to a stored procedure. The ODBC Connection works fine and my stored procedure works fine when I run it from the Server using the Query Analyzer.

When I try to create a new connection I get the following error message.

Database Connector Error: 22018:[Microsoft][ODBC SQL Server Driver][SQL Server] Syntax error converting the nvarchar value '%' to a column of data type int. [Database Vendor Code:245]'

I have another Crystal report that uses the same stored procedure and have no problems and not sure why this is now happening. There have been no changes to the stored procedure.

Thanks for all your help!

 

[synapsevampire]

It appears that somewhere in the SP you are converting a percent to an integer.

-k

 

[allyne]

Thanks for your quick response! It looks like I was getting a bogus error message. The Crystal reports software on my computer some how became corrupt. These reports work on a co-workers computer.

Thanks for your help!