Visual Studio :: Error Adding Connection In Server Explorer - Unable To Add Data Connection. ExecuteScalar Require
Sep 30, 2010
I have VS 2010 professional. I am trying to open "ASP.Net Configuration" through Project -> ASP.Net Configuration.
It pops up the Notification about the ASP.Net Development Server localhost but doesn't open ASP.Net Configuration in the default browser.I clicked on the Root Url (by double clicking on the 'development server' at the right bottom from Notification Manager).
It throws following error
"An error was encountered. Please return to the previous page and try again."
Clicking on "How do i use this tool".It opened page with error.
Tool Has Timed Out
View 2 Replies
Similar Messages:
Sep 13, 2010
I'm using Visual Studio 2008, and my database is SQL Server 2000.
I want to add a connection to the Server Explorer in VS. The Data source is Microsoft SQL Server (SqlClient). After entering in all my information and I click Test Connection, it is successful.
But when I click OK, I get the error:
Unable to add data connection. ExecuteScalar requires an open and available connection. The connection's current state is closed.
View 3 Replies
Apr 18, 2010
When I open an ASP.NET 3.5 project using VWD2010, I get a prompt error message,"The connection property in the web.config file is missing or incorrect.The connection string from the .dbml file has been used in its place."however, my project works successfully.
View 1 Replies
Aug 13, 2010
This issues has been driving me nuts. I am trying to follow the tutorial on [URL] I am trying to connect to a database in Microsoft SQL Server 2008. The way I do this is by right clicking on the "Data Connections" > Add Connection. Afterwards the Add Connection window comes up, I make sure my data source is "Microsoft SQL Server (SqlClient). And, I choose a server name; the only server I can choose is DomainSQLEXPRESS. The issue is when I go down to the "Select or enter a database name" drop down box, I do not see my database listed. I have also made sure in the SQL Server Management Studio that I have given my user all the privileges for the database. I know my explanation is kind of vague, but would anyone know the reason why I would not see my database?
View 3 Replies
Feb 2, 2010
Background: I use SQL server 2005 developer edition and visual studio 2008. Visual studio 2008 is running on a local machine with Vista business edition. SQL server is running on a remote server using Windows server 2003. Both computers are within the same domain.
Problem: First, I used the server explorer to connect to the SQL server. Everything works as desired. Then I write code to do the same thing. I keep getting the following error message:
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: 25 - Connection string is not valid)
However, I used the exactly identical connection string as the one used in the server explorer. So connection string should not be the problem. In addition, I tried the test code in MSDN, which tells whether my domainusername can flow the network. It turns out the user name is fine. I also went to the SQL server management studio and found the login for my computer is NVCWeihao while my computer login name is NVCweihao. I am wondering if this uppercase letter really affects the connection.
View 2 Replies
Jul 11, 2010
Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. make sure the user has a local user profile on the computer. The connection will be closed.
View 1 Replies
Nov 23, 2010
I just installed sql server 2008 R2 on my computer. I am trying to connect to sql server throught my C# code and everytime I run the C# program,
I get this 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) "
The connection string that I used in my web.config file is
[Code]....
I am not sure what am I doing wrong, but I followed this article below step by step and still I am getting the same error
http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/
My instance name is MSSQLSERVER and the server that I am using is on my local machine and it has my computer name in it.
View 10 Replies
Mar 25, 2010
when I make data source configuration wizerd
Data -> Add new data source -> ... -> Save the connection string to the Application configuration file (yes, save the connection) result in "An unexpected error has occured." Error Message; Could not load type
'Microsoft.VisualStudio.DataDesign.SyncDesigner.SyncFacade.SyncManager'from assembly 'Microsoft.VisualStudio.DataDesign.SyncDesigner.DslPackage,Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'.
how I can solve this problem ?
View 3 Replies
Feb 3, 2011
I have created a webservice in 2010. And when I call it from my web application sometimes,It generates the follwoing errors:-1. The underlying connection was closed: A connection that was expected to be kept alive was closed by the server.2. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.I have already tried increasing excutonTimeOut etc.
View 2 Replies
Jan 21, 2010
I dont know my server name, username or password and what do i put in the name section??
I am trying to create it for a data entry page.
View 2 Replies
May 5, 2010
I'm using VS 2010 RTM and SQL Server 2008 on my clean development laptop, running Windows 7 Pro.
Using Visual Studio's Server Explorer, I can easily do an Add Connection by simply right-clicking, and then completing the dialog, and choosing "Use Windows Authentication". I can then click the button "Test Connection".
However, if I wish to do an Add Connection, and then choose "Use SQL Server Authentication", I get a message "Login failed for user 'appSlir'", as shown here:
When I try the same thing on my other development machine, which is VS 2008, SQL Server 2008, and Windows XP Pro, it works fine.
There seems to be a problem/bug that prevents Add Connection with "Use SQL Server Authentication" to SQL Server 2008, when running on Windows 7 Pro.
View 5 Replies
Jul 23, 2010
We're having an error similar to the one detailed here. We get the error noted above when trying to do AD authentication from our .net (3.5) mvc 2 app. This is our first .net mvc app ...
http://forums.asp.net/t/1161047.aspx
- We are re-using a forms auth library written for a .Net 2 app
- that library/app/config used a service account with min. privileges for binding to AD
- This error occurs in VS 2008, have not tried deploying the app to a server yet (a little early for that)
- like the other user at the previously referenced thread, I can get the 'unable to establish ...' error to go away and display the log on page by putting *MY* credentials in instead of the service account (but not successfully authenticate)
- moving the service account into the same AD OU as my account does not seem to change it ... only using my account credentials does.
- trust level is set to full
Is this some odd permissions trick that is new with .Net 3.5 (even though the ADmembershipProvider is still a 2.0 libary)? This should have nothing to do with MVC itself.
Config looks like this (very standard, like every one else's)
[Code]....
The line/portion highlighted in the debug/stacktrace is:
type="System.Web.Security.ActiveDirectoryMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
View 2 Replies
Jun 5, 2010
I previously used a datasource and a connection string to connect to my database on sql server and all orked fine. The connection string was saved in my web.config file and is: ....
View 1 Replies
Jul 23, 2010
I am using VS2008 and oracle 10g ODP.Net. The oracle database that I used in the connection is working and tested it using sql plus.The connection string when used in a GriDView works perfectly. Now when I created a new listview control with the same connection it gives an error.Database schema could not be retrieved for this connection. Please make sure connection settings are correct and the database is online
Object reference not set to an instance of an object at VSDataObjectSupport (478,6)
View 2 Replies
May 26, 2010
I build some website using VS2010. its no problem for me to watch the site by click view in browser from VS but, if i want to send the website folder to someone, and he dont know nothing about VS or programming, how can he use the site
View 7 Replies
May 7, 2015
ExecuteScalar requires an open and available Connection. The connection's current state is closed.
namespace ITS_Group{ public partial class Login : System.Web.UI.Page {
private DataTable GetData(SqlCommand cmd) {
DataTable dt = new DataTable();
String strConnString = System.Configuration.ConfigurationManager.ConnectionStrings[1].ConnectionString;
SqlConnection con = new SqlConnection(strConnString);
[CODE]..
View 1 Replies
May 7, 2015
I can not send mail, this error means ?
Code:
using (MailMessage mm = new MailMessage("soporte@linknred.com", correo1.Text.Trim()))
{
mm.Subject = "Activacion de Cuenta";
string body = "Hola " + correo1.Text.Trim() + ", " + "Bienvenido a LinknRed";
body += "<br /><br />Por Favor haz Click en el Enlace Siguiente Para Activar Tu Cuenta";
[Code] ....
View 1 Replies
Oct 29, 2010
i want to save a IQueryable in cache like this:
[Code]....
However when i try to retreive it and use it i get this error: The ObjectContext instance has been disposed and can no longer be used for operations that require a connection.
View 5 Replies
Apr 7, 2010
How do I specify a port number for a Data Connection in the Server Explorer of Visual Studio 2008. It would use 1433 as a default but the administrators changed it for security purposes.
View 2 Replies
Jan 16, 2011
I used the ASP.net Web Site Administration tool to create a database with two users and two roles. The database created successfully and is showing up in Solution Explorer in the App_Data folder of my project, as expected. The problem is, that when I click on the database I get an error message saying that "SQL Server database files (.mdf) require SQL Server 2005 Express or SQL Server 2008 Express to be installed and running on the local computer." I, in fact, have 3 versions of SQL Server running on my computer. SQL Server Express (default instance), SQL Server Express (named instance for Outlook 2010 Business Contact Manager), and SQL Server 2008 R2 (Developer Edition). If I create a new connection in Server Explorer and then attach the database file, it attaches fine. It's only in Solution Explorer that it somehow is not connecting.
View 1 Replies
Aug 9, 2010
In my web.config I have:
[Code]....
If I just have ADProvider1 it works, when I add ADProvider2, even though for testing I only use ADProvider1 I get an error: "Unable to establish secure connection with the server" Am I adding the second provider to the membership section incorrectly?
View 11 Replies
Jan 18, 2010
i have few folders which has files & some sub folders ----- in another application
i need to add it in current application
without creating the folders/sub folder/subdolder1 is it possible to add all the subfolders as it is using add exixting item
View 1 Replies
Dec 4, 2010
i cant get connection with sourcesafe. when i search for sourcecontrol i get the connection wizard. But when i entering server name and path i got the message 'conneting to internet...' . No result after that.
View 3 Replies
Mar 31, 2011
I used Data Connections to connect a database but couldn't make it.
1. I used Windows Authentication to log on to database, my database's name wasn't displayed in Select or enter a database name dropdown menu, so I enter my database's name then I pressed Test Connection button, it said "This connection can't be tested because the specified database doesn't exist or isn't visible to the specified user."
2. So I used SQL Server Authentication to log on to the server,then I put my database's name in Select or enter a database name dropdown menu box, then press OK it's said that "Login failed for user 'xxx' or Try to press Test Connection button it said that "Login failed for user 'xxx'.
I'm sure that I use a correct username and password and I think it's a problem about VS can't see my database in SQLExpress2008.
View 25 Replies
Mar 10, 2010
i have sql server 2008 and visual studia 2008 install in my system when i open a new website project and then use the asp.net administration tool in that when i go for security tab under that one.
i want to enable roles but it displaying error that unable to connect to sql server database.
View 1 Replies
