| System error 998 - Oracle ODBC Driver issue [message #178831] |
Fri, 23 June 2006 00:51  |
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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
