Error 3146 Odbc Call Failed Access 2007
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Tue, 11 Oct 2016 09:22:35 GMT by s_wx1131 (squid/3.5.20)
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 more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each 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 other. Join them; it only takes a minute: Sign up Determine real cause of ODBC failure (error 3146) with ms-access? up vote 6 down vote favorite 2 My client is using Access as a front end to a SQL Server database. They recently started getting ODBC - 3146 errors from time to time when running some reports. From what http://stackoverflow.com/questions/730414/determine-real-cause-of-odbc-failure-error-3146-with-ms-access I can tell, this is just a generic ODBC call failed error. I've tried sticking some error handling in the VB script that is launching the reports, but I am not having any luck getting extra error information. Code looks a bit like this. Public Function RunReports() On Error GoTo MyErrorTrap DoCmd.OpenReport "blah", acViewPreview DoCmd.Close DoCmd.OpenReport "foo", acViewPreview DoCmd.Close Exit_function: Exit Function MyErrorTrap: Dim errX As DAO.Error Dim MyError As Error If Errors.Count > 1 'This always seems to be 0, so no help For Each errX In DAO.Errors 'These are empty even if dont check for Errors.Count Debug.Print "ODBC Error" Debug.Print errX.Number Debug.Print errX.Description Next errX Else Debug.Print "VBA Error" Debug.Print Err.Number Debug.Print Err.Description End If 'Also have tried checking DBEngine.Errors, but this is empty too End Function I've also enabled tracing on the ODBC side, but that has bogged things down way too much, and I am so far unable to recreate the ODBC error. I am completely open for suggestions on how to diagnose this. vba ms-access vbscript odbc sha
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss http://stackoverflow.com/questions/20504074/access-odbc-error-3146 the workings and policies of this site About Us Learn more http://forums.mysql.com/read.php?37,557239,557239 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 x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping error 3146 each other. Join them; it only takes a minute: Sign up 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 error 3146 odbc query as the loop itterates. Oddly, it's not the first iteration. EDIT: When I say suddenly, it's 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: