Cannot see tables & views in crystal reports 11.5

[eastwestk]

Hello,

I am connecting to SQL Server 2008 through ODBC from Crystal Reports 11.5 and I am using the below driver:
SQL Server 2000.86.3959.00

But from crystal reports I don't see tables and views.

Any suggestion is greatly appreciated.

Thank You

 

[lbass]

Go to file->options->database->data explorer->make sure "tables" and "views" are checked.

-LB

 

[Turkbear]

Hi,
If they are, then check to see if you can connect and see table/views directly to the database using the same username/password you use from Crystal.



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[eastwestk]

Hi,

Both the below check boxes are checked.

Go to file->options->database->data explorer->make sure "tables" and "views" are checked

Also I am able to directly connect to the database using the same username/password I use from Crystal.

Thank You

 

[Turkbear]

Hi,
I available, try some different connection methods, as that version might not work with the newest SqlServer...I think CR has a 'native' SqlServer connection method, but I am not sure..

Try ADO or OLE/DB maybe



To Paraphrase:"The Help you get is proportional to the Help you give.."