Oracle 10g Odbc Driver Error 998
Contents |
Driver issue [message #178831] Fri, 23 June 2006 00:51 shilpa_sudhakar Messages: 25Registered: March 2006 Location: Australia Junior Member Hi All, Today morning we
Odbc Driver Could Not Be Loaded Due To System Error Code 998
restarted our production server. Since then we are not able to system error code 998 invalid access to memory location connect to Oracle from Visual Basic and also from DOS Prompt. The following are the scenarios where the setup routines for the oracle in error code 998 invalid access to memory location i tried accessing Oracle. 1) I have an Excel sheet where vba code is written.I try running the code and get the error Quote: "Catastrophic failure" When i debug,
Odbc Driver Could Not Be Loaded Due To System Error Code 998 Invalid Access To Memory Location
the error occurs at the connection to Oracle Quote: Set conn = CreateObject("ADODB.Connection") conn.Open "Provider=MSDAORA; Data Source='PRD'; USER ID='user';password='abcde';" 2) In the DOS Prompt, i go to the ORACLE PATH and then type sqlplus. But the sqlplus screen does not appear. 3) Start->Settings->Control Panel->Administrative Tools-> Data Sources Here, i try to add DataSource under User DSN or for
Specified Driver Could Not Be Loaded Due To System Error 998 Invalid Access To Memory Location
that matter to any other DSN. I get the following error: Quote: "The setup routines for the Microsoft ODBC for Oracle ODBC Driver could not be loaded due to system error code 998" I would like to know if there is any problem with the ODBC Driver. The system was fine till yesterday. The problem is only after we restarted the server today morning. Thanks and Regards, Shilpa Report message to a moderator Re: System error 998 - Oracle ODBC Driver issue [message #178836 is a reply to message #178831] Fri, 23 June 2006 01:15 aciolac Messages: 242Registered: February 2006 Senior Member One question - you are started sqlplus from your local machine? Report message to a moderator Re: System error 998 - Oracle ODBC Driver issue [message #178838 is a reply to message #178836] Fri, 23 June 2006 01:22 shilpa_sudhakar Messages: 25Registered: March 2006 Location: Australia Junior Member Hi, Yes, i am using from my local system. But i have administrator privileges. Thanks, Shil
FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just http://www.orafaq.com/forum/t/65255/ copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Oracle: Oracle release 10g Forum at Tek-Tips HomeForumsProgrammersDBMS PackagesOracle: Oracle release 10g Forum Setting an ODBC Driver thread1177-1503313 Forum Search FAQs Links MVPs Setting an ODBC Driver Setting an ODBC Driver ddrillich (TechnicalUser) (OP) 26 Sep 08 16:06 Good Day,When trying to set an ODBC Driver I get the following error http://www.tek-tips.com/viewthread.cfm?qid=1503313 -The setup routines for the Oracle in OraClient10g_home1 ODBC driver could not be loaded due to system error code 998.Any ideas?Regards,Dan RE: Setting an ODBC Driver Turkbear (TechnicalUser) 27 Sep 08 15:29 Hi, Any of these help?:http://forums.oracle.com/forums/thread.jspa?messageID=2440839thread759-744002: Unable to add System DSN on one machinehttp://lists.lug.ro/pipermail/offtopic/2005-June/019879.html To Paraphrase:"The Help you get is proportional to the Help you give.." RE: Setting an ODBC Driver ddrillich (TechnicalUser) (OP) 30 Sep 08 22:45 Thank you Turkbear! I haven't had time yet to look into it...Regards,Dan Red Flag This Post Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. Cancel Red Flag SubmittedThank you for helping keep Tek-Tips Forums free from inappropriate posts.The Tek-Tips staff will check this out and take appropriate action. Close Reply To This Thread Posting in the Tek-Tips forums is a member-only feature. Click Here to join Tek-Tips and talk with other members! Resources Join | Indeed Jobs | Advertise Copyright © 1998-2016 ENGINEERING.com, Inc. All rights reserved.Unauthorized reproduction or linking forbidden without expressed written permission. Registration on or use of this site constitutes acceptance of our Privacy Policy. Close Box Join Tek-Tips Today! J
comment Problem ODBC driver could not be loaded due to system error code 998 https://deryaoktay.wordpress.com/tag/error-code-998/ Cause The problem arose because application, Oracle client and Windows does not match properly as 32bit or 64 bit. I have Windows 2003 64 bit, Oracle 10.2 https://docs.google.com/document/d/11n_vJEMrs2stI_1rTH5v_zGl4fDNsuZnHvSpznP33uA/edit 32 bit Client and 64 bit application. After googleing around, I found that there is two versions of odbc datasource administrator: The default one, is 64 bit system error which we use Start menu for opening it. In order to open the 32 bit version I used: %windir%\SysWOW64\odbcad32.exe. With the help of 32 bit version datasource administrator, I could see my 32 bit odbc driver listed. I extracted this rule of thumb: If your application is 32 bit, then your data source must use error code 998 Oracle 32 bit client as well. Last words, beware of 3 pieces: 1- your application (which uses DSN definition), 2- Oracle client 3-data source administrator All pieces must have same version, in my case it is 64 bit and therefore I installed 64 bit client. Further reading: http://support.microsoft.com/kb/942976 Categories: problem-cause-solution, tips Tags: 32 bit, 64 bit, error code 998, ODBC error RSS feed Google Youdao Xian Guo Zhua Xia My Yahoo! newsgator Bloglines iNezha Categories academy links Philosophic presentation problem-cause-solution Project Management rman tips ubuntu Uncategorized Blogs I FollowDon CharismaCarol no Mundo!Blog do PHPnimaidbaTechExtract(Read) > Transform(Test&Apply) > Load(Learn) BlogWordPress.comGurcan Orhan's ODI and DWH BlogLiang's BlogRecent Comments Raja on "ORA-14006: invalid part…Arnaud S on expdp with sys without knowing…trantuananh24hg on Why are we using root cause…Adrian on Why parallel expdp gives unabl…Sangeeta on "Prerequisite check… Top Create a free website or blog at WordPress.com. Don Charismabecause anything is possible with CharismaCarol no Mundo!Aventuras de uma intercambista a trabalho pelo mundo!Blog do PHPOracle DBA
odbc driver error 998Открыть доступЭта версия Firefox больше не поддерживается. Установите поддерживаемую версию браузера.ЗакрытьФайлПравкаВидИнструментыСправкаСпециальные возможностиОтладкаПоследние измененияСпециальные возможностиТолько просмотрВключить или выключить программу чтения с экрана