|
like any other tutorial, i been set up for a see how to add the membership-related schemas to an existing database using the ASP.NET SQL Server Registration Tool (aspnet_regsql.exe).
ive run the command aspnet_regsql.exe..asking for my server name and there are drop down list for the database,but when i click the drop dowm list,it will take a while when an error msg has appeared,on my second attempt. i didmt click the database drop down list instead the button "Next" the one i clicked, now "Setting SUmmary" has appeared and when i click "Next" button it will take a while and the error msg has been appeared sayinf this:
Setup failed.
Exception:
Unable to connect to SQL Server database.
----------------------------------------
Details of failure
----------------------------------------
System.Web.HttpException: Unable to connect to SQL Server database. ---> System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString)
--- End of inner exception stack trace ---
at System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString)
at System.Web.Management.SqlServices.SetupApplicationServices(String server, String user, String password, Boolean trusted, String connectionString, String database, String dbFileName, SqlFeatures features, Boolean install)
at System.Web.Management.SqlServices.Install(String database, SqlFeatures features, String connectionString)
at System.Web.Management.ConfirmPanel.Execute()
i dont know how to figure it out...
THank You for the answer....
|
|
|
|
|
I did this a long time ago and don't remember what I used so I'm hoping someone here will have an idea.
I used a data structure in a function that took a string parameter that I passed in. A data structure in that function would insert the string if it didn't already exist and it would raise an error if it did. That way I could easily tell if I was working with a repeated string value in a series of data related events.
I am having total brainlock and don't remember what I used... Anybody got an idea?...?
My name is Maximus Decimus Meridius, Commander of the Armies of the North, General of the Felix Legions, loyal servant to the true emperor, Marcus Aurelius. Father to a murdered process, husband to a murdered thread. And I will have my vengeance, in this life or the next. - Gladiator
I work to live. I do not live to work. My clients do not seem capable of grasping this fact.
|
|
|
|
|
Really annoying me now cos I have seen this so many times in my project and am yet to work out exactly why it wont work. I have about 10 textboxes all with validation controls. Some with two.
For some reason the page goes nuts in IE 6. Firefox displays it exactly as expected. When you press the submit button it changes the page again and different elements go nuts.
I have been through my CSS, checked all code from the browser and the rest but still no obvious reason for it. If I remove some of the validation controls it stops happening but there is no pattern to it.
Any body seen this before?
One more thing. IE 6 is a piece of sh*t!!
|
|
|
|
|
Try to find any alternate solutions. Have you tried JavaScript for validation? I feel it is flexible than validation controls
Thomas
|
|
|
|
|
That's a fair point but validation controls do pretty much offer a solution to cover every problem. And they are a dam sight easier and quicker than writing your own code. So anyone else seen this issue?
|
|
|
|
|
Using ASP.NET 1.1 with Visual Basic language.
I have a ASP.NET page that does a lot of processing that takes a long time.
You select some parameters on one page and click a button
to go to another page that does the processing and displays the results.
Since processing takes a long time, I would like to display some
progress messages in the results page before the final results.
I have done this before with plain ASP (not .NET) by following
Response.Write with Response.Flush.
That worked fine. The page is updated for each progress message.
That does NOT seem to work with .NET.
I have tried lots of things:
Transferring to the results page using Server.Transfer and Response.Redirect
Turning page buffering on and off
Turning page caching on and off
No matter what, the results page is not displayed at all until its processing is finished.
It does not even transfer to the results page and display a blank page while it is processing.
The first page is still displayed until the results processing is finished,
then the results page is displayed in full, with all the progress messages
and the results.
I have searched the MS web site, and all indications there seem to indicate
that Response.Flush should work the same in .NET as in ASP.
Any ideas why Response.Flush does not seem to work ?
Any other ideas for how to display progress messages ?
Thanks.
Glenn
|
|
|
|
|
Hi. I've been working on a new .net login system at my job and I've been running into many problems. I need to convert the asp page to .net, and the conversion never works because the asp has COM and a lot of SSI's in it, and a lot of it is giberish anyway. So i figured i could pass form data to it to get it to think it was getting data from itself, the only problem is we're adding a "User needs to change password screen" and so there's another asp .net page it gets sent to first. i figured Server.Transfer could handle classic ASP from .net, only it throws an exception every time. So, basically i need a way to pass form data to the asp page WITHOUT response.write() writing out a form with a button and username/password in the hidden inputs. A server-side way would be preferred. Is this possible or should I just start looking forward to the COM and ASP and SSI madness?
-- Steven Hunt
|
|
|
|
|
Have you tried the Respond.Redirect instead of the Server.Transfer? Also there is an AspCompat attribute in your @Page directive.
This is what MS help says:
AspCompat
When set to true, allows the page to be executed on a single-threaded apartment (STA) thread. This allows the page to call STA components, such as a component developed with Microsoft Visual Basic 6.0. Setting this attribute to true also allows the page to call COM+ version 1.0 components that require access to unmanaged Active Server Pages (ASP) built-in objects. These are accessible through the ObjectContext object or the OnStartPage method. The default is false.
Note
Setting this attribute to true can cause your page's performance to degrade. For more information, see the Remarks section.
Anyway, Hope that helps.
Ben
|
|
|
|
|
Point of sale project where I need some developers to develop me a POS software for restaurant and Coffee shop. I am willing to pay in canadian dollars and maybe even willing to sponser students.
Regards,
Gary Sandhu
|
|
|
|
|
I am very interested in this project. I would love the challenge.
|
|
|
|
|
Where are u from and what experience do you have in Point of sale
Regards,
Gary Sandhu
|
|
|
|
|
|
Please don't cross post.
---
single minded; short sighted; long gone;
|
|
|
|
|
I'll do it for free if you can get me into Canada hehe!
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
|
|
|
|
|
I cannot open any pages in my web app. It doesnt even give me an error it just says the internet explorer cannot display the webpage. If I view it online using my IP address instread of the local host it works fine.
http:
The one thing that I did notice is that the Dev Server is not pulling a port number. So instead of something like this:
http:
I am getting
http:
HELP!!
This is very frustrating as I cannot really work until I have this resolved.
GT
|
|
|
|
|
Check this out:
http://tutorials.aspfaq.com/8000xxxxx-errors/80004005-errors.html
|
|
|
|
|
Which OS does the Web Server has?
|
|
|
|
|
I have a TextBox, corresponding required field validator, a Lookup Button and a Save Button.
I clicked on Save Button without entering any value and req field validator shows.
Now on clicking the Lookup Button a Popup window opens.I have set the focus on TextBox(present in Main Page) just before selecting a value and clicking a OK Button present in Lookup window. Also on clicking OK Button Lookup window is closed and the selected value is put to the TextBox present in Main page. still Required Field Validator is present. How to handle it? I am using ASP.Net2.0
Thanks
Srinivas Reddy Admala
|
|
|
|
|
I think you want to make validation disable when you click on lookup button
then add this to validation button
CausesValidation="False"
Thanks and Regards
Sandeep
If you want something you never had,
do something you have never done!
|
|
|
|
|
Hi,
I want to generate an excelsheet through ASP.
Can anyone share how can I format the columns?
I want to control width of the columns.
Thanks in advance.
Prasad
" Learn, grow, heal,and move forward "
|
|
|
|
|
Use Excel.Application object
|
|
|
|
|
With VisualStudio.Net, i'm using an installer class with a custom action
on my setup project to ask the user a serial number. A "Textboxes"
dialog on the "user interface" provides the serial number string to an
overrided version of then install procedure, inside my installer class.
My problem is that the install sub is able to verify the serial number
entered, but then i can't stop/cancel the installation procedure.
|
|
|
|
|
Hello, i have created a new thread to do some heavy stuff, it takes about 1-2 minute to be done, when the thread ends i want it to notify and change something in the gui, i cant access the gui from another thread so i tried creating a new delgate and invoke it, still it didnt manage to show changes in the gui... any idea?
i tried something like this:
protected btn_click(object sender, EventArgs e)
{
Thread t = new Thread(new ThreadStart(HeavyStuff))
t.start();
}
delegate void CleanGui();
void HeavyStuff()
{
// heavy stuff here
CleanGui p = CleaningGuiHere;
p.invoke();
}
void CleaningGuiHere()
{
}
|
|
|
|
|
- Create a new class doing all your heavy work...
- Create a public function to 'start' the work...
- Let the class raise an event if the work is done..
In your app create an instance of the class and an event handler which handles your event.
Create a new thread calling the exposed (public) function and start the tread.
The event will be raised when the work is done.
Note you cannot do any GUI interface changes in the event handler because the event was called from a difrent thread. Create a delegate in your 'main app class' which can be called using Invoke() from the event handler...
Hrmm... confusing explanation ... hope you understand it 
|
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
