Odbc Runtime Error 3146
Contents |
sophisticated digital experiences Web content & Customer Journey Sitefinity CMS Build engaging websites with intuitive web content management Application Development, Testing & run time error 3146 odbc call failed access 2010 Deployment DevCraft Leverage a complete UI toolbox for web, mobile
Run Time Error 3146 Odbc Call Failed Oracle
and desktop development OpenEdge Build, protect and deploy apps across any platform and mobile device run time error 3146 odbc call failed mysql Kendo UI Build rich, smart HTML5 and JavaScript apps for any platform, browser or device Telerik Platform Build mobile apps for iOS, Android and Windows error 3146 odbc call failed sql Phone Nativescript Use Angular, TypeScript or JavaScript to build truly native mobile apps Rollbase Rapidly develop, manage and deploy business apps, delivered as SaaS in the cloud Test Studio Automate UI, load and performance testing for web, desktop and mobile Modulus Host, deploy and scale Node.js, Java and .NET
Ms Access Error 3146
Core apps on premise or in the cloud Data Connectivity DataDirect Connectors Optimize data integration with high-performance connectivity Business Rules Management Corticon Automate decision processes with a no-code business rules engine View All Products Solutions Digital Business Transformation Transform your businesses in order to survive in a completely digitized and connected world driven by software innovation. Web Scale Globally scale websites with innovative content management and infrastructure approaches Modernization UX and app modernization to powerfully navigate todays digital landscape Omni-Channel Engagement Content-focused web and mobile solution for empowering marketers aPaaS Fuel agility with ever-ready applications, built in the cloud Enterprise Mobility Faster, tailored mobile experiences for any device and data source New & Trending E-book The Digital Ultimatum: Why Businesses Must Digitally Transform to Survive â€" and Thrive Survey Report The State of Digital Business Support & Learning Support Support Services Knowledge Base Customer Order Management
2002. The following code segment executes the first read, from rs, successfully, but gives me a "Run-time error 3146 ODBC--call failed" on the second one from rs1. Both rs and rs1 are queries. Can anyone give me information on this error? Dim odbc call failed access 2013 db as Database Dim rs as Recordset Dim rs1 as Recordset Dim strUserID as String Dim strProgram as String Set db = CurrentDb Set rs = db.OpenRecordset("SELECT program_id FROM sysuser WHERE sysuser_id = '" & strUserID & "'", dbOpenDynaset) rs.MoveFirst strProgram = rs!program_id If Right(strStartLoc, 2) = "10" Then Set rs1 = db.OpenRecordset("SELECT * FROM report_db WHERE enabled = '" & strUserID & "'", dbOpenDynaset) .... End If -- Carol Guest, Jun 9, 2005 #1 Advertisements Guest Guest Try and http://knowledgebase.progress.com/articles/Article/Run-Time-Error-3146-When-Running-Query-From-MS-Access-Linked-Tables run the queries, see if you get this error message. Running the query, not by code, will give you the odbc call failed, and then it will give another message, of what is the real error. If the query will run, then run the code, put a break before the open recordset, copy the string of the SQL to the immidiate window ?"SELECT program_id FROM sysuser WHERE sysuser_id = '" & strUserID & "'" and copy it to a new query and http://www.pcreview.co.uk/threads/run-time-error-3146-odbc-call-failed.1865044/ run, it will give you the real error. And as a side note 1. try and run the tables, mybe you are not connected to the server 2. Is user id is text type, if not then the sql should look like "SELECT program_id FROM sysuser WHERE sysuser_id = " & strUserID "Carol Grismore" wrote: > I am using Access 2002. The following code segment executes the first read, > from rs, successfully, but gives me a "Run-time error 3146 ODBC--call > failed" on the second one from rs1. Both rs and rs1 are queries. Can anyone > give me information on this error? > > Dim db as Database > Dim rs as Recordset > Dim rs1 as Recordset > Dim strUserID as String > Dim strProgram as String > > Set db = CurrentDb > Set rs = db.OpenRecordset("SELECT program_id FROM sysuser WHERE sysuser_id = > '" & strUserID & "'", dbOpenDynaset) > > rs.MoveFirst > strProgram = rs!program_id > > If Right(strStartLoc, 2) = "10" Then > Set rs1 = db.OpenRecordset("SELECT * FROM report_db WHERE enabled = '" & > strUserID & "'", dbOpenDynaset) > .... > End If > > -- > Carol Guest, Jun 9, 2005 #2 Advertisements Guest Guest These are some good ideas, but I have actually done all this and no errors occur. Any further ideas would be appreciated. -- Carol "Ofer" wrote: > Try and run the queries, see if you get this
be down. Please try the request again. Your cache administrator is webmaster. Generated Sat, 22 Oct 2016 06:37:49 GMT by s_wx1085 (squid/3.5.20)
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 forum that you want to visit from the selection below. Results 1 to 4 of 4 Thread: RUNTIME ERROR '3146'..ODBC-Call Failed Tweet Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to 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 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 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 Wars Gangsta Rap • Reps & Rating Posts • VS.NET on Vista • Multiple .NET Framework Versions • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address L