|
-
Oct 21st, 2008, 06:07 AM
#1
Thread Starter
Hyperactive Member
Stored Procedure Connectivity Problem
Dear Friends
I am using crystal report 10 with sql server 2000 last many years. Usually i used stored procedures instead of tables. Yesterday all of sudden cyrstal report reutrned a message that "file name" not accessable and saved it as temporary file". Then i checked in "Document ans setting\..\..\local settings " folder where lots of temporary crystal reports exists. I deleted them all. After this i tried to re-create an other report, when i tried to open stored procedure from expert lint, i received an error "Query Engine Error: '22018:[Microsoft][ODBC SQL Server Driver][SQL Server] Syntax error converting the nvarchar value '%' to a column of data type int".
Crystal report returns this error in all procedures and all other database's procedures. I uninstall and installed twice but problem was exists there. Then i installed Crystal Report to an other computer, here also same message returned by crystal report.
Plese help as soon as possible, I am really stuck.
Thanks in advance.
Last edited by zubairkhan; Oct 21st, 2008 at 10:31 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|