Please help - missing tables in ODBC 1

[sql99]

Hello everyone,

I recently noticed that all my tables and views were missing when I go to open my ODBC in crystal report version 9 client. The only things that display under the ODBC are stored procedures. Has anyone ever seen this issue?

Thanks,
sql99

 

[synapsevampire]

The settings might have been altered.

Go to File->Options->Database and check the data explorer for which objects will be displayed, select those that you want.

If those are set properly (hit F5 to refresh), then it might be a permission change, check with your dba.

-k

 

[sql99]

Thank you for your reply, synapsvampire. The options are set correctly. This issue happened when we did a database restore.

 

[synapsevampire]

I'd guess that they didn't run the permissions script correctly.

-k

 

[sql99]

Thanks synapsevampire. I will check w/my DBA.

sql99