Connection string error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

ASP.NET

Connection string error

Author

Topic

Potso6767
Starting Member

18 Posts

Posted - 2008-03-18 : 15:30:26

Can someone please help me with this. We have recently moved a sql database and a custom made apps connection string needs to be fixed in order to work. The connection string now needs to be pointed to a sql instance.

below is the connection string

<add key="ConnectionString" value="server=acctg-sql;database=Intranet;uid=********password=*********" />

When the App runs this is the error that I recieve. Can anyone think of anything that could be wrong?

[SIZE="4"][SIZE="4"]Exception Details: System.Data.SqlClient.SqlException: Named Pipes Provider: Could not open a connection to SQL Server [2]. OLE DB provider "SQLNCLI" for linked server "(null)" returned message "Invalid connection string attribute".[/SIZE]

Also here is the stack trace

System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742
System.Data.SqlClient.SqlCommand.ExecuteReader() +41
POCS.vacation_calendar.Get_DBItems() in c:\inetpub\wwwroot\tors\vacation_calendar.aspx.vb:240
POCS.vacation_calendar.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\tors\vacation_calendar.aspx.vb:80
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750

This is ran in a asp.net 1.0 app that has a VB back end... can anyone help me please

jubinjose
Starting Member

20 Posts

Posted - 2008-03-20 : 01:40:23

Wjat is the instance name? You might want to plug that into the connection string
If it is XYZ, then

<add key="ConnectionString" value="server=acctg-sql\XYZ,1433;database=Intranet;uid=********password=*********" />

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-03-21 : 02:56:39

see this
www.connectionstrings.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources