Error Number 3146
Contents |
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 error 3146 odbc call failed below. Results 1 to 5 of 5 Thread: ODBC - Connection Failed Error 3146 Tweet Thread error 3146 access Tools Show Printable 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 run time error 3146 odbc call failed access 2010 #1 shanmugha View Profile View Forum Posts Registered User Join Date May 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
Run Time Error 3146 Odbc Call Failed Oracle
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 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 field type (and what it's for) that is giving you problems? Last edited by pkstormy; 05-05-09 at 20:34. Expert Database Programming MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0) Reply With Quote 05-07-09,11:42 #3 shanmugha View Profile View Forum Posts Registered User Join Date May 2009 Posts 8 Connecion Failed Error Thanks for your insight.Got the error fixed. The ODBC Connect Str property of the pass thru query which the combobox was using wasnt set to the correct server.We had a change in t
software and hardware components. The main reason for this error is to take place is when a system gets corrupted in Windows OS. This article will be guiding you to get rid of run time error 3146 error in MS Access using manual method and even a fully automated solution. Moreover errors that take place regularly in relation to run-time 3146 Call Failed Access will too be sent. What is Run-Time Error 3146? When Microsoft Access tries to entrée the SQL Server 2000 database with the help http://www.dbforums.com/showthread.php?1642114-ODBC-Connection-Failed-Error-3146 of ODBC connection it displays an Error 3146- ODBC Call Failed. The database has been set as source of data for the system with driver of SQL Server. Hence on launching the .mdb application database could be attached and results are fetched. But while populating data on combobox, it shows 3146 connection failed error. This error report is actually the hexadecimal format of the error http://www.accessrepairnrecovery.com/blog/how-to-fix-ms-access-run-time-3146-odbc-call-failed-error code that’s generated. This is frequently brought into usage by the MS Windows along with additional compatible software and drivers. In some cases you may find superfluous constraints into the Run-time error 3146. The further letter and number code are addressed onto your storage fragment where all instructions are being saved at the time of happening of this error message. Cause for Run Time Error 3146 Odbc Call Failed Access error code? As discussed the major reason for the error 3146 ODBC Call Failed to happen is the corruption of the Windows system files. Because if the entries of the system are broken, then it is enough two pose considerable injury to the overall health of the individual computer system Some well known reasons for the cause of this error include fragmentary installation, erasing fractional file, inappropriate removal of equipment and software. Even attack of some malicious program like Trojan or other virus like spyware or adware could lead to this hectic situation. And these entire instances are sufficient for deleting or corrupting system files of the Windows. Damaged file will let you in wrongly and missing linkage of details
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 http://stackoverflow.com/questions/26224124/3146-odbc-call-failed-access-2010 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 https://bytes.com/topic/access/answers/932827-vba-code-error-odbc-3146-a of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up 3146 ODBC Call Failed - Access 2010 up vote -1 down vote favorite Please reference code error 3146 below... Private Sub Save_Click() On Error GoTo err_I9_menu Dim dba As Database Dim dba2 As Database Dim rst As Recordset Dim rst1 As Recordset Dim rst2 As Recordset Dim rst3 As Recordset Dim SQL As String Dim dateandtime As String Dim FileSuffix As String Dim folder As String Dim strpathname As String Dim X As Integer X = InStrRev(Me!ListContents, "\") Call myprocess(True) folder = DLookup("[Folder]", "Locaton", "[LOC_ID] = '" & Forms!frmUtility![Site].Value error 3146 odbc & "'") strpathname = "\\Reman\PlantReports\" & folder & "\HR\Paperless\" dateandtime = getdatetime() If Nz(ListContents, "") <> "" Then Set dba = CurrentDb FileSuffix = Mid(Me!ListContents, InStrRev(Me!ListContents, "."), 4) SQL = "SELECT Extension FROM tbl_Forms WHERE Type = 'I-9'" SQL = SQL & " AND Action = 'Submit'" Set rst1 = dba.OpenRecordset(SQL, dbOpenDynaset, dbSeeChanges) If Not rst1.EOF Then newname = Me!DivisionNumber & "-" & Right(Me!SSN, 4) & "-" & LastName & dateandtime & rst1.Fields("Extension") & FileSuffix Else newname = Me!DivisionNumber & "-" & Right(Me!SSN, 4) & "-" & LastName & dateandtime & FileSuffix End If Set moveit = CreateObject("Scripting.FileSystemObject") copyto = strpathname & newname moveit.MoveFile Me.ListContents, copyto Set rst = Nothing Set dba = Nothing End If If Nz(ListContentsHQ, "") <> "" Then Set dba2 = CurrentDb FileSuffix = Mid(Me.ListContentsHQ, InStrRev(Me.ListContentsHQ, "."), 4) SQL = "SELECT Extension FROM tbl_Forms WHERE Type = 'HealthQuestionnaire'" SQL = SQL & " AND Action = 'Submit'" Set rst3 = dba2.OpenRecordset(SQL, dbOpenDynaset, dbSeeChanges) If Not rst3.EOF Then newname = Me!DivisionNumber & "-" & Right(Me!SSN, 4) & "-" & LastName & dateandtime & rst3.Fields("Extension") & FileSuffix Else newname = Me!DivisionNumber & "-" & Right(Me!SSN, 4) & "-" & LastName & dateandtime & FileSuffix End If Set moveit = CreateObject("Scripting.FileSystemObject") copyto = strpathname & newname moveit.MoveFile Me.ListContentsHQ, copyto Set rs
your question and get tips & solutions from a community of 418,536 IT Pros & Developers. It's quick & easy. VBA code error odbc 3146 P: 2 sharonc Hi, I am getting an error 3146 odbc on rs.update. I have a form (form1) based on table motion_imagery. In form1, using VBA I'm trying to load two fields from form1 into table 2, File_Books. Expand|Select|Wrap|Line Numbers Setdb=CurrentDb() Setrs=db.OpenRecordset("dbo_Filestream_Files",dbOpenDynaset,dbSeeChanges) rs.MoveLast rs.Edit rs![Prefix_CTRL_NBR]=Me.Prefix_CTRL_NBR rs![CTRL_ID]=Me.CTRL_NBR rs.Update can someone help? thanks, Sharon Feb 22 '12 #1 Post Reply Share this Question 1 Reply Expert 100+ P: 931 patjones Sharon, Error 3146 is a generic ODBC error message. It means that Access cannot properly establish contact with your back end table, and it can occur for any number of reasons. Is dbo_Filestream_Files a linked SQL Server table? If so, and if the table is properly linked to the back end source, you should be able to open it in datasheet view and examine its contents. If you aren't able to do that, then it means that you need to properly the link the table to the back end source. Pat Feb 22 '12 #2 reply Message Cancel Changes Post your reply Join Now >> Sign in to post your reply or Sign up for a free account. Similar topics iSereies Dataqueue read error: CWB4016 cwbDQ_Read code error 6017 Error ODBC Call Failed Hi guys~ i wonder that why this simple code error!! How to get the error message rather than the code error XML Feed Code Error how to use vb code deploy ODBC ERROR: [ODBC Microsoft Access Driver]Invalid precision value Running Excel macro from access - code error calling my own VB code using ODBC ? ERROR! [ODBC Microsoft Access Driver] Too few parameters. Expected 2. Browse more Microsoft Access / VBA Questions on Bytes Question stats viewed: 3487 replies: 1 date asked: Feb 22 '12 Follow this discussion BYTES.COM © 2016 Formerly "TheScripts.com" from 2005-2008 About Bytes | Advertise on Bytes | Contact Us Sitemap | Microsoft Access / VBA Answers Sitemap | Microsoft Access / VBA Insights Sitemap Follow us to get the Latest Bytes Updates