Crystal report is not able to find out store procedure in database

25 Views

Hi,

I am migrating CR8.5 to CR2008(runtime Environment). Here I am getting an error that Store procedure is not found.

in CR8.5 we had used C++ code to envoke crystal we have used LogOnServer function after creating the DSN.

we have also checked connection for both main and subreport. that is why we were able to sucessfully export the report.

Our main problem is :

we have varius user who installs storeprocedure in database i.e at one machine "imadmin" install amd on other machine

user "informix" isstall the store procedure . so in CR 2008 i am passing only one use info i.e UID and PASS to connect to the database but want to access both the store procedure,which is created by another user.

by doing so , CR2008 throws error says"Store procedure not found".

Please Sugges me the solution so that i can access both the storeprocedure with only one database credentials.

Thanks and Regards,

Abhineet