Oracle Odbc Error 3146
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies
Error 3146 Odbc Call Failed Access 2010
of this site About Us Learn more about Stack Overflow the company Business run time error 3146 odbc call failed access 2010 Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges run time error '3146' odbc call-failed oracle Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute:
Ms Access Error 3146
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 I can tell, this is just a generic ODBC call failed error.
Odbc Call Failed Access 2013
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 share|improve this question edited Jun 16 '14 at 20:23 Smandoli 5,01322863 asked Apr 8 '09 at 14:57 Aaron Hinni 11k43134 add a comment| 2 Answer
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 6.2 http://stackoverflow.com/questions/730414/determine-real-cause-of-odbc-failure-error-3146-with-ms-access million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Run-Time Error '3146' when inserting records into an Oracle Database over an ODBC Connection up vote 1 down vote favorite I'm working on my first Access application and I'm having trouble when I try to insert records http://stackoverflow.com/questions/3544032/run-time-error-3146-when-inserting-records-into-an-oracle-database-over-an-odb from the Access database into an Oracle database. The first record is inserted without error, but the second record raises a "Run-Time Error '3146'" error message. Any ideas? Private Sub Command42_Click() Dim dbMyDatabase As DAO.Database Dim rsMyRecords As DAO.Recordset Dim qdMyParameters As DAO.QueryDef Dim qODBC As DAO.QueryDef Dim sql As String Dim sqODBC As String Dim sConnectDAO As String Dim sVariable As String Dim qdfTimeTrack As DAO.QueryDef Dim qdfLocal As DAO.QueryDef Dim sWorkDate As String Dim sHours As String Dim sCreateDate As String Dim sCreateUserId As String Dim sWmDbId As String Dim sCsubDbId As String Dim sComments As String Set dbMyDatabase = CurrentDb Set qdfTimeTrack = CurrentDb.QueryDefs("QADB-INSERT") sConnectDAO = "ODBC;DSN=QADB;DBQ=QADB ;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=F;CSR=F;FWC=F;FBS=64000;TLO=O;" qdfTimeTrack.Connect = sConnectDAO qdfTimeTrack.sql = "set role all;" qdfTimeTrack.Execute Set qdfLocal = dbMyDatabase.QueryDefs("UpdateLocal") Set qdMyParameters = dbMyDatabase.QueryDefs("TimeRecordsForExport") Set rsMyRecords = qdMyParameters.OpenRecordset() Do While Not rsMyRecords.EOF sql = "INSERT INTO DAILY_JOB_ACTIVITIES ( DB_ID, PER_PER_DB_ID, CNUM_DB_ID, WORK_DATE, HOURS, CREATE_DATE, CREATE_USER_ID, WM_DB_ID, CSUB_DB_ID, COMMENTS ) " + _ " values " + _
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 https://groups.google.com/d/topic/comp.databases.oracle.misc/xxXEzizC1YA TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries VoIP_News Inside-ERP MacProTX Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Craig Borysowich error 3146 Locutus Dennis Stevenson DukeGanote Richard iudithm mircea_luca Clinton Jones bracke Nikki Klein AbhaiTripathi Iqbalyk Adrian_Grigoriu bluesguyAZ59 blrvenkat COMPANIES EdgeWave Sophos Pivotal CRM Wave Direct 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 discussion of odbc call failed 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 ODBC Call Fai
GoogleВойтиСкрытые поляПоиск групп или сообщений