Database Name Changed but code behind still looks at old database name

Question

1.11/5 (2 votes)

See more:

Hi i wonder if anyone can assist me.

we previously had a web page that was published . but now due to increase the database name was changed.

i have changed the name in the datasource in code behind but it still looks at the old database.
is there any other place where it must be changed as well? i have removed the code and redid it but it still looks at old database name.

the database name was changed from Credit_reject to REJECTS

the error is login failed for database Credit_reject

VB

Dim connections As String = "Data Source=INTRA1\INTRA;Initial Catalog=REJECTS;User ID=sa;Password=*******;Pooling=False"
       Dim mycon As New SqlConnection(connections)

       mycon.Open()
       Dim insrtcom As New SqlCommand
       insrtcom.CommandText = ("insert into CREDIT_REJECTS(Acc_Num, ACC_NAME,ORDERNUM,RCV_NO,TRAY_NO,SLIPNO,DATE,REASON,OTHER_REASON,OPERATOR) values (@Acc_Num,@ACC_NAME,@ORDERNUM,@RCV_NO,@TRAY_NO,@SLIPNO,@DATE,@REASON,@OTHER_REASON,@OPERATOR)")
       insrtcom.Parameters.AddWithValue("@Acc_Num", DropDownList1.SelectedItem.Text)
       insrtcom.Parameters.AddWithValue("@ACC_NAME", DropDownList1.SelectedValue)
       insrtcom.Parameters.AddWithValue("@ORDERNUM", TextBox6.Text)
       insrtcom.Parameters.AddWithValue("@RCV_NO", TextBox2.Text)
       insrtcom.Parameters.AddWithValue("@TRAY_NO", TextBox3.Text)
       insrtcom.Parameters.AddWithValue("@SLIPNO", TextBox5.Text)
       insrtcom.Parameters.AddWithValue("@DATE", lbldate.Text)
       insrtcom.Parameters.AddWithValue("@REASON", DropDownList2.SelectedItem.Text)
       insrtcom.Parameters.AddWithValue("@OTHER_REASON", TextBox4.Text)
       insrtcom.Parameters.AddWithValue("@OPERATOR", DropDownList3.SelectedValue)
       insrtcom.Connection = mycon
       insrtcom.ExecuteNonQuery()
       mycon.Close()
       mycon.Dispose()
       lblinserted.Text = " 1 Row Inserted"

Posted 22-Jul-13 1:06am

Member 9742322

Add a Solution

Comments

ArunRajendra 22-Jul-13 7:20am

Try after restarting your webserver. Aldo try to restart worker process asp_wp.exe. This you can do by restarting the application pool.

Member 9742322 22-Jul-13 7:31am

hi i have not published after changing the datasource this is still in the testing phase. if i changed it in code behind should i change it anywhere else as well.

ArunRajendra 22-Jul-13 8:37am

No

ZurdoDev 22-Jul-13 8:47am

I doubt the error is in this code. The error is likely somewhere else.

Member 9742322 22-Jul-13 8:49am

i have in the asp side 3 sqldatasource which i changed there and those work perfect.
i will redo the page and see if it resolves the error as i cant see why it it doing that
thank you for all the help

ZurdoDev 22-Jul-13 9:05am

Ya, I don't see it either. Perhaps you are getting build errors? Just do a build and see if there are no errors. Or else, put a breakpoint and make sure it is actually this code that is failing. If you look at the stack trace it likely is not the code you have posted.

Member 9742322 22-Jul-13 9:20am

this is the error.
Cannot open database "CREDIT_REJECT" requested by the login. The login failed.
Login failed for user 'sa'. that is the old database and then in the source error
Line 33: insrtcom.Parameters.AddWithValue("@SLIPNO", TextBox5.Text)
Line 34: insrtcom.Parameters.AddWithValue("@DATE", lbldate.Text)
Line 35: insrtcom.Parameters.AddWithValue("@REASON", DropDownList2.SelectedItem.Text)
Line 36: insrtcom.Parameters.AddWithValue("@OTHER_REASON", TextBox4.Text)
Line 37: insrtcom.Parameters.AddWithValue("@OPERATOR", DropDownList3.SelectedValue) it fails at line 35 which doesn't make sense

ZurdoDev 22-Jul-13 9:50am

But why add line 33? Line 32 is adding a parameter, the error can't happen there. Look at the stack trace.

Member 9742322 22-Jul-13 9:56am

hi sorry this is very confusing for me below is the stack trace which doesn't make sense to me

[SqlException (0x80131904): Cannot open database "CREDIT_REJECT" requested by the login. The login failed.
Login failed for user 'sa'.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4876455
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1121
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +35
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +144
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +367
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +225
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +189
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +185
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +29
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +4891644
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117
System.Data.SqlClient.SqlConnection.Open() +122
Credit_reject.Insert.btnRcdinsert_Click(Object sender, EventArgs e) in C:\Users\kreyneke\Documents\Visual Studio 2008\Projects\Credit_reject\Credit_reject\Insert.aspx.vb:35
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

ZurdoDev 22-Jul-13 10:01am

Credit_reject.Insert.btnRcdinsert_Click(Object sender, EventArgs e) in C:\Users\kreyneke\Documents\Visual Studio 2008\Projects\Credit_reject\Credit_reject\Insert.aspx.vb:35

Member 9742322 22-Jul-13 10:12am

even if i comment that section out to just run the code that follows it still gets stuck at that part i will redo the page because it must be looking at something else in the background

ZurdoDev 22-Jul-13 10:14am

Right. It isn't the code that you posted. that is my point. Perhaps you have a SQL Datasource in the aspx part of your page. Just do a search in your solution for credit_reject or whatever the old db name is.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)