I have opened my database up in VS2005 and it is only showing 1 user but when I load the asp.net config web tool it says I have two. I thought the asp.net tool pointed to the database in app_data?
View 1 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 a website in asp.net4.0 with database in sqlexpress 2008 and host it On server with DotNetPanel.but I get error 500 when i try to view it.the problem is my web.config surely.but i can't find the mistake,thus I set custom error to off.but yet iI couldn't found the problem.the bold texts represents the codes that i have added to text.my site don't haveany security or don't use the roles and other.
<?xml version="1.0"?>
<!-- For more information on how to configure your ASP.NET application, please visit http://go.microsoft.com/fwlink/?LinkId=169433 --> <configuration>
<connectionStrings>
<add name="connection" connectionString="Server=serverAddress;Database=DBname;Uid=username;Password=password;" />
<add name="ConnectionString" connectionString="Server=serverAddress;Database=DBname;Uid=username;Password=password;" /> </connectionStrings>
<system.web>
[code]...
What it best location to store various configuration settings of a web site modules. Creating class (that inherit ConfigurationSection) that map the settings in web.config file?Or creating some DAL and BLL clases that work with database?
View 5 RepliesAs mentioned in this tutorial (http://www.asp.net/webmatrix/tutorials/5-working-with-data), I tried using my own connectionstring from web.config.
I got this error: "Format of the initialization string does not conform to specification starting at index 0."
The tutorial suggests to use: Database.OpenConnectionString("SmallBakeryConnectionString") method
Instead you should use Database.Open("ConnectionStringName").
Ref: http://cytanium.com/forums/yaf_postsm18_Connection-string-problem.aspx
The API Document is missing Database.Open method and also Database.OpenConnectionString info needs to be modified.
To give some background details, I have created a website for a friend that has a few pages that require a database in the background. I've used Visual Studio templates for most of it, so there's the standard ASPNETDB.MDF file that's created for users and groups, a login page and a page to view and manage those users etc etc. The login page uses the standard controls for logging in, retrieving lost passwords and so on. Being standard controls, by default they get the connection string from the web.config file. Upon attempting to upload the site to my host (1and1.co.uk in case anyone else has any dealings with them) I discovered that storing the connectionstring doesn't work. 1and1 support say that the sql databases can only be accessed using scripts like this (this is an example of theirs):
<html>
<title>Queries from the MS-SQL database with ASP</title>
<body bgcolor="FFFFFF">
<h2>Query from table <b>products</b> with ASP</h2>
<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "PROVIDER=SQLOLEDB;DATA SOURCE=mssqxxx.1and1.com;UID=dboxxxxxxxxx;PWD=xxxxxxxx;DATABASE=dbxxxxxxxxx"
'This code block will create a recordset
Set rs = Server.CreateObject("ADODB.Recordset")
SQL = "select * from products"
rs.open SQL, conn
'will iterate to display the records got from the database
While Not rs.EOF
response.write(rs("id") & " " & rs("price"))
rs.MoveNext
Wend
'closes the connection
rs.close
conn.close
Set rs = Nothing
Set conn = Nothing
%>
</body>
</html>
So my question, is it possible to get the standard asp.net controls to access a database through a script like this?
I have implemented Membership and Role Provider in my web site. Membership and Role information is stored in database created from aspnet_regsql option.
I want to store the access rights given to the pages in ASP.NET Configuation option in Database inspite of web.config file and want to give page wise add, edit, view and delete rights that should also be stored in database.
Is there any inbuit class like Membership and Role to add page access rights?
I know I can use [assembly: FileIOPermission(SecurityAction.RequestRefuse, Unrestricted = true)] to limit user to access disk files, now I hope to limit user to access database and web.config file, how can I do?
View 2 RepliesI use the default ASP.NET Profile Provider which lets me define user properties in web.config.
I now no longer want to use one of these user properties. I want to delete all traces of it.
I can remove the property from the list of properties in web.config however, I suspect, the stored values for this property will still be held in the aspnet_Profile table for each user.
Is there an easy way to clean out all traces of the data for a property that's no longer used from the aspnet_Profile table?
My problem is i need to update only the database name in current connection string in web.config at runtime....
this is the sample code .. to update connection string . but it updates the name of connection string i need to change the database name of connection string !
public static void UpdateConnection(string name, string connString) {
var webConfig = new ExeConfigurationFileMap {
ExeConfigFilename = GlobalSettings.FullpathToRoot + "web.config" };
[Code] ....
I am trying to conect to my SQL Server 2008 instance from application in Visual studio unsuccessfully.
This how my Instance appears in SSMS
DETERMIN (SQL Server 10.0.4000 - balloonshop )
Below is an example of a connection string from the book I am following which works if you have SQLExpress on your localhost domain.
I am using SQL Server Enterprise My Server name is DETERMIN (computer) . When I am in SSMS this is how my instance node appears
DETERMIN (SQL Server 10.0.4000 - balloonshop )
Determin is the name of my computer I think its the name of my instance as well not sure, balloonshop is my login. How can I substitute the names properly for the connection string below in order to connect to my instance
[Code]....
[Code]....
I have added the below tag in my web.config file;
<RewriterConfig configSource="configuration
ewriter.config"/>
It gets the rewrite vlues from another config file. I need to update this rewriter.config file dynamically.
I need to gets values inside it from sql databse. here is the look of the file
<?xml version="1.0"?>
I am trying to access Mysql database from aspx.pages using a web config file.
My web.config connection string is:
<configuration>
<connectionStrings>
<add connectionString="server-10.xxx.x.xx;uid=xxxxx;pwd=1234;database=Mydb"
providerName="MySql.Data.MySqlClient" />
</connectionStrings>
</configuration>
[Code]...
I have a database on Go Daddy and my VS2008 app can not access it via web.config connection string. Of course runs great locally in development. I copy/pasted the connection string information from Go Daddy exactly into my web.config file. Web site runs fine on the web but when I try to Login at my login page, i get :The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider can not automatically create the database file.
I used VS2008 to create the .sql script files and uploaded them to Go Daddy and the Go Daddy people say everything works as they and I can both Login to the database from within GoDaddy.The database i am trying to access consists of the a ASPNETDB.mdf and another Database.mdf together as one in the Go Daddy database.
here is what i used: <connectionStrings><add
name="superskin"
connectionString="Data
[code]...
How 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 Repliesi have been trying to use log-in tools in VS2008
i made folder named Admin with web.config contains:
[Code]....
As per the increasing security threats, my site needs extreme care in terms of security in all aspects. I know asp.net has built in some security measures (Anti-forgery token, cross-site scripting, authentication, roles), but that is just not enough.I need a tool to test all possible security threats (Brute-force attacks, .... IP location, browser info ... )and a framework (open source is better) that handles all these concerns and let you build upon.
EDIT,So to narrow a bit, my primary concern is protecting the "login" page from all possible threats.
I am trying to get a captcha web control to display, but it isn't going into the HttpHandler that I created. This isn't my project and it is quite big so I'm not sure what is going on. Is there any tools or techniques to see which handler is being called.
View 4 RepliesCan you recommend any tools? Should we build our own? Should we create the sitemap manually?
View 8 Repliesprovide me code or free tools for searching procedure within the site.
I want to search a particular topic by putting keyword in a textbox.