Error 3146 Odbc Oracle
Contents |
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
Runtime Error 3146 Odbc
messages, select the forum that you want to visit from the selection below. Results odbc error 3146 access 2010 1 to 5 of 5 Thread: Error (3146) ODBC --call failed Tweet Thread Tools Show Printable Version Subscribe to this Thread… error 3146 odbc call failed 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
Run-time Error 3146 Odbc Call Failed
(3146) ODBC --call failed I'm got a situation where I run a set 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
Error 3146 Odbc Call Failed Access
a single machine issue, it is happening network wide. Any suggestions? Reply With Quote 02-10-11,12:34 #2 pkstormy View Profile 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
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 error 3146 odbc call failed access 2010 site About Us Learn more about Stack Overflow the company Business Learn more
Run Time Error '3146' Odbc Call-failed Oracle
about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x run time error 3146 odbc call failed access 2010 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 Determine real http://www.dbforums.com/showthread.php?1664131-Error-(3146)-ODBC-call-failed 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 I can tell, this is just a generic ODBC call failed error. I've tried sticking some error http://stackoverflow.com/questions/730414/determine-real-cause-of-odbc-failure-error-3146-with-ms-access 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 share|improve this question edited Jun 16 '14 at 20:23 Smandoli 4,98622862 asked Apr 8 '09 at 14:57 Aaron Hinni 10.9k43134 add a comment| 2 Answers 2 active oldest votes up vote 5 down vote Us
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking http://database.ittoolbox.com/groups/technical-functional/access-l/odbc-connection-fail-3146-5157969 Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries MacProTX Inside-ERP VoIP_News Inside-CRM maxwellarnold I_am_the_dragon PCMag Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker JoeTorre bracke Locutus error 3146 Ramnath.Awate Dennis Stevenson Craig Borysowich DukeGanote Richard mircea_luca AbhaiTripathi Nikki Klein knowscognosdoi Clinton Jones blrvenkat Iqbalyk bluesguyAZ59 COMPANIES Hewlett Packard Hitachi America, LTD Compuware Fiberlink Communications View All Topics View All Members View All Companies Toolbox for IT Topics Database Groups Ask a New Question Microsoft Access The Microsoft Access group is for the error 3146 odbc discussion of issues that arise during the implementation, configuration, administration, or daily use of MS Access. Home | Invite Peers | More Database Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. ODBC CONNECTION FAIL 3146 Naveen Kumar asked Apr 7, 2013 | Replies (8) Hi I have written a application with will copy a table from SQL to Ms-Access. It was running properly but suddenly no idea it started giving the Error as the