.sdf deployment problem VS2005

I have .sdf and .xds objects in my project for a PocketPC 2003 device. When I debug all of the CF2.0, SQL, and .SDF files are downloaded to the device. However, when I install via the application.cab file, the .sdf, .xds, and CF files do not show up on the device.

What am I missing here?

First ensure that your SDF has Build Action set to 'Content' and Copy to Output Directory = True in your project. When you then create a Smart Device Setup Project in VS2005 to create the CAB file for deployment, you need to include the project output AND the content files from your project in the setup project.

Darren

|||

After installing the CF, SQL and application cabs the .sdf file is in the correct folder. However, I am unable to open the .sdf via the application or SQLce Query Analyzer. I get the following message:

Error:0x80004005 E_FAIL

Native Error: (25039)

Description : Access to the database file is not allowe, {,,,File name,,]

Interface defining error: IID_IDBInitialize

Param. 0:0

Param. 1:0

Param. 2:0

Param. 3 \Program Files\Myapplication folder\myapplication.sdf

Param. 4:

Param.

I am still missing something. What?

|||I think I found the problem(s). A) On the device I removed SQLClient2.0. B) In VS I rebuilt .sdf and .xsd. Now it works. I think the .sdf that I replace in VS was based on CF1.0|||

cool. thanks for posting your solution.

-Darren

.NET2 SMO Components

I am new in VS2005 and I start with sql2005 express. I plan to use SQL express 2005 manager.

When I tries to install this program the system asks for MS Framework,net2 SMO Components.

Where can I download these components?

Thank You

Best regards

?yvind

All of the information needed to install and run Management Studio Express is at http://www.microsoft.com/downloads/details.aspx?familyid=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en. If you still have questions after installing the required components, please let us know.

Peter

|||

The reason for original post was to get source from where the SMO components for .NET could be downloaded so that SQL Manager could be installed properly. And what you did is just posted the link from where SQL Manager could be downloaded.

|||At this point there isn't a separate SMO package. You have to install SS2005 express on the same computer you're installing SSMEE.|||See this link which contains a reference to the SMO redist : http://blogs.msdn.com/mwories/articles/smofaq.aspx|||I stand officially corrected.

.NET2 SMO Components

I am new in VS2005 and I start with sql2005 express. I plan to use SQL express 2005 manager.

When I tries to install this program the system asks for MS Framework,net2 SMO Components.

Where can I download these components?

Thank You

Best regards

?yvind

All of the information needed to install and run Management Studio Express is at http://www.microsoft.com/downloads/details.aspx?familyid=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en. If you still have questions after installing the required components, please let us know.

Peter

|||

The reason for original post was to get source from where the SMO components for .NET could be downloaded so that SQL Manager could be installed properly. And what you did is just posted the link from where SQL Manager could be downloaded.

|||At this point there isn't a separate SMO package. You have to install SS2005 express on the same computer you're installing SSMEE.|||See this link which contains a reference to the SMO redist : http://blogs.msdn.com/mwories/articles/smofaq.aspx|||I stand officially corrected.

.NET 64-bit and .NET 32-bit Framework on a Win 2003 server x64: which aspnet_regsql wizard is re

Hi everybody,

I installed on an Win 2003 server x64 .NET 64-bit framework (beta 2.0.50215). After that I installed VS2005 beta 2 (2.0.50215) and SQL2005 (VS 2005 Beta Experience Kit). No problem are visible.

Two .NET frameworks are installed, ...\Microsoft.NET\Framework\v20.0.50215 and ...\Microsoft.NET\Framework64\v20.0.50215.

What aspnet_regsql wizard is recommended to use to configure a SQL Server database that stores information for ASP.NET applications services?

Thanks for replies...I guess it would be better to post this on ASP.NET forums. This forum is for answering questions related to CLR Integration in SQL Server 2005.

Thanks,
-Vineet.