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.
When I create a new login for my SQL Server 2008 I also specify a password for this login. But when I, after the creation is done, check the login's properties the password is much longer than the one I specified. If I here change the password once again, SQL Server 2008 will automatically change the password for the login - again. ANd I don't know what the password that SQL Server keep putting for my logins, since the password consists of small black dots.
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'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 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,
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 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 want to create password in single database for example when i attach My database abc.mdf or open that database then it ask me password. as like access database password..
View 3 RepliesHow 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 to save user Credantials but I dont know how to save the password into the sql database
View 4 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 RepliesWhen I initially created my SQL Express 2008 database I vastly over-estimated the size of my database files. The problem is that now I have the correct field sizes and data actually in the database it does not require the max file sizes and growth that I had originally set.
This is a problem as I have a max database size of 500Mb with my web hosting provider and it appears that my database now has too large a footprint. This is after I have used the shrink database command in SQL Server Management and shrunk the database to a size of 6Mb so I can only presume that the problem lies with the fact that my original file size / growth settings are taking my database size to well over the 500Mb threshold I am permitted.
Is there anyway for me to change the max file size and growth options of my database without having to recreate the database from scratch?
I have created sample database in my SQL server 2005 database.Now i want that database should be password protect when i click on SQL SERVER DATABASE FILE. how to set password when anyone click on my sample database file it will show enter password field to enter into the database.
View 4 RepliesI want to save my password and it sould be saved in encryptd form in my db SQl Server in asp.net.
View 1 RepliesHow could one set a password on a database in Sql server 2005 & 2008
View 3 RepliesIn C# I need to connect to a database. How do I find out the username and password to use for that database? I know that sometimes the "sa" username can be used. I don't know how to find the password though. I am working on a contract and no DBA, and the developer left for a different job.
View 1 RepliesI am using the below post to encrypt and decrypt the password.
ENCRYPT POST
Now my code is working for Encryption. But now what I want is,
When I am using Forgot passwprd functionality, I want to send the decrypted password to the respective user in the Email.
In my database table the password is saved in the Encrypted format.
I have the code decrypt code from the above mentioned post, the question is where to place in the below code so that it will decrypt it properly
Here is my code:-
protected void btnSubmit_Click(object sender, EventArgs e) {
DataSet ds = new DataSet();
using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DefaultCSRConnection"].ConnectionString)) {
conn.Open();
[Code] ....
I have a web form, which is to allow user to reset their password. When I clicked on the button, I got this error
"Input string was not in a correct format."
The code behind the button is:
[Code]....
When the user types in the new password, this new password will be hashed upon clicking the button and saved into the database.
can I change the password algorithm and still use the sqlMembershipProvider or do I have to create a new sqlMembershipProvider. If so, are they any step by step tutorials on how to do that.
View 1 RepliesHow do I change the required password format in membership?
View 2 RepliesWhat is the Best practice of dynamic changing password for this scenario?
The scenario is:
There are three web apps using ASP.NET.
App1 checks the passwords of app2/app3 to authenticate the identity, and if app2/app3 is authenticated then app1 is allowed to receive information from App2 and App3.
And app1 has to change the passwords of app2/app3 every two hour for security reason.
Is it possible that there is a way to implement this scenario without app1 saving the passwords of app2/app3 for security reason?
Or is there any best practice for dynamic changing password scenario?
Our user is using integrated windows authentication.
All users hit the login page where they must login with their domain/username/password combination.
Once they login, they can change their password.
Once the password is changed, they are displayed a message and they can navigate through the rest of the site.
I get the following scenarios...
1) User can view one page but not a second page User changes password USer clicks on link and receives page USer clicks on second link and is asked for credentials
2) User can view all pages USer changes password User clicks on link and receives page User clicks on second link (and all links thereafter) and receives page (they are never prompted for credentials)
3) User can not view any pages
User changes password USer clicks on link and is asked for credentials