Error - 2147467259 80004005 Unspecified Error
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of runtime error 2147467259(80004005) this site About Us Learn more about Stack Overflow the company Business windows update error 80004005 Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask windows error code 80004005 Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up
Sql Server Error 2147467259
“Run-Time error '-2147467259 (80004005) Unspecified error” when attempting to reconnect up vote 1 down vote favorite I am building an Excel spreadsheet to acquire some data (table format) from a server using a customized Excel Add-in. After that I need to modify that table and I thought the best way to do it is using a ADODB connection to the same Excel spreadsheet 80004005 com and SQL queries. When I try to establish the ADODB connection using Microsoft ACE OLEDB 12.0 driver having used before a connection with that Excel Add-in, I always get the same error: Run-Time error '-2147467259 (80004005) Unspecified error This is the code I am using to establish ADODB connection: Dim Conn As New ADODB.Connection Dim mrs As New ADODB.Recordset Dim sconnect As String Set Conn = New ADODB.Connection DBPath = ThisWorkbook.FullName sconnect = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" _ & DBPath & ";" & "Extended Properties=""Excel 12.0 Xml; HDR=YES"";" Conn.Open sconnect Conn.Close If I swap the connection order, connect first to my Excel using ADODB and then connect to the external server using the Add-in, I do not get this error. The problem is, sometimes I have already established the Add-in connection using a different spreadsheet and when I open this spreadsheet with the ADODB connection, the error is triggered, because Excel retains that plug-in connection if I do not restart the Excel session. I have tried looping through Excel connections but it does not pick up the plug-in connection: For i = 1 To ActiveWorkbook.Connections.Count Next Is there a
Early Adopter Program ArcGIS Ideas Esri Support Services ArcGIS Blogs ArcGIS Code Sharing Product Life Cycles Manage 80004005 error Cases Request Case Start Chat Back to results Print
80004005 Windows 10
Share Is This Content Helpful? Search on GeoNet Submit to ArcGIS Ideas Error: Run-time
Visual Basic Error 2147467259 80004005
error "-2147467259 (80004005) Automation error Unspecified error Error Message The following error message is displayed when using Coverage to Geodatabase: Run-time error "-2147467259 http://stackoverflow.com/questions/33648802/run-time-error-2147467259-80004005-unspecified-error-when-attempting-to-re (80004005) Automation error Unspecified error" This was due to a corrupt coverage. Cause This is a known issue, CQ00073588.This can occur with a corrupt coverage in ArcMap 8.3. Solution or Workaround Export the coverage as an .E00 file and import it back into ArcMap.Start ArcToolbox and navigate http://support.esri.com/technical-article/000008042 to Conversion Tools > Export From Coverage > Export To Interchange File to export the coverage as an .E00 file.Navigate to Conversion Tools > Import to Coverage > Import from Interchange File to import the .E00 file to coverage format. Created: 5/5/2016 Last Modified: 5/5/2016 Article ID: 000008042 Software: ArcGIS - ArcInfo 8.3 Is This Content Helpful? Is This Content Helpful? Yes No We're glad to know this article was helpful. How can we make this better? Submit Contact our Support Team Request Case Start Chat Questions or issues with the site? Send Feedback Contact Support USA +1-888-377-4575 Name Email URL Please rate your online support experience with Esri's Support website.* Poor Below Satisified Satisfied Above Satisfied Excellent What issues are you having with the site? How can we improve? Submit Feedback sent successfully. Error while sending mail. Loading
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close https://www.experts-exchange.com/questions/21167606/run-time-error-2147467259-80004005-unspecified-error-vb6-mySQL.html Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > run time error -2147467259 (80004005) = unspecified error vb6 & mySQL Want to Advertise Here? Solved run time error -2147467259 (80004005) = unspecified error vb6 & mySQL Posted on 2004-10-13 Visual Basic Classic 1 Verified Solution 15 Comments 1,319 Views Last Modified: 2008-01-09 Hi guys, I have an app. that uses vb6, mySQL & error 2147467259 myODBC, I developed it using a computer with win2K OS and the app. was working fine, last week I had to format my hard drive then I installed Win-Xp Pro, I allready configured myODBC and I can see my database that is in a server, but when I try to run my app. the following error appear: run time error -2147467259 (80004005) unspecified error vb6 & mySQL I think that I have to make an ADO error - 2147467259 reference in the vb project but I'm not sure which one, my code is: ' Set conn = New ADODB.Connection ' ' Set rsAccesos = New ADODB.Recordset ' ' conn.CursorLocation = adUseClient ' conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" _ ' & "SERVER=192.168.8.228;" _ ' & "DATABASE=scrc;" _ ' & "UID=test;" _ ' & "PWD=;" _ ' & "OPTION=" & 1 + 2 + 8 + 32 + 2048 + 16384 ' ' conn.Open The app. stops in the last line "conn.Open" Thank's guys 0 Question by:pander Facebook Twitter LinkedIn Google LVL 7 Best Solution byHoweverComma That error sounds like you need to install the MySQL ODBC 3.51 DAO... Most of the time a missing component causes a -2147467259 RTE In the IDE you need to also go to Project-->References and select Go to Solution 11 Comments LVL 7 Overall: Level 7 Visual Basic Classic 5 Message Accepted Solution by:HoweverComma2004-10-13 That error sounds like you need to install the MySQL ODBC 3.51 DAO... Most of the time a missing component causes a -2147467259 RTE In the IDE you need to also go to Project-->References and select the MySQL driver. The choice will be obvious just scroll down the list it should be the