Error 2147467259 Network Error
Contents |
Forum Visual Basic Programming Visual Basic 6.0 Programming error 800004005, "Disk or Network Error" If this is your first visit, be sure to check out the FAQ by error 2147467259 sql clicking the link above. You may have to register or Login before you can error 2147467259 odbc post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit runtime error 2147467259 from the selection below. Results 1 to 7 of 7 Thread: error 800004005, "Disk or Network Error" Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch
Run-time Error 2147467259
to Hybrid Mode Switch to Threaded Mode March 9th, 2009,10:03 AM #1 hjehan View Profile View Forum Posts Member Join Date Apr 2005 Posts 103 error 800004005, "Disk or Network Error" I have a VB6 application that very occasionally bombs out with a message "Run Time Error -2147467259 (80004005) Disk or Network Error". By occasionally I mean it can run for many hundreds of times - days - sql server error 2147467259 with no problem... until it fails. Anyone have a clue as to what's causing the error, and more importantly, suggest a fix or a way of handling the error intelligently? I suspect the problem is with reading or writing to an Access2000 database. This file is also on a network drive, so it could also be a network problem I suppose. Anyway, here's some typical code... If MyDBConn.State = 0 Then Set MyDBConn = New ADODB.Connection 'instantiate our database connection object MyDBConn.Open _ "Provider=" + LocalDbProviderSpec + ";" + _ "Data Source=" + DataBasePath + ";" + _ "Persist Security Info=False;" + _ "User ID = " + LocalDbUserId + ";" Set MyRecSet = New ADODB.Recordset End If With MyRecSet SelectString = "SELECT * FROM SensitometerFactors WHERE Sensitometer = '" + Sensitometer + "';" .Open SelectString, MyLampMonitorDBConn, adOpenStatic, adLockOptimistic 'Issue an SQL query that will return a recordset .MoveFirst XXX = CDbl(.Fields("XXX")) .Close End With I copied the basic format above from this site long ago & I've found it to work quite well. * I really don't know what adOpenStatic & adLockOptimistic do for me... should I use other parameters? * Can I look at some parameter other than MyDBConn.State to see
error If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. http://www.vbforums.com/showthread.php?584320-runtime-error-2147467259(80004005)-network-error To start viewing messages, select the forum that you want to visit from the http://www.sqlservercentral.com/Forums/Topic606988-149-1.aspx selection below. Results 1 to 3 of 3 Thread: runtime error 2147467259(80004005) network error Tweet Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Sep 16th, 2009,12:18 AM #1 sanju4kk View Profile View Forum Posts Thread Starter Addicted Member Join Date Oct 2008 error 2147467259 Location India, Kerala, Calicut Posts 242 runtime error 2147467259(80004005) network error Hai, I have create a vb6 application with MS access back end. Right now while am clicking on the exe file it showing the following error. Code: runtime error 2147467259(80004005) network error Please help me out!! Tanks in advance Reply With Quote Sep 16th, 2009,07:49 AM #2 si_the_geek View Profile View Forum Posts Super Moderator Join Date error 2147467259 network Jul 2002 Location Bristol, UK Posts 38,296 Re: runtime error 2147467259(80004005) network error Thread moved to 'Database Development' forum (the 'VB6' forum is only meant for questions which don't fit in more specific forums) You haven't given enough info yet, some things we will need to know: What method are you using to connect to the database? (eg: ADO code/ADO control/DAO control/...) What database related code have you got in Form_Load etc? What is your connection string? (July 2007 to June 2017) . . . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums Classic VB FAQs (updated Oct 2010) ...Database Development FAQs/Tutorials (updated May 2011) (includes fixing common VB errors) .......... (includes fixing common DB related errors, and [Classic VB] ADO tutorial /further steps, and [VB.Net] ADO.Net Tutorial). Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. SQL 'Select' statement formatter/checker .•. Convert colour number to colour name .•. FlexGrid: fill from recordset .•. FlexGrid: AutoSize columns .•. DB Reserved Words checker Connection strings .•. MDAC/Jet/ACE downloads .•. SQL Server downloads .•. MZTools (free upgrade for the VB6/VBA Editor) Reply With Quote Sep 16th, 2009,04:27 PM #3 Siddharth Rout View Profile View Forum Posts Visit Home
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2005 » SQL Server 2005 General Discussion » Run-time error '-2147467259 (80004005)' Run-time error '-2147467259 (80004005)' Rate Topic Display Mode Topic Options Author Message michael.tangmichael.tang Posted Saturday, November 22, 2008 4:49 AM Forum Newbie Group: General Forum Members Last Login: Sunday, November 23, 2008 3:20 PM Points: 3, Visits: 5 Hi,We have accounting system, APS, which is sitted in SQL2005 stnd. Two week ago, because of shortage of hardware resource, we migrated the whole database to new server. there is no error in the first week after migration. But later, most of client users have been getting the error message sereral times casually a day. The error messages as belowRun-time error '-2147467259 (80004005)':[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()).NumADOErrors:2 err(10054) [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()). err(11) [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.At first I thought maybe it was network issue. I changed switch, cable and network card for the server. But these did not fix this issue.Is there someone here to help me to fix this issue?Many thanks in advance for your help Post #606988 Todd EngenTodd Engen Posted Saturday, November 22, 2008 8:12 AM Ten Centuries Group: General Forum Members Last Login: Thursday, April 23, 2015 2:42 PM Points: 1,073, Visits: 6,336 Changing the switch, cable and NIC all sounds like a good steps, could still be some type of network configuration issue. For example, duplex mismatch. If you haven't tried it yet, use something like robocopy to time copying a large data file to a known good server and to the new server to see if the times are consistent. At least that way you completely rule out SQL as having anything to do with it. Post #607003 michael.tangmichael.tang Posted Saturday, November 22, 2008 4:23 PM Forum Newbie Group: General Forum Members Last Login: Sunday, November 23, 2008 3:20 PM Points: 3, Visits: 5 Many thanks for your reply. I already download robocopy GUI application but don't know how to use it. I put one of server folder in the source path, which contains 10GB file, and local c drive as target path. When I click run, only take one second, and I could not find the log.But anyway, I still think it is SQL server setting issue instead of network issue. Post #607094 Todd EngenTodd Engen Posted Saturday, November 22, 2008 6:28 PM Ten Centuries Group: General Forum