Access 2007 Error 3146
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 29 Sep 2016 17:56:54 GMT by s_hv997 (squid/3.5.20)
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 error 3146 odbc call failed start viewing messages, select the forum that you want to visit from the error 3146 odbc call failed access 2010 selection below. Results 1 to 5 of 5 Thread: ODBC - Connection Failed Error 3146 Tweet Thread Tools Show Printable
Run Time Error 3146 Odbc Call Failed Access 2010
Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 05-05-09,19:17 #1 shanmugha View Profile View Forum Posts Registered User Join Date May http://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_other/access-2007-odbc-call-failed-error-3146-only-on/27172fb8-958f-4222-be8e-9083541c8891 2009 Posts 8 Unanswered: ODBC - Connection Failed Error 3146 Hi, I have a situation here.I will be glad if anyone could help. We have a Microsoft Access 2003 accessing the SQL Server 2000 database using ODBC connection.I have set the database as a System Datasource with SQL Server driver and the connection settings. When i launch the .mdb application,i am able to connect to the database and http://www.dbforums.com/showthread.php?1642114-ODBC-Connection-Failed-Error-3146 fetch results.But only while populating the data on one of the combobox,the ODBC connection failed error 3146 arises. I turned on the tracing and saw that the SetConnection Attr failed error in the log. Any help is highly appreciated. Thanks in advance. Reply With Quote 05-05-09,20:24 #2 pkstormy View Profile View Forum Posts Moderator Join Date Dec 2004 Location Madison, WI Posts 3,926 Are you able to enter data for this field directly into the table? If not, are you able to enter data in this field directly into the SQL Server table (I'm guessing yes.) You can also try refreshing (or delete and relink) the linked tables. You can also put in a msgbox me!MyProblemField in the AfterUpdate (or BeforeUpdate) event to see what value is actually being saved in the combobox and see if it matches the SQL Server field type. I'm not sure what the error exactly means but these are some things I normally do to troubleshoot. My guess is that you may not be passing the correct value type for that field (what is the field type defined as on SQL Server?) Or it's a relational problem. Can you explain more on what kind of
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 http://stackoverflow.com/questions/20504074/access-odbc-error-3146 this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question http://forums.mysql.com/read.php?37,557239,557239 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 error 3146 Access/ODBC error 3146 up vote 2 down vote favorite I have an MS Access 2007 front end to a MS SQL Server 2008R2 back end. I've got a query that's part of a loop, and it's suddenly started generating Run-time error '3146': ODBC--call failed. errors on one query as the loop itterates. Oddly, it's not the first iteration. EDIT: When I say suddenly, it's error 3146 odbc been running like this just fine for several months (probably since March). Set db = CurrentDb db.QueryTimeout = 480 'thought there was a timeout issue, so set this very high Set SupvRS = db.OpenRecordset("SELECT DISTINCT tblProcessors.Supervisor, tblProcessors.SupervisorEmail " & _ " FROM tblProcessors INNER JOIN (tblAuditPr INNER JOIN tblAuditPr_A ON tblAuditPr.PrAudit_ID = tblAuditPr_A.PrAudit_ID)" & _ " ON tblProcessors.Processor = tblAuditPr_A.Processor" & _ " WHERE tblProcessors.Supervisor IS NOT NULL " & _ " AND tblAuditPr.EndDate BETWEEN " & GetSQLDate(Me.txtFrom) & " AND " & GetSQLDate(Me.txtTo) & _ " AND tblProcessors.Processor<>'Default Processor' " & _ " AND tblAuditPr_A.Answer Not In ('NA','NF')" & _ " AND tblAuditPr.Status = 'Submitted'") Do While Not SupvRS.EOF 'Send Supervisor Email Attachment = PARG.GenerateAuditReport(SupvRS.Fields("Supervisor"), parSupervisor, Me.txtFrom, Me.txtTo) Set EmailRS = db.OpenRecordset("SELECT * FROM tblProcessors WHERE Supervisor = " & GetSQLString(SupvRS.Fields("Supervisor"))) If EmailRS.EOF Then Err.Raise -234923, Description:="Cannot find tblProcessors record for " & SupvRS.Fields("Supervisor") & "." End If If IsNull(EmailRS.Fields("SupervisorEmail")) Then MailTo =
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: Connector/ODBC :: [SOLVED] Error 3146(Call Failed) with MYOBDC and ACCESS 2007 with linked tables New Topic Advanced Search [SOLVED] Error 3146(Call Failed) with MYOBDC and ACCESS 2007 with linked tables Posted by: VINICIUS OLIVEIRA DE SOUSA () Date: June 11, 2012 01:06PM I have a linked table in Access using a DSN file. When the file name is PSD.DSN if the table has more than 200 lines is returned the error 3146 (call failed) when I try open a linked table. Note: If you have 201 rows and delete one row, the table opens normally. When the file name is ESTES.DSN table opens normally even if you have more than 200 lines. WHY ????!!! MYSQL Version: 5.5.16 (xampp package) MyODBC Version: 5.01.07.00 Operating System: Windows 7 OBS: Sorry any error in my English. I´m using Google Translator Edited 2 time(s). Last edit at 07/26/2012 01:18PM by VINICIUS OLIVEIRA DE SOUSA. Navigate:Previous Message•Next Message Options:Reply•Quote Subject Written By Posted [SOLVED] Error 3146(Call Failed) with MYOBDC and ACCESS 2007 with linked tables VINICIUS OLIVEIRA DE SOUSA 06/11/2012 01:06PM Re: Error 3146(Call Failed) with MYOBDC and ACCESS 2007 with linked tables VINICIUS OLIVEIRA DE SOUSA 07/26/2012 01:17PM Sorry, you can't reply to this topic. It has been closed. powered by phorum Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party. Contact Sales USA: +1-866-221-0634 Canada: +1-866-221-0634 Germany: +49 89 143 01280 France: +33 1 57 60 83 57 Italy: +39 02 249 59 120 UK: +44 207 553 8447 Japan: 0120-065556 China: 10800-811-0823 India: 0008001005870 More Countries» Contact Us Online» Products MySQL Enterprise Edition MySQL Standard Edition MySQL Classic Edition MySQL Cluster CGE MySQL Embedded (OEM/ISV) Services Training Certification Consulting Support Downloads MySQL Community Server MySQL Cluster MySQL Fabric MySQL Utilities MySQL Workbench About MySQL Contact Us How to Buy Partners Job Opportunities Site Map Documentation MySQL Reference Manuals MySQL Workbench Expert Guides Topic Guides MySQL Cluster Legal Legal Policies Your Privacy Rights Terms of Use Trademark Policy Contributor Agreement © 2015, Oracle Corporation and/or its aff