Automation Error 80004005
Contents |
One games Xbox 360 games PC run time error 80004005 automation error games Windows games Windows phone games Entertainment All 80004005 excel Entertainment Movies & TV Music Business & Education Business Students & automation error 2147467259 educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security
Runtime Error 2147467259(80004005)
Internet Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Band Microsoft sql server error 2147467259 Lumia All Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
(80004005)’: 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 visual basic error 2147467259 80004005 proceed. To start viewing messages, select the forum that you want to visit from
Smart Runtime Error Fixer
the selection below. Results 1 to 7 of 7 Thread: [RESOLVED] Run-time error ‘-2147467259 (80004005)’: Tweet Thread Tools Show Printable Version
Solution Runtime Error 2147467259 80004005
Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Nov 11th, 2009,04:08 PM #1 Prod1 View Profile View Forum Posts Thread Starter New Member Join Date Nov 2009 https://support.microsoft.com/en-us/kb/286126 Posts 5 [RESOLVED] Run-time error ‘-2147467259 (80004005)’: Hello all, I have a very basic application ('Console') in VB6 which launches various documents and shortcuts. All works fine with Office 2003, but on an Office 2007 machine, when I click on the button to launch an Excel document (in an IE window, as it happens) the document opens fine, but I also get this error: Run-time error ‘-2147467259 (80004005)': Automation error http://www.vbforums.com/showthread.php?591505-RESOLVED-Run-time-error-%91-2147467259-(80004005)%92 Unspecified error When that message is okayed the application ('Console') closes down. It's the same with all buttons which launch an Office document. The existing code on the button is this: Private Sub CommandButton65_Click() Dim Browser As Object Set Browser = CreateObject("InternetExplorer.Application") With Browser .Navigate ("\\eh-app-d14\SHAREDDATA\Service Desk\SHIFTS\2009\SDSK Shift Rota 2009.xls") .StatusBar = True .Toolbar = True .TheaterMode = False .Visible = True .Resizable = True .AddressBar = True End With End Sub I know that's really basic, but it's fine for what I want. Is there anyway to improve/amend the above code so that I do not get this Run-time error with Office 2007 PCs? Thanks. Last edited by Prod1; Nov 11th, 2009 at 04:09 PM. Reason: spelling Reply With Quote Nov 11th, 2009,04:32 PM #2 emartinho View Profile View Forum Posts Addicted Member Join Date Apr 2009 Location Toronto, Ontario Posts 242 Re: Run-time error ‘-2147467259 (80004005)’: Welcome to the board, I used your code to open a simple data only workbook in Excel 2007 and it worked fine. Is there any code in the your Excel file in the Workbook_Open event for example? That might be the place to look. Hope this helps. -EM --- REMEMBER: If your issue is resolved, use the Thread Tools menu
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 this site About Us Learn more about Stack Overflow the company Business Learn http://stackoverflow.com/questions/31153613/vba-run-time-error-2147467259-80004005 more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags http://www.computerperformance.co.uk/Logon/code/code_80004005.htm Users Badges Ask 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 VBA Run-time error '-2147467259 (80004005) up vote 0 down vote favorite I am trying to connect to mysql using Excel VBA, I am using Excel 2013. error 2147467259 I am new to VB, so i followed this example: Inserting Data Into MySQL From Excel Using VBA Here is my connection code: Private Sub ConnectDB() Set oConn = New ADODB.Connection oConn.Open "DRIVER={MySQL ODBC 5.1.13 Driver};" & _ "SERVER=123.456.0.188;" & _ "DATABASE=MyDB;" & _ "USER=MyUser;" & _ "PASSWORD=MyPassword;" & _ "Option=3" End Sub When I try to execute this code, I get the following error: --------------------------- Microsoft Visual Basic for Applications --------------------------- Run-time error '-2147467259 (80004005)': error 2147467259 80004005 Automation error Unspecified error Here are my references: I know this question may look like a duplicate but I have looked through most of questions similar to this one, they do not solve my issue. mysql vb.net excel vba excel-vba share|improve this question asked Jul 1 '15 at 6:02 The Flash 3,1091935 Is the mysql odbc driver installed? –André Schild Jul 1 '15 at 6:06 @AndréSchild Yes i see MySQL Connector/ODBC 5.1 in my programs and features –The Flash Jul 1 '15 at 6:10 And it's the correct 32 or 64bit edition as needed by your VBA application? Does it work when you try to setup the datasource in the odbc manager? –André Schild Jul 1 '15 at 6:26 problem solved, so i checked my programs and files and i noticed that i had 32bit mysql and 64bit MySQL connector, so i downloaded the 32bit myql connector to match 32bit mysql and it worked. @AndréSchild make your comment an answer and i will accept it. thanks –The Flash Jul 1 '15 at 6:29 add a comment| 1 Answer 1 active oldest votes up vote 2 down vote accepted The ODBC drivers must match the 32 or 64Bit architekture of the VBA application. Otherwise VBA isn't able to use the odbc drivers. share|improve this answer answered Jul 1 '
80004005 - Unspecified ErrorThink of error 80004005 as meaning the script could not access your data. The most likely reason is a permissions related problem. Your best chance of resolving this problem is to study carefully any associated message, for example, 'File already in use', or 'Logon Failed'. Introduction to Error Code 80004005 Error 80004005 is a general error for all manner of events. I have to confess that I am still trying to understand all the causes of this code number. One thread that runs through error 80004005 problems is permissions. Another thread is incorrect format, for example you entering a number instead of a string. This is particularly true of telephone or fax numbers. My main interest is in VBScript errors, however, I have added database examples for completeness. The first branch in your decision tree is this an ASP error or some other ODBC error. Three types of 80004005 Error VBScript Connectivity Problems - E.g. SQL Data Access Components - MTS ‡ VBScript Symptoms What you see is WSH (Windows Script Host) message box. The script does not execute as you had hoped. Instead you get a message box like this picture: The Causes of Code Error 80004005 VBScript / CScript 1) In this case, VBScript was trying to store a password. With error 80004005 there is usually an element of access denied. Insufficient rights, wrong permissions. 2) It can occur when a VBScript attempts to connect to scriptpw.dll. There are other causes, such as connecting to COM objects or ADO, or other database object. 3) Another thread is Number v String value format. If you are dealing with a phone number, make sure that you add it as string value and not as a pure number. Extra information supplied by Murda McLoud. 'I worked out that had to convert the number to a string to stop the 80004005 error. Then the objUser.Put would work properly and save the data.' Solutions for Error 80004005 This has been a very difficult error to track down. Possibly the error was due to using WScript instead of CScript.Check the underlying database, for example, names, exclusive locks and especially permissions.One additional problem that I had with Error 80004005 was due to a firewall blocking the relevant port, it was either 80 or 135. Example 1: VBScript with Error 80004005 I have to admit this may not be ter