Error 3146 Oracle
Contents |
360 games PC games error 3146 odbc call failed Windows games Windows phone games Entertainment All Entertainment error 3146 access Movies & TV Music Business & Education Business Students & educators error 3146 odbc call failed access Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet error 3146 odbc call failed access 2010 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 Lumia All
Run Time Error '3146' Odbc Call-failed Oracle
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
SQL Server 2014 Express resources Windows Server 2012 resources Programs MSDN subscriptions Overview Benefits Administrators Students Microsoft Imagine Microsoft Student Partners ISV Startups TechRewards Events Community Magazine Forums Blogs Channel 9
Run Time Error 3146 Odbc Call Failed Access 2010
Documentation APIs and reference Dev centers Retired content Samples We’re sorry. The access vba run time error 3146 content you requested has been removed. You’ll be auto redirected in 1 second. Ask a question Quick access odbc call failed error 3146 access 2013 Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: VBA Excel/Oracle query and run-time error 3146 Microsoft ISV Community Center > Visual Basic for https://support.microsoft.com/en-us/kb/160762 Applications (VBA) Question 0 Sign in to vote Hello, I have a small VBA Excel app that queries an Oracle database. Certain tables I hit are quite large, and queries on these large tables (with their associated large datasets) cause the following error: "Run-time error 3146" "ODBC call failed" Googling leads me to believe that this is some sort https://social.msdn.microsoft.com/Forums/en-US/75333327-1e1a-4af3-95b9-045b7de732eb/vba-exceloracle-query-and-runtime-error-3146?forum=isvvba of timeout problem. Here is the code I use (in part, all variables are appropriately dim'd): [code] strSQL = strSelect & strFrom & strWhere & strAnd & strMachines & strGroupBySet qdfData = dbMyDB.CreateQueryDef("", strSQL)strMyServer = "myserver" & ";"strDBConn = "ODBC;DRIVER={Oracle in OraHome92};SERVER=" & strMyServerqdfData.Connect = strDBConn & "UID=user_id;DBQ=" & strMyServer & "pwd=password;" [/code] I don't have a problem with queries of small tables, only the large ones. I read that it's possible to set connection.timeout = 0 to avoid this error, but I am VERY new to VBA and don't know how to incorporate that into this code. Any help is appreciated. Tuesday, March 21, 2006 5:50 PM Reply | Quote Answers 0 Sign in to vote Per our support engineer: I understand that you want to set timeout when executing the SQL command. Generally I would suggest using ADO. The code you post in the forum is somewhat like DAO. ADO is newer technology than DAO. In ADO, you can control timeout by using ConnectionTimeout or CommandTimeout property. Using ADOHow-to: Connecting to Oracle from VBAhttp://www.marcel-jan.nl/oracle/tips/oracle_tip_vba.html A
Support Guy, we highly recommend that you visit our Guide for New Members. Solved: Windows 2007 and DAO 3.6-Run time error 3146 Discussion in 'Software Development' started by https://forums.techguy.org/threads/solved-windows-2007-and-dao-3-6-run-time-error-3146.1092904/ urwethe, Mar 13, 2013. Thread Status: Not open for further replies. Advertisement urwethe Thread Starter Joined: Jul 28, 2004 Messages: 97 Hi, Running VBA 6.5 (within Excel 2007 macro), accessing ODBC DSN for Oracle Database 10.2. Using DAO 3.6 Windows XP Professional Works perfect. Using Windows 2007 Run-time error '3146' ODBC -call failed Test connection is successful in Oracle ODBC Driver Configuration Here is my code, please help!!! Set wrkODBC error 3146 = CreateWorkspace("", "", "", dbUseODBC) wrkODBC.DefaultCursorDriver = dbUseClientBatchCursor 'If wrkODBC Is Nothing Then ConnectDatabase = False Set db = wrkODBC.OpenDatabase("EBSPROD", dbDriverNoPrompt, False, "ODBC;DATABASE=;UID=bouser;PWD=xxxxx;DSN=EBSPROD") urwethe, Mar 13, 2013 #1 urwethe Thread Starter Joined: Jul 28, 2004 Messages: 97 I have additional information. ?fncODBCErrors |0 IM014: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application|3146 ODBC--call failed.| I got this from this function: Function fncODBCErrors() odbc call failed As String Dim strODBCErrors As String Dim intI As Integer ' Collect ODBC errors (if any) for reporting. strODBCErrors = vbNullString With DBEngine.Errors For intI = 0 To (.Count - 1) strODBCErrors = strODBCErrors & "|" & _ .Item(intI).Number & " " & _ .Item(intI).Description Next intI End With If Len(strODBCErrors) > 0 Then strODBCErrors = strODBCErrors & "|" End If fncODBCErrors = strODBCErrors End Function urwethe, Mar 13, 2013 #2 urwethe Thread Starter Joined: Jul 28, 2004 Messages: 97 When you create the DSN, you need to use C:\Windows\SysWOW64\odbcad32.exe. Instead of C:\Windows\system32\odbcad32.exe. The DSN created by latter odbcad32.exe is for 64 bit application use. urwethe, Mar 14, 2013 #3 This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue.View our Welcome Guide to learn how to use this site. Show Ignored Content As Seen On Welcome to Tech Support Guy! Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations. If you're not already familiar with forums, watch our Welcome Guide to get started. Join over 733,556 other people just like you! Loading...