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.
| Author |
Topic |
|
wawansur
Starting Member
44 Posts |
 Posted - 2009-07-29 : 04:43:20
|
| I use VB 6 as form entry in my application and Ms-SQL 2000 as databse.When I run some query from application i get error with message"connection failure"any suggest?If I debug step by step the query there is no problem.but, when i run in one step, i got that message.i used begin trans and commit trans to run some querythen when I debug later, I found this massage in query analyzer(0 row(s) affected)Server: Msg 823, Level 24, State 2, Procedure Tg_D_TrSOJualH_J, Line 13I/O error (torn page) detected during read at offset 0x00000004a3e000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL\data\ISMEGA JAYA0001.mdf'.Connection Brokenthis happen when I run this query :Delete from TrSoJual_H Where FNTrans='F00057'trigger Tg_D_TrSOJualH_J is trigger for delete in TrSOJual_H |
|
|
wawansur
Starting Member
44 Posts |
Posted - 2009-07-30 : 03:32:35
|
| I have answer from the other forum,the problem caused when i backup the database, probably the data is't good condition.When i backup again and restore, and run the query is well.may be my case can help for the otherRgds |
 |
|
|
|
|
|
connection failure