I am trying to get SQL server CE 2.0 RDA that was working on IIS6 (Server 2003) and Sql Server 2000 moved to a Windows 2008 server with IIS and SQL server 2008.
Is this something that is possible? It seems that there is no fundamental reason that it would not. The target database is not changed since the migration.
My first problem is that I do not seem to be able to get the Virtual Directory right. Testing the URL causes a prompt for download. This, of course, did not happen on the old installation.
Part of my problem is that I have no access to the source code of the client program. About the only configuration I have is the ability to change the URL on the client.
Thanks, Jim