Home » Infrastructure » Windows » System error 998 - Oracle ODBC Driver issue
System error 998 - Oracle ODBC Driver issue [message #178831] Fri, 23 June 2006 00:51 Go to next message
shilpa_sudhakar
Messages: 25
Registered: March 2006
Location: Australia
Junior Member
Hi All,

Today morning we restarted our production server. Since then we are not able to connect to Oracle from Visual Basic and also from DOS Prompt.

The following are the scenarios where 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, 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 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
Re: System error 998 - Oracle ODBC Driver issue [message #178836 is a reply to message #178831] Fri, 23 June 2006 01:15 Go to previous messageGo to next message
aciolac
Messages: 242
Registered: February 2006
Senior Member
One question - you are started sqlplus from your local machine?
Re: System error 998 - Oracle ODBC Driver issue [message #178838 is a reply to message #178836] Fri, 23 June 2006 01:22 Go to previous messageGo to next message
shilpa_sudhakar
Messages: 25
Registered: March 2006
Location: Australia
Junior Member
Hi,

Yes, i am using from my local system. But i have administrator privileges.

Thanks,
Shilpa
Re: System error 998 - Oracle ODBC Driver issue [message #178839 is a reply to message #178838] Fri, 23 June 2006 01:25 Go to previous messageGo to next message
aciolac
Messages: 242
Registered: February 2006
Senior Member
Make the following:
C:>sqlplus /nolog
...........
SQL> connect your_prod_database

And see if you will be able to connect to your database.
Re: System error 998 - Oracle ODBC Driver issue [message #178841 is a reply to message #178839] Fri, 23 June 2006 01:27 Go to previous messageGo to next message
shilpa_sudhakar
Messages: 25
Registered: March 2006
Location: Australia
Junior Member
I tried running using

c:\sqlplus /nolog

I get back the prompt as below
c:\
Re: System error 998 - Oracle ODBC Driver issue [message #178845 is a reply to message #178841] Fri, 23 June 2006 01:31 Go to previous messageGo to next message
aciolac
Messages: 242
Registered: February 2006
Senior Member
Are you sure that OraClinet on your machine works fine? Possible this is the cause of problem. Try to resolve problems of OraClient, and try again to connect from VB.
Re: System error 998 - Oracle ODBC Driver issue [message #178850 is a reply to message #178845] Fri, 23 June 2006 01:50 Go to previous messageGo to next message
shilpa_sudhakar
Messages: 25
Registered: March 2006
Location: Australia
Junior Member
What exactly should i check to see if OraClient is working fine or not.

Please let me know.

Thanks!
Re: System error 998 - Oracle ODBC Driver issue [message #178851 is a reply to message #178850] Fri, 23 June 2006 01:52 Go to previous message
aciolac
Messages: 242
Registered: February 2006
Senior Member
Smile
C:>sqlplus /nolog
...........
SQL> connect your_prod_database

usually there are necessary to reinstall OraClient.
Previous Topic: ORA-12899 / Singlebyte Charset
Next Topic: Which oracle version to install ?
Goto Forum:
  


Current Time: Sun Oct 24 07:59:14 CDT 2021