Solved

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

Posted on 2002-07-04
9
1,716 Views
Last Modified: 2011-10-03
I get this error and the help doesn't tell me much on how to solve it.

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC driver for Oracle][Oracle]ORA-12638: Credential retrieval failed

I have no idea why this does not work
0
Comment
Question by:lobos
  • 5
  • 4
9 Comments
 
LVL 1

Expert Comment

by:gsalman
ID: 7130754
what are you trying to do?
when does this happen ?
the ORA-12638 refers to authentication. you can even see it at the Credential retrieval failed
Guy
0
 
LVL 1

Accepted Solution

by:
gsalman earned 50 total points
ID: 7130756
Here is your solution:
Comment out the Sqlnet.Authentication_services = (NTS) in client "sqlnet.ora" under O_H\network\admin.
G
0
 

Author Comment

by:lobos
ID: 7131871
What does this commenting do?

I have a asp page that is connecting to the oracle database with a valid user that exists on that machine. I tried using SQL Plus and connecting to the db on that machine and it works. But when I try this asp page (something I have done for the last 3 years) and never had this problem.....
0
 
LVL 1

Expert Comment

by:gsalman
ID: 7131926
the ODBC \ OLEDB \ OO4O allows applications to connect to the DB.
when you use the SQLPLUS in order to connect, it uses SQL-NET whitch uses the TCP/IP protocol or other protocols in order to connect. But for an application like Visual Basic, Access etc..., they have the ability to connect thru a driver in order to share Data. that driver can be ODBC or OLEDB etc...
My guess is that your application uses the ODBC or OLEDB
to connect to the Oracle DB.
the problem here seems to be an authentication problem.
you should refer to the developers/application vendor,
so he can assist you in solving the problem.
It's not an Oracle issue.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:lobos
ID: 7132075
"you should refer to the developers/application vendor.........."
Well I am the developer.
I use the exact same file and try connecting to another machine/server with the same database and everything and I don't get the error......but I do on this machine?
0
 
LVL 1

Expert Comment

by:gsalman
ID: 7132316
Well if you are the developer then you should know how your application connects to the DB.
you can try and use trace  for the client connection to the DB
$HOME/.sqlnet.ora and add
     the lines:
     trace_level_client=16
     trace_file_client=cli
     trace_directory_client=path to the file
     
               

0
 

Author Comment

by:lobos
ID: 7132417
I have done the code a million times and I don't think it's related to that.....
Ok to make things more confusing....sometimes the connection work and connection is made and data is retreived....other times.....I get the error message....
Could it be possible that it's related to connections or licensces or something?
0
 
LVL 1

Expert Comment

by:gsalman
ID: 7134262
hhhmmm....
Well if sometimes it works and other times it doesn't and you didn't change anything in your configuration, then I'd
go for networking problems: NICs, Routers, network cables etc...
but thats only if you didn't change anything in your configuration and sometimes it works and sometimes it doesn't.
0
 

Author Comment

by:lobos
ID: 7188142
That did the trick. :)
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Number Format 1 45
sql for Oracle views 8 38
Oracle Syntax 8 42
scheduler for Procedure in DB with 3 arguments in 10g 7 10
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now