|
|
You're in the
sql server programming
group:MSDE, ASP.NET, Visual Studio .NET, and connectionstrings
sql server programming:
have created an empty database using Visual Studio .NET's Server Explorer. However, I am having trouble connecting to the database using ASP.NET. I think the problem is somewhere in my connection string, but because I do not know much about connection strings, I am not sure what it should look like. Can someone please help me determine what my connection string should look like? I am using the version of IIS that comes with XP Pro. Thanks. -- Nathan Sokalski njsokalski@hotmail.com http://www.nathansokalski.com/
1. Create at least one empty table in that database, using the Server Explorer. 2. Use the Server Explorer's "Add Connection" wizard ( right-click "Data Connections" ) to create a connection. 3. The connection string will be created for you. 4. Right-click the created connection and select Properties. 5. Copy the connection string from the "Properties" box. Juan T. Llibre ASP.NET MVP http://asp.net.do/foros/ Foros de ASP.NET en Español Ven, y hablemos de ASP.NET... ====================== [quoted text, click to view] "Nathan Sokalski" <njsokalski@hotmail.com> wrote in message news:e7ceEVEeFHA.3712@TK2MSFTNGP09.phx.gbl... >I have Visual Studio .NET and SQL Server Desktop Engine on my computer. I > have created an empty database using Visual Studio .NET's Server Explorer. > However, I am having trouble connecting to the database using ASP.NET. I > think the problem is somewhere in my connection string, but because I do not > know much about connection strings, I am not sure what it should look like. > Can someone please help me determine what my connection string should look > like? I am using the version of IIS that comes with XP Pro. Thanks. > -- > Nathan Sokalski > njsokalski@hotmail.com > http://www.nathansokalski.com/ > > >
I have tried that, but the connectionstring that is created has plenty of
stuff in it that gives me errors. For example: Server Error in '/PAPresenters' Application. -------------------------------------------------------------------------------- Keyword not supported: 'provider'. 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.ArgumentException: Keyword not supported: 'provider'. Source Error: Line 28: Line 29: Private Sub btnExecute_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnExecute.Click Line 30: Dim myconnection As New System.Data.SqlClient.SqlConnection("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=papresenters;Data Source=NJS;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=NJS;Use Encryption for Data=False;Tag with column collation when possible=False") Line 31: Dim cmdTesting As New System.Data.SqlClient.SqlCommand Line 32: Dim dataadapter As New System.Data.SqlClient.SqlDataAdapter Source File: c:\inetpub\wwwroot\PAPresenters\DBtest.aspx.vb Line: 30 Stack Trace: [ArgumentException: Keyword not supported: 'provider'.] System.Data.Common.DBConnectionString.ParseInternal(Char[] connectionString, UdlSupport checkForUdl, NameValuePair& keychain) +1133 System.Data.Common.DBConnectionString..ctor(String connectionString, UdlSupport checkForUdl) +114 System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) +13 System.Data.SqlClient.SqlConnectionString.ParseString(String connectionString) +96 System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) +11 System.Data.SqlClient.SqlConnection..ctor(String connectionString) +158 PAPresenters.DBtest.btnExecute_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\PAPresenters\DBtest.aspx.vb:30 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain() +1292 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032 Although I don't know much about connectionstrings, the little bit of experience I have leads me to think that the connectionstring generated by Visual Studio .NET has a lot more stuff in it than necessary, but either way it is not working. Why is this, and how can I fix it? Thanks. -- Nathan Sokalski njsokalski@hotmail.com http://www.nathansokalski.com/ [quoted text, click to view] "Juan T. Llibre" <nomailreplies@nowhere.com> wrote in message news:e8E%23LaEeFHA.1136@TK2MSFTNGP12.phx.gbl... > > 1. Create at least one empty table in that database, > using the Server Explorer. > > 2. Use the Server Explorer's "Add Connection" wizard > ( right-click "Data Connections" ) to create a connection. > > 3. The connection string will be created for you. > > 4. Right-click the created connection and select Properties. > > 5. Copy the connection string from the "Properties" box. > > > > > Juan T. Llibre > ASP.NET MVP > http://asp.net.do/foros/ > Foros de ASP.NET en Español > Ven, y hablemos de ASP.NET... > ====================== > > "Nathan Sokalski" <njsokalski@hotmail.com> wrote in message > news:e7ceEVEeFHA.3712@TK2MSFTNGP09.phx.gbl... >>I have Visual Studio .NET and SQL Server Desktop Engine on my computer. I >> have created an empty database using Visual Studio .NET's Server >> Explorer. >> However, I am having trouble connecting to the database using ASP.NET. I >> think the problem is somewhere in my connection string, but because I do >> not >> know much about connection strings, I am not sure what it should look >> like. >> Can someone please help me determine what my connection string should >> look >> like? I am using the version of IIS that comes with XP Pro. Thanks. >> -- >> Nathan Sokalski >> njsokalski@hotmail.com >> http://www.nathansokalski.com/ >> >> >> > >
It looks like you selected the wrong provider when creating the connection.
You should select the ".NET Framework Data Provider for SQL Server" for a provider. Try it using that provider. You should get a correct string if you do. If you still have problems, try a simpler connection string : "Server=NJS;Integrated Security=True;Database=papresenters" That assumes that your MSDE's instance name is "NJS" and that your database name is "papresenters". Juan T. Llibre ASP.NET MVP http://asp.net.do/foros/ Foros de ASP.NET en Español Ven, y hablemos de ASP.NET... ====================== [quoted text, click to view] "Nathan Sokalski" <njsokalski@hotmail.com> wrote in message news:esCnY4EeFHA.1404@TK2MSFTNGP09.phx.gbl... >I have tried that, but the connectionstring that is created has plenty of stuff in it >that gives me errors. For example: > > > > Server Error in '/PAPresenters' Application. > -------------------------------------------------------------------------------- > > Keyword not supported: 'provider'. > 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.ArgumentException: Keyword not supported: 'provider'. > > Source Error: > > Line 28: > Line 29: Private Sub btnExecute_Click(ByVal sender As System.Object, ByVal e As > System.EventArgs) Handles btnExecute.Click > Line 30: Dim myconnection As New > System.Data.SqlClient.SqlConnection("Provider=SQLOLEDB.1;Integrated > Security=SSPI;Persist Security Info=False;Initial Catalog=papresenters;Data > Source=NJS;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation > ID=NJS;Use Encryption for Data=False;Tag with column collation when possible=False") > Line 31: Dim cmdTesting As New System.Data.SqlClient.SqlCommand > Line 32: Dim dataadapter As New System.Data.SqlClient.SqlDataAdapter > > Source File: c:\inetpub\wwwroot\PAPresenters\DBtest.aspx.vb Line: 30 > > Stack Trace: > > [ArgumentException: Keyword not supported: 'provider'.] > System.Data.Common.DBConnectionString.ParseInternal(Char[] connectionString, > UdlSupport checkForUdl, NameValuePair& keychain) +1133 > System.Data.Common.DBConnectionString..ctor(String connectionString, UdlSupport > checkForUdl) +114 > System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) +13 > System.Data.SqlClient.SqlConnectionString.ParseString(String connectionString) +96 > System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) +11 > System.Data.SqlClient.SqlConnection..ctor(String connectionString) +158 > PAPresenters.DBtest.btnExecute_Click(Object sender, EventArgs e) in > c:\inetpub\wwwroot\PAPresenters\DBtest.aspx.vb:30 > System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108 > > System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String > eventArgument) +57 > System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String > eventArgument) +18 > System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 > System.Web.UI.Page.ProcessRequestMain() +1292 > > > > -------------------------------------------------------------------------------- > Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET > Version:1.1.4322.2032 > > > > Although I don't know much about connectionstrings, the little bit of experience I have > leads me to think that the connectionstring generated by Visual Studio .NET has a lot > more stuff in it than necessary, but either way it is not working. Why is this, and how > can I fix it? Thanks. > -- > Nathan Sokalski > njsokalski@hotmail.com > http://www.nathansokalski.com/ > > "Juan T. Llibre" <nomailreplies@nowhere.com> wrote in message > news:e8E%23LaEeFHA.1136@TK2MSFTNGP12.phx.gbl... >> >> 1. Create at least one empty table in that database, >> using the Server Explorer. >> >> 2. Use the Server Explorer's "Add Connection" wizard >> ( right-click "Data Connections" ) to create a connection. >> >> 3. The connection string will be created for you. >> >> 4. Right-click the created connection and select Properties. >> >> 5. Copy the connection string from the "Properties" box. >> >> >> >> >> Juan T. Llibre >> ASP.NET MVP >> http://asp.net.do/foros/ >> Foros de ASP.NET en Español >> Ven, y hablemos de ASP.NET... >> ====================== >> >> "Nathan Sokalski" <njsokalski@hotmail.com> wrote in message >> news:e7ceEVEeFHA.3712@TK2MSFTNGP09.phx.gbl... >>>I have Visual Studio .NET and SQL Server Desktop Engine on my computer. I >>> have created an empty database using Visual Studio .NET's Server Explorer. >>> However, I am having trouble connecting to the database using ASP.NET. I >>> think the problem is somewhere in my connection string, but because I do not >>> know much about connection strings, I am not sure what it should look like. >>> Can someone please help me determine what my connection string should look >>> like? I am using the version of IIS that comes with XP Pro. Thanks. >>> -- >>> Nathan Sokalski >>> njsokalski@hotmail.com >>> http://www.nathansokalski.com/ >>> >>> >>> >> >> > >
Hello Nathan,
Try the following connection string "Driver={SQL Server};Server=127.0.0.1;Database=<database>;Uid=sa;Pwd=;"enter the name of the database, the user and the password in the appropriate places.This info will most likely go in your web.config. The following is a great site forconnection strings http://www.connectionstrings.com/-- IIS Guruhttp://www.iisassistance.com [quoted text, click to view] "Nathan Sokalski" <njsokalski@hotmail.com> wrote in message news:e7ceEVEeFHA.3712@TK2MSFTNGP09.phx.gbl... >I have Visual Studio .NET and SQL Server Desktop Engine on my computer. I > have created an empty database using Visual Studio .NET's Server Explorer. > However, I am having trouble connecting to the database using ASP.NET. I > think the problem is somewhere in my connection string, but because I do > not > know much about connection strings, I am not sure what it should look > like. > Can someone please help me determine what my connection string should look > like? I am using the version of IIS that comes with XP Pro. Thanks. > -- > Nathan Sokalski > njsokalski@hotmail.com > http://www.nathansokalski.com/ > > >
I think I am now passed the problem of the connectionstring, but am
recieving a login failed error, as follows: Server Error in '/PAPresenters' Application. -------------------------------------------------------------------------------- Login failed for user 'NJS\ASPNET'. 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 'NJS\ASPNET'. Source Error: Line 33: cmdTesting.CommandText = txtSQLStatement.Text Line 34: cmdTesting.Connection = myconnection Line 35: myconnection.Open() Line 36: cmdTesting.ExecuteNonQuery() Line 37: myconnection.Close() Source File: c:\inetpub\wwwroot\PAPresenters\DBtest.aspx.vb Line: 35 Stack Trace: [SqlException: Login failed for user 'NJS\ASPNET'.] System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474 System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372 System.Data.SqlClient.SqlConnection.Open() +384 PAPresenters.DBtest.btnExecute_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\PAPresenters\DBtest.aspx.vb:35 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain() +1292 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032 I create my connection as follows: Dim myconnection As New System.Data.SqlClient.SqlConnection("Data Source=NJS;Initial Catalog=papresenters;Integrated Security=SSPI;") I did not create a username or password when I created the database. I know what the user ASPNET is, so do I just need to include that somewhere in the connectionstring? If I do, do I need to include a password along with it? If so, what would this password be (my windows password?)? Thanks again. -- Nathan Sokalski njsokalski@hotmail.com http://www.nathansokalski.com/ [quoted text, click to view] "Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message news:uGxpiZEeFHA.1044@TK2MSFTNGP10.phx.gbl... > http://www.connectionstrings.com/ > > -- > -------------------------------- > Mike Epprecht, Microsoft SQL Server MVP > Zurich, Switzerland > > IM: mike@epprecht.net > > MVP Program: http://www.microsoft.com/mvp > > Blog: http://www.msmvps.com/epprecht/ > > "Nathan Sokalski" <njsokalski@hotmail.com> wrote in message > news:e7ceEVEeFHA.3712@TK2MSFTNGP09.phx.gbl... >>I have Visual Studio .NET and SQL Server Desktop Engine on my computer. I >> have created an empty database using Visual Studio .NET's Server >> Explorer. >> However, I am having trouble connecting to the database using ASP.NET. I >> think the problem is somewhere in my connection string, but because I do >> not >> know much about connection strings, I am not sure what it should look >> like. >> Can someone please help me determine what my connection string should >> look >> like? I am using the version of IIS that comes with XP Pro. Thanks. >> -- >> Nathan Sokalski >> njsokalski@hotmail.com >> http://www.nathansokalski.com/ >> >> >> > >
http://www.connectionstrings.com/
-- -------------------------------- Mike Epprecht, Microsoft SQL Server MVP Zurich, Switzerland IM: mike@epprecht.net MVP Program: http://www.microsoft.com/mvp Blog: http://www.msmvps.com/epprecht/ [quoted text, click to view] "Nathan Sokalski" <njsokalski@hotmail.com> wrote in message news:e7ceEVEeFHA.3712@TK2MSFTNGP09.phx.gbl... >I have Visual Studio .NET and SQL Server Desktop Engine on my computer. I > have created an empty database using Visual Studio .NET's Server Explorer. > However, I am having trouble connecting to the database using ASP.NET. I > think the problem is somewhere in my connection string, but because I do > not > know much about connection strings, I am not sure what it should look > like. > Can someone please help me determine what my connection string should look > like? I am using the version of IIS that comes with XP Pro. Thanks. > -- > Nathan Sokalski > njsokalski@hotmail.com > http://www.nathansokalski.com/ > > >
Don't see what you're looking for? Try a search.
|
January 2003
March 2003
April 2003
May 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
April 2008
August 2008
| home · blog · groups | Questions? Comments? Contact the dn |