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 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 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 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,
MSChart 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.
query 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 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?
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 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.
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 RepliesI been googling a bit and not having a clear picture on this. I have a few database now sitting duck in Express and we planning to migrate to 2005 or 2008 enterprise version. Currently, all the sensitive and important data are stored in the Express. We wanna do the migration but we do not want to impact a single column in a table. E.g. some numbers becomes different format like 234E whatever watever. Is there any good tools out there to do the job with the least efforts ?
View 2 RepliesI started the Bakery site demo...everything runs fine on my local machine.When I publish the site to production server in w2k8r2+iis7.5 and with .net 4.0 (integrate) pool, my bakery apps not able to connect to the .sdf file.
Error I got is :
Connection string "bakery" was not found. Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code. Exception Details: System.InvalidOperationException: Connection string "bakery" was not found.
Source Error:
Line 2: Layout = "_SiteLayout.cshtml";
Line 3:
Line 4: FacebookSocialPlugins.Initialize("[xxx]", "[xxx]","bakery");
Line 5:
Line 6: }
Stack Trace:
[InvalidOperationException: Connection string "bakery" was not found.]
WebMatrix.Data.Database.OpenNamedConnection(String name, IConfigurationManager configurationManager) +132
WebMatrix.Data.Database.Open(String name) +42
System.Web.WebPages.DatabaseConnectionInfo.Connect() +43
System.Web.WebPages.SimpleMembershipProvider.CreateTablesIfNeeded() +42
System.Web.WebPages.WebSecurity.InitializeMembershipProvider(SimpleMembershipProvider sMembership, DatabaseConnectionInfo connect, String userTableName, String userIdColumn, String userNameColumn, Boolean createTables) +70
System.Web.WebPages.WebSecurity.InitializeProviders(DatabaseConnectionInfo connect, String userTableName, String userIdColumn, String userNameColumn, Boolean autoCreateTables) +51
System.Web.WebPages.WebSecurity.InitializeDatabaseConnection(String connectionStringName, String userTableName, String userIdColumn, String userNameColumn, Boolean autoCreateTables) +52
FacebookSocialPlugins.InitializeMembershipProviderIfNeeded() +54
FacebookSocialPlugins.Initialize(String appId, String appSecret, String membershipDbName) +171
ASP._PageStart_cshtml.Execute() in d:xxxakery\_PageStart.cshtml:4
System.Web.WebPages.StartPage.ExecutePageHierarchy() +15
System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage) +33
System.Web.WebPages.WebPageHttpHandler.ProcessRequestInternal(HttpContext context) +207
I have a web app that delivers a page at .35 seconds on development server.But on production it takes 2.79 seconds.Is there a tools that is cheap that I can use to determine why the page is being delivered so slow?
View 2 RepliesI want to block the SQL Server database, so that no data can be export using third party tools and also the specific db can't be restore from old backups
View 1 RepliesI'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?
i have installed SQL server 2005 Server & Clicent in My PC. now i want to install SQL server 2008 Express Edition.
when i try to install it it gives an Error as below.
Rule "SQL Server 2005 Express tools" failed.
The SQL Server 2005 Express Tools are installed. To continue, remove the SQL Server 2005 Express Tools.
tables to get compact design and i am having lots of problems with it also.
View 2 Repliesi am trying to use a compact db in my web site, all works well with a absolute address to the file "c:mydirmydb.sdf"
but i dont want to use a absolute address for deployment reasons. i want to use somthing like |datadirectory to find the file.
This is a connection string for a entity model. somthing like
<
add
name="MyEntities"
connectionString="metadata=res://*/Entity.csdl|res://*/Entity.ssdl|res://*/Entity.msl;provider=System.Data.SqlServerCe.3.5;provider
connection string="Data
Source=|DataDirectory|mydb.sdf;Password=xxxxxxxx;Persist Security Info=True""
providerName="System.Data.EntityClient"
/>
have been trying to implement in a different scenario the example at the following URL: http://blogs.msdn.com/b/markprenticems/archive/2007/03/27/introduction-to-windows-communication-foundation-for-the-net-compact-framework-messaging-stack.aspxHave tried few things, but I cannot find a way to modify the following snippet (included in the above link) to send requests to methods with different parameters/signatures
View 1 RepliesHow to use tools like localize substitution?
View 1 RepliesI need to know Is any tool available for Asp.net ?
My running website is sometimes getting too slow, So that I want to know where it happen. Also My Higher person asking Profiler report. Can anyone tell me how it looks?
How does one be called a ninja ASP.Net programmer? What set of tools and immediate knowledge(Without having to open MSDN, SO, or Google) should be known to be considered a master?
View 11 Replies I have a ASP.net 4.0 which has to generate a PDF and docx file with the same content. Ofcourse the conversion will take place on server so Office Automation is not an option
(http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257757#kb2)
Im faced with the following descision: Use OpenXML SDK to create the docx and some other free tool to create the PDF.OR ,Buy a SW like Aspose so I only will have to create the docx and then generate a PDF from the docx.
What is your opinion about this? Aspose Word costs $900, will I save as much time with it to be worth it?If I choose the free option will I have a hard time getting the docx and pdf to look exactly the same?
Is there any good search tools for asp.net I can buy to carry out search indexes easily on data I have in my database?What I require is something that would carry out a general site search of articles but also faceted search as well. Faceted search is quite important feature.
View 2 Replies