physical database not found

[Former Member]

I have a stored procedure that i have created in sql.

i have not had any issues in the past until yesterday

when i create a NEW crystal report and use an ODBC connection, i can retrieve the sp but i receive an error

PHYSICAL DATABASE NOT FOUND.

If i take the same code and create a view or table, i can use those without a problem.

if i take an already created report and set my location to the sp i can use it and i dont get an errror.

My co-worker has no problem using the sp.

under options CHECK NULL VALUES BOX is greyed out as well.

any help will be greatly appreciated.

[Former Member · Accepted solution]

Hi Sharon,

Try creating a report using OLEDB connection and verify whether it is working fine.

Regards,

Vinay

[Former Member · Accepted solution]

i still receive the same PHYSICAL DATABASE NOT FOUND. any other ideas?

[Former Member · Accepted solution]

Hi Sharon,

Please try the following:

In Crystal Reports, select 'Report Option' from the 'File' menu.

Now clear the checkmark from the option 'Use Indexes or Server for Speed' if it is checked.

Hope this helps you!

Regards,

Anindita

[Former Member · Accepted solution]

thanks, we use a shared citrix environment, things change all the time. have a nice day