Open A Second Connection When The Fist Fail

Mar 28, 2008

Hi, I have a web apllication using asp.net, I have two connectionstrings (cadenaCon and cadenaCon2) in web.config.

<connectionStrings>
  <add connectionString="Server=SUNBOGW-MROMEROSQLEXPRESS;Database=ModulosWebkkk;UID=sa;PWD=martha;"  name="cadenaCon" providerName="System.Data.SqlClient" />
  <add connectionString="Server=SUNBOGW-MROMEROSQLEXPRESS;Database=ModulosWeb;UID=sa;PWD=martha;" name="cadenaCon_bak" providerName="System.Data.SqlClient" />
</connectionStrings>In the class file I have this sub and it works well

Public Sub New()
         conexion = New SqlConnection(ConfigurationManager.ConnectionStrings("cadenaCon").ConnectionString.ToString)
End Sub

My problem is I like to try to connect with cadenaCon and if this connection fails use the other. I used a try but it donÂīt work,

Public Sub New()
   Try
      conexion = New SqlConnection(ConfigurationManager.ConnectionStrings("cadenaCon").ConnectionString.ToString)
   Catch ex As Exception
       Throw New Exception(ex.Message)
        conexion = New SqlConnection(ConfigurationManager.ConnectionStrings("cadenaCon_bak").ConnectionString.ToString)
   Finally
   End Try
End Sub

Please I aprecitate a sugestion. Thanks 

Martha

View 1 Replies


ADVERTISEMENT

OpenRowSet And OpenDataSource Fail On Production To Open Excel Data

Jun 26, 2006

The following statement fails when using SQL Analyzer under sa but works on all of our development and staging server. All are SQL Server 2005 SP1. We upgraded production over the weekend from SQL Server 2000, creating a new instance machinenameSQL2005.

SELECT *

FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=d:data est.xls',

'SELECT * FROM [Sheet1$]')

The error we are getting only in prodcution is:

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Unspecified error".

Msg 7303, Level 16, State 1, Line 1

Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".

Any help seriously appreciated,



Tronn

View 44 Replies View Related

Leave The Connection Open Or Always Open And Close Immediately?

Jun 7, 2006

Hi there,
 
I got an approach like that:
1) Read something from DB - check the value, if true stop if false go on2) Read the second Value (another SQL Statement) - check the value etc.
Now I could open the connection at 1) and if I have to go to 2) I leave the connection open and use the same connection at 2). Is it ok to do that?
The other scenario would be opening a connection at 1), immediately close it after I read the value and open a new connection at 2).
Thanks for the input!

View 4 Replies View Related

How Get Fist Value Of Tabale

Apr 14, 2007

How get Fist Value of tabale

I know how to get min, max value of table I wont Fist Value of tabale PL Help Me

View 1 Replies View Related

Sql Connection Fail

Jul 20, 2005

I had link my 4 of workstations to server with MySql.1 pc of my pc can run a software which can update MsSql perfectly but notothers(3 failed).I tried to add System Dsn data source for Control Panel - Odbc data source32.The pc which working fine with the software function but 3 of the rest not.My pcs running xp and win98 !Regards.Thanks.Leslie Lim

View 5 Replies View Related

ExecuteReader Requires An Open And Available Connection. The Connection's Current State Is Closed.

Apr 26, 2007

I am accessing SQL2005 with C# code using OleDbConnection.



A try and catch block catches the following error once a while between the Open() and Close() of the connection:

ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.



I do not even have any idea where to start to debug this. The ExecuteNonQuery() runs a delete SQL query. It works 99.9% of the time. I do not see anything wrong when this error happens.



Any hint would be greatly appreciated.



View 9 Replies View Related

Database Connection Fail

May 30, 2006

I have got this error below which is similar with what has posted in forum.

SQL_ERROR (-1) in OdbcConnection::connect
sqlstate=28000,
level=-1, state=-1, native_error=18456, msg=[Microsoft][SQL Native
Client][SQL Server]Login failed for user 'sa'.

As i have found its solution in this forum. Here I would like to ask since my Ms SQL server epress set up fail due to the error above, but some of the previous setup is successful. In this case, am I going to run the .exe set up to continue the remaining process or I have to uninstall and install it again?
Thanks.

View 1 Replies View Related

Sql Server 2000 Connection Fail

Jun 18, 2007

Hi group,being pretty new to setting up sql server, I am stuck. Have installed sql 2000 server on Win 2000 server, IIS 5.0. I try to connect via ASP script that looks like this:<%Set Conn = Server.CreateObject("ADODB.Connection")ConStr = "PROVIDER=SQLOLEDB; DATA SOURCE=192.168.1.99"ConStr = ConStr & ";UID=someUser;PWD=somePassword" ConStr = ConStr & ";initial catalog=myDatabaseName;network library=DBMSSOCN"Conn.Open ConStrConn.CloseSet Conn = Nothing%>The IP number is the webserver my router points to on port 80.But get an HTTP 500 error and "The page cannot be displayed"Any suggestions as to what I am doing wrong here, would be very much appreciated.I have run applications for a long time that operate Access databases, but starting a new, an big project, forces me to upgrade to sql databases.Best wishesFCH

View 1 Replies View Related

Using Transactions Causes Database Connection To Fail

Feb 8, 2006

In one of my packages, I set the package-level property called TransactionOption=Required. During run-time I saw an error saying "[Execute SQL Task] Error: Failed to acquire connection "SQL_DW". Connection may not be configured correctly or you may not have the right permissions on this connection. ". When the property is changed to anything other than Required, it works fine (the calling package that calls this package is not involved in a transaction).

The machine running the packages is Windows Server 2003, and so is the database where the data lives. I verified that the machine containing the database does has Enable Network DTC Access checked in Control Panel -> Add/Remove Windows Components -> Application Server.

Is anyone else having this problem?

View 6 Replies View Related

SQL Server 2005 Express Connection Fail. Please Help Me

May 16, 2006

Hi all,

When i attempted to connected to Microsoft SQL Server 2005 Express via ASP.NET 2.0 application, it seems to throw the following error.

I had set up the Protocols for Express (TCP/IP and Named Pipes are both enabled) to allow remote connections using both TCP/IP and named pipes.
Login failed for user ''. The user is not associated with a trusted SQL Server connection.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.

Source Error:







The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:

1. Add a "Debug=true" directive at the top of the file that generated the error. Example:

<%@ Page Language="C#" Debug="true" %>

or:

2) Add the following section to the configuration file of your application:

<configuration>
<system.web>
<compilation debug="true"/>
</system.web>
</configuration>

Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.

Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.


Stack Trace:







[SqlException (0x80131904): Login failed for user ''. The user is not associated with a trusted SQL Server connection.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734883
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
ASP.sqlquerytool_aspx.Button_Click(Object s, EventArgs e) +49
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102



I have been battling with error for 5 solid hours. Please help me

thank you in advance

View 1 Replies View Related

Open An ODBC Connection To A DB And Must Use A Connection That Looks Like This: DSN=myDSNname.

Dec 11, 2006

In my ssis package,

I have a DSN connection like this: "DSN=myDSNname". Which decide from i have to pull the data.

By using OLE DB Source Editor, I want to assign that ODBC Connection to it.

By data source Reader i can achive this but where i have to pass the hard-code SQL Query that i don't want.

i'm using the variable for dynamic SQL command.

Thanks.

Manoj

View 5 Replies View Related

SQL 2012 :: SSIS - Network Map - Connection Manager Fail

Mar 14, 2014

I am running SQL Server 2012 on a VM and am trying to pull data from a network drive (S: or misvnascfs0003).I can import data using the Import Wizard and save the package as an SSIS package. When I try to Run the Package I get The Acquire Connection method call to the connection manager "SourceConnectionExcel" failed with the error...

If I save the file to the VM local drive the SSIS package run fine.When I log into SSIS through SSMS i have to run as "Administrator".

View 2 Replies View Related

Changing 'initial Catalog' On Connection Causes Analysis Services Processing Task To Fail

May 2, 2008

We find that if we deploy the OLAP database with a different name on the test server, then regardless of how we change the connection string provided to the SSIS package that processes the cube, then the package fails to connect to the database. To clarify:

In development the OLAP database is called MyOlapDB and the source database is called MySqlDB. Both are on the same machine. When the the application is built and released for test, the test team install the databases on a replica of the production environment (i.e. web app on one machine, OLAP DB on another and SQL database on yet another). They also, quite rightly, implement the new test databases so they incorporate the build version number. So, MyOlapDB123 and MySqlDB123 are both from build 123.

This is when the problems start. Regardless of how the connection string is specified in the job that processes the cube, the SSIS integration package fails with the error:

[Analysis Services Execute DDL Task] Error: Errors in the metadata manager. Either the database with the ID of 'MyOlapDB' does not exist in the server with the ID of 'OurTestServer', or the user does not have permissions to access the object.


We have tried config files and job properties, but neither work. Also, simply attempting to run the package using the DTEXECUI does not work either.

Looking inside the XML of the package, we clearly see the ConnectionManager object which has the original connection string, which is

Data Source=localhost;Initial Catalog=MyOlapDB;Provider=MSOLAP.3;Integrated Security=SSPI;Impersonation Level=Impersonate;


However, editing the initial catalog here still does not solve the problem. Searching the XML for the string MyOlapDB reveals the OLAP database name in two other places - both within the object data of the two Analysis Services Execute DDL tasks.

Anyone know how to solve this problem without having to hack the XML of the package?

View 4 Replies View Related

Error While Establishing A Connection To The SQL Server 2005 - Could Not Open A Connection To SQL Server

Apr 12, 2007

Hi, I had an old web application created during asp.net 1.1 and it have a connection problem with the sql server 2005 when it is mirgrated to a new webserver with dotnet framework 2.0 platform. I have enabled the remote access(TCP/IP and named pipes) in sql server 2005, did all the neccessary things, check whether the TCP/IP is enabled, named pipe is enabled...  I created another web application using VS 2005. The database connection works perfectly well.This are the connectionString from the old web application.<appSettings>    <add key="ConnectionString" value="Server=127.0.0.1;Database=somedb;User id=user; Password=somepassword; Trusted_Connection=False; POOLING=FALSE"/></appSettings>  Thankyou in advance! 

View 4 Replies View Related

Open Connection

Nov 1, 2007

Hello everybody I would like to know more about the number of possible connection to a sql server is it by pool ? or there is max for all the database ? all the server ? how I can get the number of connection open ? Thx in advance 

View 2 Replies View Related

Could Not Open Sql Connection

Sep 22, 2007



Hi,
I hope this is right place to ask for help.If it is not, Please show me where and if it is please Help me
I using Window Vista bussiness, Microsoft visual 2005 professional edition, Microsoft SQL server express edtion
I have created table on Database.
My sql server name is KYAW-HQ
**but in the bar it shown like as KYAW-HQSQLEXPRESS
My data base name is kyaw
I have already Enabled Name Pipes and TCP/IP setting in sql studio management tool express
I using window authentication to log in to sql server management studio express.

My coding for c# is as follow:


private void button4_Click(object sender, EventArgs e)

{

//connect sql connection

SqlConnection con = new SqlConnection("Server=KYAW-HQ;Database=kyaw;UID=;PWD=;");

//open sql conection

con.Open();

SqlDataAdapter ad = new SqlDataAdapter("Select * From kyaw", con);

DataSet ds = new DataSet();

ad.Fill(ds, "kyaw");

dataGridView1.DataSource = ds.Tables[0].DefaultView;

con.Close();





}



After I click the button the error has shown like below

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).

Please tell me what i have to do.
If someone read me, please tell me and advice me how to fix above problem.
Thanks

View 9 Replies View Related

Cannot Open SQL Connection

Jan 22, 2008

Hello!

This code sample stops when I try to open a connection (see below). Ther error message reads "pipe provider , error 40". The help suggests that the credentials are wrong. I donīt think so, could there be another problem? Tough question but, I would appreciate any help.


System.Data.SqlClient.SqlConnection sqlConnection1 =

new System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings["SwimAdminConnectionString"].ConnectionString);



System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();

cmd.CommandType = System.Data.CommandType.Text;

string sql1 = Session["txtFirstName"].ToString();

string sql2 = Session["txtLastName"].ToString();

cmd.CommandText = "INSERT dbo.Member (mbrFirstName, mbrLastName) VALUES (sql1, sql2)";

cmd.Connection = sqlConnection1;

sqlConnection1.Open(); //EXCEPTION HERE!!!

cmd.ExecuteNonQuery();

sqlConnection1.Close();

View 26 Replies View Related

Could Not Open A Connection To SQL Server

Nov 25, 2007

Hi, Has somebody had a problem like this before? Exception Details: 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) That's part of the code:        SqlConnection con;        string sql;        SqlCommand cmd;               con=new SqlConnection("Data Source=elf/SQLEXPRESS;Initial Catalog=logos;Integrated Security=SSPI;");        sql="SELECT max(id_kandydat) from Kandydat";        con.Open();         cmd=new SqlCommand(sql,con);        int id = Convert.ToInt32(cmd.ExecuteScalar());        con.Close();         SqlDataSource7.InsertCommand="INSERT INTO Kandydat_na_Kierunek(id_kandydat, id_kierunku, id_stan) VALUES ("+"'"+id+"'"+","+"'"+DropDownList1.SelectedValue+"'"+","+'1'+");";  I don't really get it. I'm nearly 100% sure that before some changes in my project this had worked perfectly. Does anybody have any idea how to make it work again? I would be very grateful for any help. And, yesy, I know it is quite common error, but proposed solution found didn't help.Regards,N.  

View 5 Replies View Related

Leave DB Connection Open

Mar 20, 2008

Hello, I have always closed my db connections asap after opening them and have always thought this was the best practice.  But now I am wondering if I can just leave the connection open.
I created a windows service which runs on a timer and executes every 5 seconds.  The problem is that the code takes longer than that to process and the code may be executing three times at once. Im worried that since I use the same connection each time the code executes that a connection opened by the first run through may be closed or reopened by the second or third running of the code resulting in an error.  The connection is opened and closed about 10 times each time the timer event fires.  Should I open the connection once and leave it open when the service is started and close it when it is stopped or on any error?
 
Thanks

View 2 Replies View Related

Could Not Open A Connection To SQL Server

Jun 3, 2008

i m getting this exception
"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)"
i want to know that this exception is from my end or on Server End. because 5 to 6 month my application works fine but in these days i m getting this exception 5 to 20 times a day
your help will really appricate...
 

View 5 Replies View Related

How Trace That Where The Connection Is Open

Jun 14, 2006

hi to all,
I create a web application in asp.net with sql server 2000, I use always close connection in .net code as my consern but when run my application then visit page to page give a error "General network error " message . then i check lots of connection is sleeping state in process info in sql manegment(current activity) Now i open the particular processId in Process info show open connection with any storeprocedure name and show .net sqlclient data provoider referance as open connection which is fetch the data from sql then i check in code find really the connection which is got data by that store procedure is not close properly and i close it. This is ok but one problem is that some procesId show  blank info with .net sql client data provoider. so how can i find where these conneciton is open in my applicaton because this processId doesn't give any clue for it , it show nothing only blank but status is sleeping. If any help have this context then quick feedback.
Thanks

View 2 Replies View Related

Could Not Open A Connection To SQL Server

Feb 20, 2006

Hi,

One issue has got me stuck while getting to build an application(ASP.NET/SQLSERVER). Whenever I try to connect to SQL Server 2005 (installed on local host) using Visual Web Developer 2005 Databse Explorer, I get the following error message:

"An error has occured while establishing a connection to the server.
when connection 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)"


NB:
- on SQL Servers' Surface Area Configuration, Remote connections are set to "Local and Remote connnections" and "Using both TCP/IP and named pipes".

ANyone with a solution? pse help

View 3 Replies View Related

Error: 40 - Could Not Open A Connection

May 8, 2007

I am developing a web service that uses a sql data connection.



The sql database is on a server, and the development version of my web service is on my pc.



I can connect/access the data accross my network when I run the service on my PC, but as soon as I put the web service onto the server(with the sql) it displays, the service wont function - error: 40 - could not open a connection....



I presume that sql is configured correctly as I am recieving data back when I request it accross the network. I dont understand why it wont work when I have the service on the server with the sql?



Any help will be appreciated.



View 4 Replies View Related

Could Not Open A Connection To SQL Server

Jan 25, 2008

tried to install SQL Server 2005 in a fresh installed Windows 2003 SP2. And this server is a workgroup member, not a member of a domain.

The services (Database service, integration service, reporting services and so on) work fines, but I could not connect to server

I checked the log, I found the following error,error :40-Could not connect to SQL Server(Microsoft SQL Server,Error-1231).


I never had this problem and this time, I really got the trouble and do not have solution.

Who have ever encounter this problem? Or someone can help me?

Thanks.

View 1 Replies View Related

Open A DSN Connection In TSQL

Sep 21, 2006

I'm trying to update an SQL DB from data in Quickbooks. I am trying to find if I can open a dsn connection in a stored procedure, called from an ASP page, to the quickbooks db using odbc. The driver I have for odbc does not allow for linked servers. I'm very new to stored procedures and such so please bear with me. Thxs.

View 3 Replies View Related

Connection.Open(); Problem

Apr 17, 2008

hello ,i write this code
string sql="SELECT * FROM Customers";
SqlConnection connection = CollectionManager.getHotelConnection();
SqlCommand command = new SqlCommand(sql,connection);
command.CommandType = CommandType.Text;
command.ExecuteNonQuery();
result = command.ExecuteScalar();
connection.Open();
...
and when the debug goes to
connection.Open ()
it throws me this

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)

but i have all enabled ,browser running normally ,name pipes tcp ip enable all ,but it makes me this thsi all the time what mayb e huppens there?

View 4 Replies View Related

How To Open A Second Connection While In A Datareader

Dec 13, 2007



Hi,

I hope someone can help me with this.

I have created a data reader to loop thru a table and build an update statement.
Now I need to execute this statement in the datareader loop but the connection object is in use.

I tried creating another connection object but get an error:
"The context connection is already in use."

Is there a way to open another connection while the main context connection is open.
Just to make it clear, I do not want to read all the rows into memory first and then call update, it has to
happen for each iteration of the datareader.

Thanks.
--
With Regards
Shailen Sukul
Software Architect/Developer/Consultant
(BSc | Mcts (Biztalk (IP)) | Mcpd | Mcts (Web, Win, Dist Apps) | Mcsd.NET | Mcsd | Mcad)
Ashlen Consulting Services Pty Ltd
(http://www.ashlen.com.au)
MSN | Skype | GTalk Id: shailensukul
Ph: +61 0421 277 812
Fax: +61 3 9011 9732
Linked In: http://www.linkedin.com/in/shailensukul

View 7 Replies View Related

Open Connection In Sql Server

Feb 9, 2006

Try
Dim l_connString As String

l_connString = "Server=kangalert;database=Order;user id=sa;password=123;"
m_cn = New SqlConnection(l_connString)
m_cn.Open()

Catch ex As SqlException
Dim l_sqlerr As SqlError
For Each l_sqlerr In ex.Errors
MsgBox(l_sqlerr.Message)
Next
End Try



i got this in my mobile application, which try to open a connection directly to the sql server, but i got the following message

General Network error, check your network documentation.

View 7 Replies View Related

Server Error While Trying To Open Connection

Feb 12, 2007

Hi,
I've created an "ASP.NET Web Application" project in Visual Studio and I want to simply open a connection to a database in SQL Server. All I have done is adding these 3 lines below without modifying any other generated codes by Visual Studio.(I've done this within code behind in Page_Load() not by <script> tag within HTML code)
public class WebForm1 : System.Web.UI.Page {   private void Page_Load(object sender, System.EventArgs e)  {   // Put user code to initialize the page here   SqlConnection c = new SqlConnection();   c.ConnectionString = "workstation id=BABAK;integrated security=SSPI;initial catalog=db1;persist security info=False";   c.Open();  }  ...   }
But I get this error :
Server Error in '/projects/fortest/tDB2' Application.--------------------------------------------------------------------------------
Login failed for user 'BABAKASPNET'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'BABAKASPNET'.
Source Error:
Line 24:    SqlConnection c = new SqlConnection();Line 25:    c.ConnectionString = "workstation id=BABAK;integrated security=SSPI;initial catalog=db1;persist security info=False";Line 26:    c.Open();Line 27:   }Line 28:  Source File: c:inetpubwwwrootprojectsfortest db2webform1.aspx.cs    Line: 26
What's wrong ?

View 2 Replies View Related

Error: 40 - Could Not Open A Connection To SQL Server

Jul 11, 2007

I posted this on the Dotnetnuke forums but no answer for it, so since it is a SQL error I guess maybe someone here might know. 
I installed the core forum that comes with the installation, the page runs great until I add the forum module.
I get this error:





A critical error has occurred.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)
The portal is in godaddy if this can help.
Thanks,
Erick

View 1 Replies View Related

Failed To Open A Connection To The Database

Nov 21, 2007

Hello,



          I receive
this error when choosing the data connection in TableAdapter Wizard for me to
reference the ASPNETDB.mdf database.



Failed to open a connection to the database









"The header for file
'C:InetpubwwwrootWebsites4App_DataASPNETDB.MDF is not valid databasefile header. The FILE SIZE property is incorrect.An attempt to attach an auto-named database exists, or
specified file cannotbe opened, or it is located on UNC share."

Check the connection and try again.







 I already have the connection at config but the error
persists. 













... 
<connectionStrings>    <add
name="ConnectionString1" connectionString="Data
Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|mydatabase.mdf;Integrated
Security=True"providerName="System.Data.SqlClient" />    <add
name="ASPNETDBConnectionString1" connectionString="DataSource=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ASPNETDB.MDF;Integrated
Security=True" providerName="System.Data.SqlClient" /> 
</connectionStrings>  <system.web>...  cheers,imperialx 

View 2 Replies View Related

Error: 40 - Could Not Open A Connection To SQL Server

Feb 7, 2008

hI I have a website which is on a web server owned by another companyI have webpages which should connect from the web server to sql server 2000 which is based at my companyhowever I am getting the error messageAn 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) When the website was on citrix it connected fine, however once it has moved to a web server it does notI have checked and tcp/ip and named pipes are both enabled any1 any ideasthanks in advance!! :-)  

View 13 Replies View Related

Error 40: - Could Not Open A Connection To Sql Server

Apr 19, 2008

HiI am connecting to an external web server running sql 2005 absolutly fine when testing a site using my localhost on my laptop.  How ever, when i deploy the site to my server i get the error 40 code - the external database its trying to connect to is on a different server to both my own localhost and my own server.here is my connection string from my web.config: <add name="plightConnectionString" connectionString="Data Source=111.222.333.444;Initial Catalog=plight;Persist Security Info=True;User ID=xxxxxxx;Password=xxxxxxxx;" providerName="System.Data.SqlClient" />  I've googled the error but all answers require alterations to the server where the sql database is installed, and it works from my localhost anyway - is there anything i need to do to my own server which is running the website?  Regards 

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved