Sql Server Compact 2005 on Visual Studio 2008 -


I am working on a Windows Forms application that contacts a SQL compact database file created by SQL Server 2005 is. Originally developed in Visual Studio 2005, but recently a Visual Studio 2008 solution was changed.

Regarding SQL compact, we have ensured that the references are still set for assemblies that, after doing this instead of SQL compact SQL Compact 3.5, this application is still going on as It should be - it will still interact with the compact database, execute synchronization operations, etc.

However, I have just come to know that Visual Studio Tools like Dataset do not play well with a SQL compact database file compared to Designer 3.5 if I new connection. .. Wizard, SQL Sql Compact Data Source / Data Provider for SQL Compact 3.5. I think that in the Visual Studio 2008, the data provider for the older version of SQL Compact is not included by default.

Is there any way that you can add an old version of SQL Compact to the "Data List" formula for the Connection Wizard? To actually see that I'm clicking on the Tools menu of Visual Studio 2008 and Connect to the database ... click in the window that comes up, Em> Change next to Data source setting ... There is no way to this dialog, I can select the previous version of SQL Compact - only 3.5 is available.

Maybe I need to add an assembly reference somewhere? Or can I copy some files from my Visual Studio 2005 directory compared to 2008? I would have thought that Visual Studio 2008 will have to be able to interact with SQL Server with a SQL compact database.

To provide one more bit detail, I found this problem when I went to my dataset, right-clicked and tried to add TableAdapter . The first screen that comes up says, "Choose your data connection" If I set it to a SCL compact connection, which we have always used, then click the Next> button while the following error :


A connection to the database failed to open

"The selected database was created with an earlier version of SQL Server Compact and it opened the connection or By testing , The first need to upgrade to SQL Server Compact 3.5. Check Complete add a new data connection and the connection dialog box. "

connection and try again.


The only problem here is that we still use SQL Server 2005, and if my understanding is correct, then it does not present the membership files that are compatible with SQL Compact 3.5 is. If I am wrong in this assumption, please correct me.

The help you can provide is greatly appreciated. Thank you

Try using the SqlCompact Engine Upgrade Method.

  SqlCeEngine N = new SqlCeEngine ("- conn string"); En.Upgrade ();  

Comments

Popular posts from this blog

sql - dynamically varied number of conditions in the 'where' statement using LINQ -

asp.net mvc - Dynamically Generated Ajax.BeginForm -

Debug on symbian -