Microsoft Visual Basic Runtime Error 3146
Contents |
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. To start viewing messages, select the run time error 3146 odbc call failed access 2010 forum that you want to visit from the selection below. Results 1 to 4 run time error 3146 odbc call failed oracle of 4 Thread: RUNTIME ERROR '3146'..ODBC-Call Failed Tweet Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to run time error 3146 odbc call failed mysql Hybrid Mode Switch to Threaded Mode May 9th, 2005,11:41 PM #1 nagasrikanth View Profile View Forum Posts Thread Starter Hyperactive Member Join Date Nov 2004 Location India,Hyderabad. Posts 420 RUNTIME ERROR '3146'..ODBC-Call Failed Hi.. Im using SQL
Error 3146 Odbc Call Failed Sql
server as my backend and MS Access as F.E.. Im using to update around 10 to 20 records one by one by upto 2 to 3 records it was updating, later for 4th record it was saying "RUNTIME ERROR '3146'..ODBC-Call Failed"(at "rst.update" it was showing) ..at that time if i start agian from "rst.addnew" then for upto 3 to 4 it was okay..Is there any limitation in adding records.??? FYI: Im not getting odbc call failed access 2013 if i update 1 or 2 records..and one more thing that i came to know was ,If the table was a ordinary Access Table..Im not getting any error.. One more thing was If i place some time delay using msgbox (like msgbox "Updated..." for example)that means for each record I placed a message updated..then it was working perfectly on to my surprise.. Please help me in this regard..Please.. Thanks & regards Anu... Reply With Quote May 9th, 2005,11:46 PM #2 RobDog888 View Profile View Forum Posts Visit Homepage Super Moderator Join Date Apr 2001 Location LA, Calif. Raiders #1 AKA:Gangsta Yoda™ Posts 60,221 Re: RUNTIME ERROR '3146'..ODBC-Call Failed Sounds like your updating/adding records through Access tables/queries and not directly to the SQL tables? Alos, probably using a recordset to add/update when you could execute a sql INSERT statement or an sql UPDATE statement. Recordsets are slow. You can create a connection to SQL using ADO, DAO, ODBC to perform your actions. VB/Office Guru™ (AKA: Gangsta Yoda™ ®) I dont answer coding questions via PM. Please post a thread in the appropriate forum. Microsoft MVP 2006-2011 Office Development FAQ (C#, VB.NET, VB 6, VBA) Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET If a post has helped you then Please Rate it! • Star
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 Documentation APIs and reference Dev centers Samples Retired content We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second. Ask a question Quick access 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 Applications (VBA) Question http://www.vbforums.com/showthread.php?338252-RUNTIME-ERROR-3146-ODBC-Call-Failed 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 of timeout problem. Here is https://social.msdn.microsoft.com/Forums/en-US/75333327-1e1a-4af3-95b9-045b7de732eb/vba-exceloracle-query-and-runtime-error-3146?forum=isvvba 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  Accessing Data with ADOhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/iissdk/html/39eaa2b1-1a9c-4dbe-b889-494759fa9115.asp  ConnectionTimeout Propertyhttp://msdn.microsoft.com/library/en-us/ado270/htm/mdproconnectiontimeout.asp  CommandTimeout Propertyhttp://msdn.microsoft.com/l
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. To start viewing messages, select the forum that you want http://www.dbforums.com/showthread.php?1664131-Error-(3146)-ODBC-call-failed to visit from the selection below. Results 1 to 5 of 5 Thread: Error (3146) ODBC --call failed Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 02-08-11,15:10 #1 Stium View Profile View Forum Posts Registered User Join Date Jan 2011 Posts 19 Unanswered: Error (3146) ODBC --call failed I'm got a situation where I run a set error 3146 of reports for different areas. Most of the areas work but some I get this error. Error (3146) ODBC --call failed. [Oracle][OCBC][Ora]ORA-00600: internal error code, arguments.In this case I'm having access call an Oracle database. Suggestions that I found would include refreshing the link or dropping the table and adding it again. I've tried both. This isn't a single machine issue, it is happening network wide. Any suggestions? Reply With Quote 02-10-11,12:34 #2 pkstormy View Profile odbc call failed View Forum Posts Moderator Join Date Dec 2004 Location Madison, WI Posts 3,926 I might try re-creating the ODBC DSN. Also make sure that you don't have an ODBC DSN connecting to the same db by another ODBC DSN name. You want all users/computers that are connecting to the db to have the EXACT same ODBC DSN name. A mispelled (or spelled slightly different) ODBC DSN for one user/computer can cause problems for others. (but this usually causes problems for some users and not others). If that isn't the problem, I might try running any dbcc checkdb type commands on the Oracle server against the db (I'm not sure what the Oracle commands are to check the db.) This seems more likely since you said it's for all users. Lastly, when you link the tables, make sure the "Save Password" check box is checked when linking (although this wouldn't cause the problems you noted.) If all else fails, you could also try creating a File DSN versus a System DSN. Expert Database Programming MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0) Reply With Quote 02-10-11,15:21 #3 Stium View Profile View Forum Posts Registered User Join Date Jan 2011 Posts 19 Thank you for the reply. The issue was one of the tables needed to be rebuilt. It was an issue with h