Failed Error 3146 Access
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 error 3146 odbc call failed access to proceed. To start viewing messages, select the forum that you want to
Error 3146 Odbc Call Failed Access 2010
visit from the selection below. Results 1 to 5 of 5 Thread: ODBC - Connection Failed Error 3146 Tweet Thread
Microsoft Access Error 3146 Odbc Call Failed
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 #1 shanmugha View Profile View Forum Posts
Ms Access Error 3146 Odbc Call Failed
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 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 runtime error 3146 access 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?
be down. Please try the request again. Your cache administrator is webmaster. Generated Fri, 14 Oct 2016 01:37:49 GMT by s_ac4 (squid/3.5.20)
Posters Today's Posts Search Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show http://www.access-programmers.co.uk/forums/showthread.php?t=280228 Posts Tag Search Advanced Search Find All Thanked Posts Go to http://www.gfixpc.com/2014/01/sql-microsoft-access-error-3146-odbc.html Page... Thread Tools Rating: Display Modes 08-19-2015, 10:15 AM #1 Rx_ Nothing In Moderation Join Date: Oct 2009 Location: Denver, Colorado Posts: 2,633 Thanks: 557 Thanked 308 Times in 282 Posts Update to error 3146 ODBC--call failed. SQL Server Linked Tables error 3146 Does anyone have additonal reasons for Error 3146 besides Required Field? Suspected the problem was a Required Field on the SQL Server Linked Table. Sure enough it was. There seem to be other alternatives listed. MSACCESS 2010 MSAccess Error 3146 using linked tables to SQL Server 2008 R2. Didn't find any post that directly mention the Required error 3146 odbc Field. Perhaps this post will help others. The code below has one required field commented out. When the comment is removed, the code worked perfectlly and appends the new record. This is an old thread as an example: RE: http://www.access-programmers.co.uk/...d.php?t=155472 Another from the Microsoft Community that actually solved the problem in a different way: http://answers.microsoft.com/en-us/o...e-9083541c8891 In addition, some of the Microsoft site solutions don't exactly point out the Required Field at all. Code for an Append new record - works if uncommenting the ID_Area, a Required Field on the linked SQL Server Table. Code: Public Function AppendRecordNavDataToRegulatory() As String ' change to private after testing Dim strSQLWells As String ' create Wells recordset Dim rst As DAO.Recordset ' On Error GoTo Err_WellWellAnotherFineMessYouGotUsIn strSQLWells = " SELECT Wells.ID_Wells, Wells.Well_Name, Wells.WName, Wells.WNumber, Wells.WSection, Wells.WDesc, " & _ " Wells.ID_WellsStatus1, Wells.ID_Area, Wells.ID_County, Wells.ID_Prodg_Fmn, Wells.WellTypeID, Wells.ClassificationID, " & _ " Wells.ID_State, Wells.DtNavigatorHeadersCreated, Wells.API_No, Wells.Permit_File_No, Wells.UIC_No, Wells.FacilityNo " & _ " FROM Wells " ' Set rst = CurrentDb.OpenRecordset(strSQLWells, 2, dbAppendOnly + dbSeeChanges) rst.
the Driver and Application If you go to the ODBC Data Source Administrator, you will see the windows like this There is only one component exit, other are gone Solution: S1: That's because of your OS is 64bits Go to Control Panel -> ODBC Data Source Administrator, right click -> Properties S2: 1. Download and run AccessDatabaseEngine_x64.exe (http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d&displaylang=en) 2. Change the connection string : EX: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=xxxx;Driver={Microsoft Access Driver (*.mdb)}; replaced to be Provider=Microsoft.Jet.OLEDB.4.0;Data Source=xxxx;Driver={Microsoft Access Driver (*.mdb, *.accdb)}; Some Server Connection Strings don't need add "*.accdb", I don't know why, but for in case, add it Reactions: #Office #SQL 1 comment Anonymous said... Thx August 26, 2014 Post a Comment Newer Post Older Post Home Newer Newer Post Older Older Post Subscribe to: Post Comments (Atom) Search This Blog Loading... Blog Archive 2016 (5) July (1) June (1) May (1) March (1) February (1) 2015 (15) October (2) September (4) July (1) June (2) May (2) April (2) March (1) January (1) 2014 (42) December (2) November (4) October (4) September (3) August (4) July (13) June (5) May (1) April (1) March (1) January (4) [SQL]MSACCESS.EXE error - MSVCR90.dll [Life]Honesty is the Key for the career and the li... [Hyper-V]Mapping a USB device on VMs [SQL] Microsoft Access Error "3146 ODBC-Call Faile... 2013 (34) December (4) November (2) October (7) September (16) August (2) April (1) January (2) 2010 (5) October (2) August (1) July (2) Popular Tags [SQL] (12) [SQL]CDC (6) [SQL]Concurrency (9) [SQL