SQL Server :: No Compact 4 Tools In Visual Studio?
Mar 19, 2011
i have installed visual studio 2010 sp1, i have installed everything to do with compact 4 from web platform installer. yet when i try to connect to a compact 4 database, their is no choice for compact 4, there is a choice for compact 3.5 but no 4. If i try to connect using tthe 3.5 choice i get an error. i can add a compact 4 database from the new items menu. but i can not make a connection to it.you can see in this tutorial compact 4 listed in the add connectiojn box, but it is not listed in mine[URL]
I'm currently trying to install the "new" Microsoft WebMatrix Beta 2 (a web programming IDE). I was trying to use Web Platform Installer for this. But it 404's on the SQL Compact 4.0 CPT2 and it's tools. I was able to get the runtime from the Microsoft downloads page but the tools I am not able to find. I can not install WebMatrix because the tools are a prerequisite.
I'm trying to access an SQL Server Express database out of an ASP.NET HTTP request handler. The handler is run under ASPNET account and uses "integrated security" in the SQL connection string and so I get an error message saying that login for ASPNET account failed and so I can't access the database. This seems to be a very common problem and most answers say "grant access to you database to user ASPNET".
I only have Visual Studio 2008 and I can't find how to change access permisssions for a database. Specifically I use Tools->Server Explorer and I can see all the tables in the database but can't find how to change access permissions. How do I change access permissions to my database using tools shipped within Visual Studio 2008?
Is there any tool for Visual Studio 2008 which can reformat ASPX code to make it more presentable (eg insert line breaks, format the lines so they wrap when necessary, etc)?
I removed mvc3 tools for visual studio, and now it seems no matter how much reinstalling, or un-installing i do i cant get razor project templates or intellisence for razor.I have even removed the visual studio folder and visual studio hives in the registry but still the same. I seem to remember a simular problem with mvc2 tools, that the installer doers not reconize it as un-installed and therefore does not re-install it.how can i re-install mvc tools so VS reconises razor, or remove all trace of visual studio and mvc3 so that i can start again?
I have VS2008 running on XP. I have my websites on a remote server share so they're backed up every day. On Friday, everything was fine. Today, I have no toolboxes. I've tried deleting the tdb files, I've tried setting the autotoolboxpopulate to true/false/true to reset it. Nothing works.
Here is the way to reproduce this problem:1. Create a Blank Solution 2. Create a New Solution Folder3. Create a new ASP.NET MVC 3 Web Application project from this New Solution Folder 4. Then you'll get a "Object reference not set to an instance of an object." exception and the System.Web.Mvc assembly will not be referenced in this new project.
I have been experiencing changes in the options tools that I myself are not making, such as line numbering can someone enlighten me as to what the heck is going on with this.
I have loaded Web Site from HDD. Now trying attach it to process WebDev.WebServer.EXE. But in Visual Studio 2010 Web Developer Express edition of VS not exist tool Attach To Process. Is it normal? if yes,
I installed VS 2008 setup on my computer.I am having Windows XP OS with SP2.When I opened VS 2008 and clicked on Create Project , I got the following error."The tools version "3.5" is unrecognized."Please tell me how to resolve this.
I want connect to SQL Server Compact 4.0 in my ASP.NET application..
Here is example of code:
protected void Page_Load(object sendhttp://stackoverflow.com/questions/asker, EventArgs e) { string connStr = "Data Source=D:\MyDB.sdf;"; string sqlStr = "select * from tblMyTable"; var sqlDataSrc = new SqlDataSource(connStr, sqlStr); GridWithUrls.DataSource = sqlDataSrc; GridWithUrls.DataBind(); }
But I have the next error: "A network-related or instance-specific error occurred while establishing a connection to SQL Server.The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"
The SqlDataSource has constructor with three parameters, one of them is 'providerName' so, how to specify that I want definitely use Sql Server Compact provider ? Also I have added System.Data.SqlServerCe reference..
I am working on a CMS project using ASP.Net 3.5/Visual studio 2008.This is the first week of the project and I am working on the design of the system right now. Needless to say that this is my first project of this scale and I have no idea of what I am doing.
The requirements of the project ask for a light but functional CMS, one which is easy to deploy.So the question is which database to use in this scenario SQLCE or SQLite?
I just downloaded the above but when I look in visual web developer 2010 express I see no data provider reference .
I was wondering how to attach/create db? in the above, is it a clickable option in tools .net framework options or is VS 2010 not ready to use SQL CE 4 yet,
what is exactly Sql server compact edition? it says that I do not need a sql server to store my databases if I use that in my bin folder? so I can use my mdf databases in app_data folder. is that true?
I wanted to run MVC 2 project, so I install VWD2010 Express Beta using Web Platform Installer 2.0 but it install the MVC Preview 2 not the RTM. I uninstall MVC 2 and MVC 2 VWD 2010 Tools and use again WPI but the MVC 2 VWD 20010 Tools is not installed. [:(]
How can I handle more than 4k of text on the new SQL Compact Edition 4? nvarchar only supports 4k and when I change to ntext, I get the same exception as I get using nvarchar(4k), when using the Microsoft.Data wrapper included with Microsoft WebMatrix. Should it normally work using ntext?
I have ported an asp.net application form SQL Server Express to SQLCE 3.5 in Visual Studio 008. Although not recommended, everything works like a charm, except for creating datasets for use in SRSS reports.
The Dataset Designer lets me design and test the Tableadapter perfectly, but the XSD fails to compile, and returns error message :
Failed to generate code. Exception of type 'System.Data.Design.InternalException' was thrown.
