Odbc 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 to proceed. To start
Run Time Error 3146 Odbc Call Failed Access
viewing messages, select the forum that you want to visit from the selection below. error 3146 odbc call failed access 2010 Results 1 to 5 of 5 Thread: ODBC - Connection Failed Error 3146 Tweet Thread Tools Show Printable Version Subscribe to
Run Time Error 3146 Odbc Call Failed Access 2010
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 Registered User Join Date May 2009 Posts 8 run time error 3146 odbc call failed oracle 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 able to connect to the database and fetch results.But only while populating access macro error 3146 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 pr
Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find All Thanked Posts Go to Page... Thread Tools Rating: Display Modes 04-03-2008, 04:39 AM #1 oumahexi Free Range Witch Join Date:
Run Time Error 3146 Odbc Call Failed Mysql
Aug 2006 Location: Brig O'doon Posts: 1,991 Thanks: 4 Thanked 2 Times in 2 Posts ODBC 3146 Error for Some Users Hello again My apologies for another posting so soon after the last. My problem is an inherited database that just does not behave. The latest error is the ODBC 3146 (Error occurred report could not be checked). This error occurs when a user tries to run a report. Our system collects data via Access 2002 into fields that are linked to SQL http://www.dbforums.com/showthread.php?1642114-ODBC-Connection-Failed-Error-3146 Server 2000, the information is then passed back into Access to run the required reports. The reason for this is that the original database relied on Access information being fed in from an external source. The source changed to SQL while our database was in it's infancy, but management decided that rather than rebuild from scratch it would be best to patch the old system up I know there are many queries in the database which query a query for no apparent reason http://www.access-programmers.co.uk/forums/showthread.php?t=146862 - example: qryThisQuery interrogates qry_tblThisQuery (selecting all fields from this query), qry_tblThisQuery interrogates dbotblThisQuery (selecting all fields from the table). My first thought about the ODBC errors being experienced is that there are too many scenarios like this and it limits the efficiency of the database. However, my hands are tied, I am only permitted to patch it up. My second thought is that perhaps the user needs her registry cleaned out? or perhaps there may be too much junk in her temp folder? The big problem is that it works on my pc and another user's pc but not on the third. any thoughts? Very much appreciated. Thanks Ouma oumahexi View Public Profile Visit oumahexi's homepage! Find More Posts by oumahexi 04-03-2008, 04:42 AM #2 Rabbie Super Moderator Join Date: Jul 2007 Location: In Exile in Wiltshire Posts: 5,892 Thanks: 106 Thanked 72 Times in 64 Posts My first reaction when it works on some PCs but not on others is to check the route to the SQL Server DB from the failing PC. Is it the same as on the working ones. Good luck __________________ The best solution is the simplest one that meets all requirements. To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. Rabbie View Public Profile Visit Rabbie's homepage! Find More Posts by Rabbie 04-03-2008, 04:59 AM #3 gemma-the-husk
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies http://stackoverflow.com/questions/26224124/3146-odbc-call-failed-access-2010 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 https://www.experts-exchange.com/questions/27831438/MS-Access-VB-Runtime-error-3146-ODBC-Call-Failed-connecting-to-mySQL.html 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 error 3146 minute: Sign up 3146 ODBC Call Failed - Access 2010 up vote -1 down vote favorite Please reference code 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 error 3146 odbc 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 & "'") 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, d
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > MS Access (VB) Runtime error 3146 ODBC Call Failed (connecting to mySQL) Want to Advertise Here? Solved MS Access (VB) Runtime error 3146 ODBC Call Failed (connecting to mySQL) Posted on 2012-08-16 MS Access MySQL Server 1 Verified Solution 2 Comments 7,811 Views Last Modified: 2012-08-23 Hi Experts I have recently had to update mySQL from 5.1 to 5.5 with a MS Access 2003 front end (via ODBC links) When I run some legacy SQL queries on Access using a form I inherited (and worked fine before the rebuild) I am getting Visual Basic Error 3146 ODBC Call Failed. I can run the code directly within mySQL so I am at a loss what the problem might be. I have switched ODBC Tracing on, and get the following fragment in the log - which doesnt really help much: InterconnecTRep 90-14f0 EXIT SQLExecDirect with return code -1 (SQL_ERROR) HSTMT 0FA83860 UCHAR * 0x11CF44B4 [ 2010] "## This report currently includes ...(SQL is in here)" SDWORD 2010 DIAG [S1000] [MySQL][ODBC 5.1 Driver][mysqld-5.5.27-log]Query execution was interrupted (1317) Does anyone know how I can force more detail on the 3146 error, so it shows me what the *real* problem is? Thanks 0 Question by:stummj Facebook Twitter LinkedIn Google LVL 56 Active today Best Solution byJim Dettman (Microsoft MVP/ EE MVE) <