Crystal report error

[Former Member]

crystal report created in asp.net2010 with stored procedure working fine on local but not on live.

Failed to open the connection. Failed to open the connection. Details: [Database Vendor Code: 53 ].

if i create report using table it works on local as well as on live but if i use stored procedure it showes error.

Its urgent

[former_member11696 · Accepted solution]

To start with what version of CR are you using?

32 or 64 bit App Pool?

Would help to know what database you are using and how you are connecting, OLE DB, ODBC or native Driver?

You may want to search also, lots of posts on database connection issues.

Don

[Former Member]

Thanks for reply

I am using sql server 2008 and asp.net 2010

connection established using oledb

n server of 64 bit.

where i am doing wrong

[former_member11696]

SQL Server 2008 requires the use of the SQL Native 10 client to be installed and used.

Also, if you are using 64 bit IIS then you need to deploy the 64 bit Cr runtime.

I suggest searching and going over the various posts...

Don

[Former Member]

Thanks for reply!!

Sql native client 10 is installed on server and 64 bit runtime also.

if i generate report using tables then it works on server also.

But if i used strored procedure then it showes error of vendor code 17.

I grant permission to stored procedure.

still same error displays.

Need urgent help.

[former_member183750]

Vendor code 53 (your 1st post) or vendor code 17?

When you look up the documentation for SQL server re vendor code 17 you get:

"Error: SQL Server does not exist or access denied. (Error code 17)."

Perhaps something to consider(?).

- Ludek

[former_member11696]

Check that Read/Write and Access are enabled for your account running the app.

You may want to use Trusted Authentication, it uses your Domain log on info. It does require the Server to have your user name and Both Authentication modes enabled.

SQL Profiler with security enabled will tell you what table/SP is being denied.

Don