Visual Studio 2008 and 2010 (Data connection Issue in Server Explorer) with Cache Database.

One of my co-worker approached me and showed me a very interesting issue, In Visual Studio 2008 and 2010 she was able to connect to the Cache database through ODBC drive but she was not able to explore the server objects… After looking into it, we tried several things but nothing was working. We re-install Visual studio re-install the ODBC driver and also tested though other application but it everything was working fine but after more deep diving I finally figure out the solution it was because of the old ODBC driver the Intersystem cache driver that was installed on her machine was of 2003 and there was latest driver was present .. So after installing the latest driver visual studio did not complain anything and she was able to explore cache objects …
So check your ODBC driver version first…….

Cache database linked to Sql server with Silverlight 4.0 and WCF RIA

This is interesting project, We have a Cache Database for specific application and the database design and control was proprietary for this application. We were allowed to used the data but no modification were allowed on the server. After carefully review of the situation I came up with the idea to add a cache database linked with sql server.. Linking to SQL Server gave us three fundamental advantages..

1) Writing SP's in SQL Server while utilizing data from Cache database.
2) Writing Views
3) No changes in the Cache database.

After successfully linked with cache database we built the application on state of the art platform Silverlight 4.0 and WCF RIA Services.