I have come accross a scott's blog today;
http://weblogs.asp.net/scottgu/archive/2010/06/30/new-embedded-database-support-with-asp-net.aspx
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 have been searching for some information on how to import my xml file into a series of tables using a mapping file (schema).
View 2 Repliescannot find binn in my sql server express edition..
what might be the problem?
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?
View 2 RepliesI 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,
After installing Sql Server 2005 Express edition and Sql Server 2005 Management studio Express on Windows 7 Ultimate Release Candidate, it work's fine but when I install Windows 7 Ultimate Edition....I got this error when creating or attaching new database "
"Failed to retrieve data for this request (Microsoft.SqlServer.SmoEnum)"
i m facing the problem to insert data into database in mobile appliction i have written the code to insert data in c# and its working fine. Executenonquery returns one row but when i select data directly from the database it dont have any data and when i insert data directy into database then data is inserted and show in appliction.
View 4 RepliesI have trouble installing SQL Server 2008 Developer Edition. I am using Windows XP SP3. I have also installed Microsoft .NET framework 3.5 SP1 just prior to installing SQL Server 2008. The following error messages appeared during installation:
[code]...
I have Sql Server 2005 Express Edition ....
In which i want to implement Replication .....
can it be possible ..... ??
What are the Prerequisite to implement Replication for Sql Server 2005 Express Edition .....?
I am about to get my sites hosted with a local host company. They are offering me their lowest cost MSSQL server, which is the web edition. So my question is what is the difference between that and 2008 express edition? Can express edition be used for a full fledge in production website? And does Web implies that I will be interacting with it via the web correct. Lastly, if the web version is not chosen what is the typical protocol for uploading and maintaining a site when you have a dedicated server. Do you normally have to go to the data center or is there like a web portal that can be used. I will be asking the guys at the company these questions as well, but I want to make sure I get another opinion on the issue.
View 1 Replies The whole bit about SQL Server is missing in the Add Reference window in :
Microsoft Visual Studio 2010
Version 10.0.30128.1 RC1Rel
Microsoft .NET Framework
Version 4.0.30128 RC1Rel
Installed Version: Ultimate
Microsoft Office Developer Tools 01019-315-4422943-70530
Microsoft Office Developer Tools
Microsoft Visual Basic 2010 01019-315-4422943-70530
Microsoft Visual Basic 2010
Microsoft Visual C# 2010 01019-315-4422943-70530
Microsoft Visual C# 2010
Microsoft Visual C++ 2010 01019-315-4422943-70530
Microsoft Visual C++ 2010
Microsoft Visual F# 2010 01019-315-4422943-70530
Microsoft Visual F# 2010
Microsoft Visual Studio 2010 Architecture and Modeling Tools 01019-315-4422943-70530
Microsoft Visual Studio 2010 Architecture and Modeling Tools
UML® and Unified Modeling Language™ are trademarks or registered trademarks of the Object Management Group, Inc. in the United States and other countries.
Microsoft Visual Studio 2010 Team Explorer 01019-315-4422943-70530
Microsoft Visual Studio 2010 Team Explorer
Microsoft Visual Studio Code Analysis Spell Checker 01019-315-4422943-70530
Microsoft Visual Studio Code Analysis Spell Checker
Portions of International CorrectSpell™ spelling correction system © 1993 by Lernout & Hauspie Speech Products N.V. All rights reserved.
The American Heritage® Dictionary of the English Language, Third Edition Copyright © 1992 Houghton Mifflin Company. Electronic version licensed from Lernout & Hauspie Speech Products N.V. All rights reserved.
Microsoft Visual Web Developer 2010 01019-315-4422943-70530
Microsoft Visual Web Developer 2010
Crystal Reports Templates for Microsoft Visual Studio 2010
Crystal Reports Templates for Microsoft Visual Studio 2010
Microsoft Visual Studio 2010 SharePoint Developer Tools 10.0.30128
Microsoft Visual Studio 2010 SharePoint Developer Tools
Microsoft XNA Game Studio 4.0
Microsoft XNA Game Studio 4.0
Build 4.0.20304.
Where do I find them and how do I bring them into the IDE?
I have a table called 'products'. In each table there is a column named 'description' of type ntext (sql server 2000). The description conains a ton of text and within that text there is an ip address many times. I need to replace every instance of the ip address with the actual domain name, 123.45.678.990 with http://domain.com.
View 5 RepliesWhere can I find the expiration date of SQL Server 2008 Evaluation Edition? It's not in Help >> About and I don't see it in the server properties either.
View 7 RepliesI 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'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.
View 2 RepliesI 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'm implementing an AJAX autocomplete feature where the user types into a textbox and the webpage generates suggestions (pretty much like how Google's search box works). I got the AJAX part to work right, but for some reason, my database query does not.Let's say I want to find "Chicago". Using the following query does not find it.SELECT TOP 10 citynames FROM city WHERE CONTAINS(citynames, 'chi*')But using this query does.SELECT TOP 10 citynames FROM city WHERE CONTAINS(citynames, 'chicago')By the way, "citynames" is an ntext type field and I'm using SQL SERVER 2008.Does anyone know why my first query can't find "Chicago"? I've been staring at that query for hours, yet can't find anything wrong with it. Something wrong with the database maybe?
View 2 RepliesMSChart created a temp compact database ( ASPNET.MDF ).
This was on my personal laptop. I'm moving the project to another PC for a demo at work. But, my sa password is different now.
How do you login to this database? or can I run a utility to push the tables to sql server instead?
I keep getting the sa password fails message, because the laptop and work have different passwords.
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]
View 4 Repliesquery in SQL Server Express, which worked fine, now I am trying to do it in WebMatrix using a Compact 4.0 db but it gives me an error.
SELECT *, (SELECT
count(1)
FROM Posts
WHERE CategoryI
[code]...
I am trying to create strogly typed datasets for my project. When I right click on the xsd file that I need to generate a strongly typed dataset for I can't find the 'Advanced' properties as described in the below article (almost half way down)[URL]As I do not see the Advanced properties option I can't find the 'Custom Tool' property/option to set its value to 'MSDatasetGenerator'. Do I have to install some kind of patch on my VS 2005?
View 5 RepliesI 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.
ASP.NET Buttons are not firing OnClink() events if it is placed in content page. There is no problem for master page buttons. This problem I am facing only in windows xp home edition.
View 6 RepliesBoth visual studio 2008 express edition and visual studio professional setup's are install in my system, i like to uninstall visual studio 2008 express edition, and use professional edition. is there any problem arises in visual studio professional edition, if i uninstall visual studio 2008 exp edition
View 2 RepliesBy right clicking on my database i created a query in server explorer. But where are this query stored can't find them back. I should aspect that their is a folder query's like there is a folder tables but this isn't the case.
View 10 Replies