free asp.net web hosting


Login         Members       Shared Hosting   |                       New Features   |   Advertise   |   Tutorials   |   Silverlight Tutorials   |   Product Reviews in India   |   Free aptitude test questions  |   TATA Nano Car reviews






Total members: 90131
Average new registrations per day (in last 7 days): 94


New Registration: Open

Register Now













Home » Questions & Answers » Attach SQL Database Status





Attach SQL Database Status

7/5/2008


Author: Ralph Cue

I get this error after clicking 'attach'.

Error attaching database. System.Data.SqlClient.SqlException: The operating system returned error 38(Reached the end of the file.) to SQL Server during a read at offset 0000000000000000 in file 'C:\MemberSites\MemberSites_AspSpider_Info\orchardthesis\database\dbtest.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at SpiderWatch.HostManager.AttachDatabase(String userId, String databaseName, String dataFile, String NetworkPath, String LocalPath, eUserType UserType)
Error opening attached database. Cannot open database "orchardthesis_dbtest" requested by the login. The login failed. Login failed for user 'DOTNETSPIDER1\dotnetspider'.


The application works just fine in local host but I cant seem to make it work when uploaded.

This are some of my codings.

<asp:SqlDataSource ID="mySqlDataSource" runat="server"
   ConnectionString="<%$ ConnectionStrings:dbtestConnectionString %>"
   InsertCommand="INSERT INTO [table1] ([date]) VALUES (@date)"
   SelectCommand="SELECT [date] FROM [Table1]"
>
</asp:SqlDataSource>

and in aspx.vb

Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click

     

       mySqlDataSource.InsertParameters("date") = New Parameter("date", TypeCode.String, TextBox1.Text)
       mySqlDataSource.Insert()

       TextBox1.Text = Nothing

   End Sub

SQL is totally new for me so details are highly appreciated. Thank you

Answers .............
Author: deepak one

Posted Date: 7/25/2008
Is this solved? I am facing same problem. Please post solution if you have one
Author: deepak one

Posted Date: 7/25/2008
Is this solved? I am facing same problem. Please post solution if you have one
Author: Nikhil Dandeker

VIT

Posted Date: 7/31/2008
Just reload(re-upload) the database. Mostly your database size must be zero bytes and its not got uploaded properly

You must login to post answer for this question.
 







Partners   Privacy Policy   Terms of use   Contact Us

SpiderWorks Technologies.
All Rights Reserved.