Ms Access Odbc Call Failed Error
360 games PC games Windows games Windows phone games Entertainment All Entertainment Movies & TV Music Business & Education Business Students & educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
for FacultyServices for ResearchersServices for IT ProfessionalsServices for GuestsTrainingTraining and EventsOnline Training Videos (Lynda.com)Technology ConsultingIT Communities/NetworkingHelp and SupportSupport InformationAlerts and OutagesSecurityContact UsAbout UsAbout ITSNewsITS OrganizationITS Biennial ReportIT Strategic PlanIT CommunitiesOneIT@Iowa You are hereHome▸Services and Software▸All Services and Software▸Microsoft Office▸Microsoft Access Microsoft Access ODBC Call Failed When running a query on a table in Access using a Data Source ODBC, users may periodically get an ODBC error: "ORA-12154: TNS could not resolve https://support.microsoft.com/en-us/kb/2730109 the connect identifier specified". The first thing to check is to make sure you have access to \\iowa.uiowa.edu\shared\uidata\psoft\oracle. If you can access this directory, move on to the next step. The second thing to check is to make sure that you do not have a conflict between a User DSN and https://its.uiowa.edu/support/article/102222 a System DSN. You should have one System DSN with the data source name set to DWPROD and the TNS service name set to dwprod.world as shown below. It should be using the Oracle in OraClient 11g_home#. Do NOT select Microsoft ODBC drivers. To get to this, go to Control Panel, Administrative Tools and Data Sources ODBC. If you have dwprod listed as a User DSN, rename it by click on "Configure" and then rename it to dwprod_old. Article number: 102222 Last updated: May 19, 2016 Service: Microsoft Access Category: General Support Information Contact Us Information Technology Services (ITS)2800 University Capitol CentreIowa City, IA 52242Phone: 319-384-4357Email: its-helpdesk@uiowa.eduChat: Help Desk Online ChatWebsite Feedback Navigate Home All Services and Software Training and Events Support Information About ITS Connect with Us FacebookTwitterYouTubeGoogle Plus The University of IowaDirectory A-Z Search About Iowa Contact Us Calendars Privacy Information © 2016 The University of Iowa
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 below. Page http://www.dbforums.com/showthread.php?1645045-ODBC-Call-Failed 1 of 2 12 Last Jump to page: Results 1 to 15 of 20 Thread: ODBC - Call Failed Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 07-09-09,14:08 #1 jlatham View Profile View Forum Posts Registered User Join Date Jul 2009 Posts 10 Unanswered: ODBC - Call Failed I'm a database noob, so please be gentle... I'm using Access 2003 to open files in Access ms access 2000 file format. I'm using a System DSN set up some linked tables through the ODBC Data Source Administrator. The particular Access database that I need to use gives me "ODBC--call failed" each time I try to use it. Testing the connection through the ODBC data source administrator gives me "Connection successful" every time, and I have several other Access files using the same data source that work fine. I thought that maybe it would be a server timeout, but the timeout ms access odbc is set to 60 seconds, and the error comes up after 5 seconds. I tried recreating the linked tables, and that didn't seem to help. Any ideas? Reply With Quote 07-09-09,15:07 #2 nckdryr View Profile View Forum Posts Computer Monkey Join Date May 2005 Posts 1,191 Are the other Access files also running off of Access 2003 with a 2000 format? Me.Geek = True Reply With Quote 07-09-09,16:25 #3 jlatham View Profile View Forum Posts Registered User Join Date Jul 2009 Posts 10 Originally Posted by nckdryr Are the other Access files also running off of Access 2003 with a 2000 format? Yes, I open the files with Access 2003 and the format on those files is Access 2000 as well. Other users of these files (there are 3 of us) are apparently having the same issue where the data source works for any file but these. I just really don't want to spend the time reimporting forms, queries, local tables, etc., but it looks like that might be what i have to do... Reply With Quote 07-10-09,07:32 #4 Sinndho View Profile View Forum Posts Moderator Join Date Mar 2009 Posts 5,440 Provided Answers: 14 Could you check some properties of the attached tables and see if they are coherent? Code: Dim tdf As DAO.TableDef Dim dbs As DAO.DataBase Dim i as integer Set dbs = CurrentDb For i = 0 To dbs.TableDefs.count - 1 Set tdf = dbs.TableDefs(i) If Len(tdf.Connect) Then Debug.Print tdf.Name Debug.Print, td