lobos
asked on
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.....
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.....
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.
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.
ASKER
"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?
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?
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=pat
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=pat
ASKER
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?
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?
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.
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.
ASKER
That did the trick. :)
when does this happen ?
the ORA-12638 refers to authentication. you can even see it at the Credential retrieval failed
Guy