Excel 2007 Run Time Error 3706
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 this site About Us Learn more about Stack Overflow the company Business Learn run time error 3706 provider cannot be found excel more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags
Runtime Error 3706 Provider Cannot Be Found Excel
Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you,
Run Time Error 3706 Application Defined Or Object Defined Error
helping each other. Join them; it only takes a minute: Sign up Working with OLEDB connection on Office 2013 64 bit up vote 0 down vote favorite I know there are a number of threads related to this.
Run Time Error 3706 Provider Cannot Be Found Windows 7
However, none of them seemed to solve my problem. I am putting down my exact problem here. Can someone help me with this? Environment - Windows 7 64 bit, Office 2013 64 bit Automation - A macro in VBA in Excel that will import some data to an .mdb file by connecting to it using the below mentioned driver Issue - Runtime error 3706, provider cannot be found. it may not be properly installed Attempt 1 run time error 3706 provider cannot be found oracle - I checked the error code online and most of the threads pointed to syntax errors and way of connecting. I tried implementing the suggestions but there was no impact Attempt 2 - I then found that this is because it was trying to use old driver with 64 bit office. Therefore, I then tried installing the most popular suggestion - http://www.microsoft.com/en-us/download/details.aspx?id=13255 This also didn't work Code - database_path = Application.ActiveWorkbook.path & "\" & "mydb.mdb" Set cn = CreateObject("ADODB.Connection") With cn .Provider = "Microsoft.Jet.OLEDB.4.0" .ConnectionString = "Data Source=" & database_path End With cn.Open Any solution is welcome as long as it works on all - office 2007, 2010 and 2013. Thanks! excel vba excel-vba ms-access share|improve this question asked Oct 22 '14 at 19:45 dsauce 1011213 in case there's a struggle with this, I don't mind getting office 2010 provided office 2010 32 bit and office 2013 64 bit can co-exist. can they? –dsauce Oct 22 '14 at 19:52 add a comment| 1 Answer 1 active oldest votes up vote 4 down vote accepted If you downloaded and installed the driver from the link you have in your question, you will notice that the "Install Instructions" has a section called "To use this download:". #2 under that section states that you need to change the Provider argument of the ConnectionString property to “Microsoft.ACE.OLEDB.12.0” in
Forums Excel Questions Run-time error 3706 - Provider not found Results 1 to 6 of 6 Run-time error 3706 - runtime error 3706 visual basic Provider not foundThis is a discussion on Run-time error 3706 - 3706 provider cannot be found sql server Provider not found within the Excel Questions forums, part of the Question Forums category; Hi Guys, I run time error 3706 provider cannot be found excel 2013 am building an application for Excel 2003 which pulls data from an Access 2007 database using an ... LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg http://stackoverflow.com/questions/26515823/working-with-oledb-connection-on-office-2013-64-bit this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Dec 14th, 2009,08:17 PM #1 BarryStevenson New Member Join Date Dec 2008 Posts 1 Run-time error 3706 - Provider not found Hi Guys, I am building an application for Excel 2003 http://www.mrexcel.com/forum/excel-questions/436055-run-time-error-3706-provider-not-found.html which pulls data from an Access 2007 database using an ADO connection. I have successfully tested this using Excel 2007 in 2003 compatibility mode using : strPathName = ThisWorkbook.Path MyConn = strPathName & "\Test.accdb" Set cnn = New ADODB.Connection With cnn .Provider = "Microsoft.ACE.OLEDB.12.0" .Open MyConn End With When I try running this using Excel 2003, I get the following error message: Run-time error 3706 Provider cannot be found. It may not be properly installed. I checked the VBA Project references, it references Microsoft ActiveX Data Objects 2.8 Library. Does anyone have any ideas? Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Jan 19th, 2011,04:46 AM #2 Jan Erik Board Regular Join Date May 2005 Location Norway Posts 78 Re: Run-time error 3706 - Provider not found Hi, I've exactly the same problem. Have you found any solution yet? Regards Jan Erik Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Jan 19th, 2011,09:11 AM #3 Trevor G Board Reg
be found If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have http://www.vbforums.com/showthread.php?589332-run-time-error-3706-provider-cannot-be-found to register before you can post: click the register link above https://social.msdn.microsoft.com/Forums/office/en-US/7ee17f78-b844-4d49-b274-2cb466e3be20/run-time-error-3706-application-defined-or-object-defined-error-while-opening-an-oracleconnection?forum=exceldev to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 12 of 12 Thread: run-time error 3706 provider cannot be found Tweet Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch time error to Hybrid Mode Switch to Threaded Mode Oct 27th, 2009,12:33 AM #1 giri_luck View Profile View Forum Posts Thread Starter Junior Member Join Date Nov 2008 Posts 19 run-time error 3706 provider cannot be found Hi, I have packaged the VB files and used the provider, strProvider = "Provider= Microsoft.Jet.OLEDB.3.51;" strDataSource = App.Path strDataBaseName = "\kra.mdb;" When time error 3706 installed the package in some other machine and try to connect the DB , i see the error run-time error 3706 , provider cannot be found. it may not be properly installed. Please suggest the fix for this. Thanks Giri Reply With Quote Oct 27th, 2009,02:21 AM #2 akhileshbc View Profile View Forum Posts Visit Homepage Freelancer Join Date Jun 2008 Location Trivandrum, Kerala, India Posts 7,633 Re: run-time error 3706 provider cannot be found You might be missing some dll or ocx files... Which one are you using... ADO or DAO..? What is the program used for packaging?? If my post was helpful to you, then express your gratitude using Rate this Post. And if your problem is SOLVED, then please Mark the Thread as RESOLVED (see it in action - video) My system: AMD FX 6100, Gigabyte Motherboard, 8 GB Crossair Vengance, Cooler Master 450W Thunder PSU, 1.4 TB HDD, 18.5" TFT(Wide), Antec V1 Cabinet Social Group: VBForums - Developers from India VBForums Beautifier + Friends Bday
soon) Ruby (coming soon) Getting Started Code Samples Resources Patterns and Practices App Registration Tool Events Podcasts Training API Sandbox Videos Documentation Office Add-ins Office Add-in Availability Office Add-ins Changelog Microsoft Graph API Office 365 Connectors Office 365 REST APIs SharePoint Add-ins Office UI Fabric Submit to the Office Store All Documentation https://www.yammer.com/ http://feeds.feedburner.com/office/fmNx Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Run time error 3706 application defined or object defined error while opening an OracleConnection from Excel VBA Microsoft Office for Developers > Excel for Developers Question 0 Sign in to vote I am trying to connect to an Oracle Database from Excel VBA and have Windows7 SP1 installed on my machine. I am getting an error message when it tries to open the connection, I have also installed Oracle Client and SQL Developer and the same connection string works fine from SQL Developer but not VBA. Earlier I was using provider as OraOLEDB.Oracle but I was getting RunTime Error -2147467259(80004005) Automation Unspecified error, then I removed . Oracle from it which led to 3706 error. Could you please suggest me something here as now i have spent 2 days almost here with nothing working out, am I missing any driver or setting ? PFB the snippet of code, also i have added MS Active X Dataobject 6.1 library and MS Active X Data Object recordset 6.0 library. Conn_String = "Provider=OraOLEDB;Data Source=(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 123)(PORT = 123)) )(CONNECT_DATA =(SERVICE_NAME = abc)));User Id=abc;Password=abc;" Set cn = New ADODB.Connection With cn .ConnectionString = Conn_String .CursorLocation = adUseClient .Open End With If cn.State = adStateOpen Then MsgBox ("connected successfully.") Else: MsgBox ("Error in connection.") End If Thursday, April 10, 2014 1:06 PM Reply | Quote Answers 0 Sign in to vote Hi, >>I am getting an error message when it tries to open the connection, I have also installed Oracle Client an