I'm trying to make a connection betweel the Crystal reports and the SQL server 2005, I have the same data base structure as another server with SQL 2000. I'm using the ODBC to initiate the connection for both DBs, but unfortionatelly, with the SQL2005 database, I can't see any of the views or the SPs, although I can see them on the SQL2000.
I thought it's an issue of security with the user or the Schema bending at SQL 2005, so I tried with Excel to initiate the connection to the same SQL 2005 and the same user name, the result is that I can see everything???
Any reason for that, please I hope I can find help here as I tried all the options can be done.