Error 3151 Odbc Oracle
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 of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads
Run Time Error 3151 Odbc Connection Failed Oracle
with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack error 3151 odbc connection failed windows 7 Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign odbc runtime error 3151 up ODBC Call Failed - Error 3151 up vote 3 down vote favorite 1 We have an Access database migrated from Access 97 to Acces 2007 with some linked tables to an SQL Server 2008 database. We are using a File
3151 Odbc Connection Failed Access
DSN in the ODBC Administrator. Connection tests work fine there. In fact, we have a main form in the Access 2007 application that shows the data always correctly. The problem appears when we execute a task that makes the following call: Dim dbs As Database
Dim rstAppend As Recordset
Set dbs = CurrentDb
Set rstAppend = dbs.OpenRecordset(strAccessTable, dbOpenDynaset, dbSeeChanges) OpenRecordset throws the error number 3151 and occurs randomly but it appears quite frequently. It's sporadic. When we don't get the error, the task
Odbc - Connection To Name Failed. (error 3151)
works fine. It not happens always, mostly we're fine. When it happens it happens for all subsequent tasks tried. We have to close and reopen the Access database and pray to the good Lord that it works. Sometimes, refreshing the tables in the Linked Table Manager solves the problem, but others don't. We receive sometimes an error "ODBC--Call Failed" when refreshing the Linked Table Manager. Deleting the File DSN and creating a new one solves the problem. We have tried with two different drivers (SQL Server and SQL Server Native Client 10) and in both cases the problem remains. Also we have tried to put the Access File in the same machine than the SQL Server and the problem remains. We have increased the ODBC Timeout for all the querys from 60 to 180 seconds,but the problem still remains. We don't have to wait to see the error, it appears in less than one second after executing the task. We would be very happy if someone could help us to find a solution to this problem. sql-server ms-access odbc share|improve this question edited Sep 25 '10 at 19:04 Tony Toews 7,02511324 asked Sep 24 '10 at 13:21 rodpedja 26116 Does the following give you more error details? ACC2000: How to Trap Specific ODBC Error Messages You can use the Errors collection to trap specific Open Database Connectivity (ODBC) errors. However, you must loop through all of the elements in the collection to access the ODBC
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 runtime error 3151 odbc connection failed access 2010 Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack
Microsoft Visual Basic Runtime Error 3151 Odbc Connection Failed
Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up MS Access error runtime error 3151 odbc connection failed access 2013 3151 ODBC error --> ORACLE 11G up vote 1 down vote favorite I have an MS Access 2003 DB that was created by a contractor who has now left. The DB uses linked tables and DAO to connect to an ORACLE backend. It http://stackoverflow.com/questions/3787484/odbc-call-failed-error-3151 used to work until we recently upgraded our ORACLE version from 10g to 11g. As part of the upgrade we had to update our rather out dated "Microsoft ODBC for ORACLE" driver to "Oracle in instantclient11_1" thats forms part of the ORACLE Instant Client. When we run the VBA it returns error code 3151 and says "ODBC --connection to 'MYDB' failed. I did a bit of googling and found that code 3151 is a generic code. However sometimes this works and other times(80% of the time) it http://stackoverflow.com/questions/11956101/ms-access-error-3151-odbc-error-oracle-11g doesn't. Its installed on an MS Xp SP3 32bit machine and the drivers are 32-bit. From The ODBC Manager when I run the test connection it is always successful and I can query the DB from within excel and using the "Import External data" Any idea how I can resolve this? ms-access odbc oracle11g dao share|improve this question asked Aug 14 '12 at 15:48 Alistair Laing 7861616 In my relatively limited dealings with Oracle, I have read that the Instant Clients can present their own peculiar set of problems. You might consider removing/uninstalling the Instant Client and go with the conventional client setup and see if that solves your problem. –David W Aug 14 '12 at 15:54 Are you sure the DSN name is the same as before? If not, you will need to rename to DSN to what Access is looking for, or update the linked table definitions in Access. –nicholas Aug 14 '12 at 16:29 How do you connect in both cases to oracle? –steve Aug 15 '12 at 2:14 @nicholas I'm using the same DSN name. I have removed the old one to ensure theres, no conflict –Alistair Laing Aug 15 '12 at 9:30 @DavidW could you explain what you mean by "conventional client setup"? –Alistair Laing Aug 15 '12 at 9:31 | show 2 more comments active oldest votes Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook. Your Answer draft saved draft discard
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 7,2000 » Administration » Getting run-time error 3151 ODBC connection... http://www.sqlservercentral.com/Forums/Topic446169-5-1.aspx 21 posts,Page 1 of 3123»»» Getting run-time error 3151 ODBC connection to ... failed http://www.utteraccess.com/forum/index.php?showtopic=2028787 Rate Topic Display Mode Topic Options Author Message pete.doylepete.doyle Posted Tuesday, January 22, 2008 5:12 PM Forum Newbie Group: General Forum Members Last Login: Monday, January 28, 2008 4:02 PM Points: 8, Visits: 17 Hi - hope someone can help.I've inherited the maintenance and support of a SQL Server 2000 database with an Access 2000 based front-end, running error 3151 on an SBS 2003 server. All worked fine up until yesterday when trying to login using the usual username/password gives the above 3151 error. The line in the VB which generates this is: Set rstRoles = sfdb.OpenRecordset("Roles", dbOpenDynaset, dbSeeChanges)which is opening a simple table of roles to check which level the given user is at. Two things:1 I've noticed the transaction log is huge (12 GB) and had just run out of space error 3151 odbc to grow, but having freed up plenty more disk space, I still get the error2 I can open the database in admin mode and view the tables as normal. Just can't run the front end which the users need.I noticed one post which recommended running the linked tables utlility, which I've done but no difference.Any thoughts or suggestions welcome.:) Post #446169 Minaz AminMinaz Amin Posted Tuesday, January 22, 2008 11:22 PM Mr or Mrs. 500 Group: General Forum Members Last Login: Thursday, September 10, 2015 1:24 AM Points: 580, Visits: 1,750 Is it possible to post the SQL Server error message. Please go to the LOG folder of the SQL Server and read the error log without any extension. "More Green More Oxygen !! Plant a tree today" Post #446246 pete.doylepete.doyle Posted Wednesday, January 23, 2008 12:46 AM Forum Newbie Group: General Forum Members Last Login: Monday, January 28, 2008 4:02 PM Points: 8, Visits: 17 Hi - thanks for the speedy response - I really appreciate it.I've extracted the error message plus the contents of the last 2 error logs into the attached Word document. I can't see anything wrong, but hopefully you might!!ThanksPete Post Attachments SQL Screens.doc (68 views, 106.00 KB) Post #446265 Minaz AminMinaz Amin Posted Wednesday, January 23, 2008 1:53
Custom Search UtterAccess Forums>Microsoft® Access>Access Errors + Error Handling Inconsistent Error 3151, Odbc Connection Failed, Access 2013 Forum HomeSearchHelpUA Messages|-- UtterAccess.com NewsAccess Knowledge Center|-- Access Code Archive|-- Access Knowledgebase / FAQ|-- Access TutorialsMicrosoft® Access|-- Local Access User Groups (AUGs)|-- Interface Design|-- Access Q and A|-- Access Tables + Relationships|-- Access Queries|-- Access Forms|-- Access Reports|-- Access Macros|-- Access Modules|-- Access Date + Time|-- Access Errors + Error Handling|-- Access Built-in Functions|-- Access Searching + Data Mining|-- Access Records|-- Access Security|-- Access Automation|-- Access Database Container|-- Tool bars, Menu bars + Ribbon|-- Access Services (Web Databases)|-- Access Data Access Pages (Deprecated)|-- Access Data Projects - ADP|-- Access Runtime, Packaging & DeploymentAnd More...|-- Microsoft SQL Server|-- SQL Server Reporting Services|-- Microsoft SharePoint|-- Microsoft Internet Explorer|-- Visual Basic 6 and Earlier|-- Visual Basic 2003 and Later|-- ASP and VBScript|-- Web Development|-- PHP, Perl, MySQL and Postgres|-- Other Database Engines|-- BI Tools and Applications|-- JAVA and C#|-- GraphicsMicrosoft® Office|-- Microsoft Excel|-- Microsoft Excel FAQs|-- Microsoft Word|-- Microsoft Outlook|-- Microsoft PowerPoint|-- Microsoft FrontPage/Exp. Web|-- Other Microsoft ProductsPC|-- Network Issues|-- Q & A - Hardware|-- Q & A - Software|-- Q & A - Other PC|-- Virus + Security DiscussionUtterAccess Odds and Ends|-- General Chat|-- Q & A - UtterAccess.com Forums|-- Q & A - Access Wiki Options SebulbaView Member Profile May 20 2015, 04:47 PM Post#1Posts: 18Joined: 2-October 11I am using a pass-through query to get data from an Oracle DB via an ODBC connection. The query, qryD_OraclePeek, has the user credentials hard-coded in the ODBC conne