Oracle Client Namespace

  • Thread starter Thread starter Ravi
  • Start date Start date
R

Ravi

I am getting an error
ORA-12154: TNS:could not resolve service name
the following code i am using

Dim oraconn As New OracleConnection("server=exxxx1;user
id=xxxxxxx;password=xxxxxx;Integrated Security = true")

The following code generate the error below:
Dim oraconn As New OracleConnection
("server=xxxxx1.xx.xx.com;user
id=xxxxxxx;password=xxxxxx;Integrated Security = true")

ORA-01004: default username feature not supported; logon
denied

Dim oraconn As New OracleConnection("Data
Source=xxxxx1.xx.xx.com;user
id=xxxxxxx;password=xxxxxx;Integrated Security = true")

ORA-01004: default username feature not supported; logon
denied

I tries using oledb and odbc also. I am unable to connect
to the oracle.
I read in one of the articles that since the ASP.NET is
running a impersonate account in the windows it may not
access OCI. But i given Admin acess to asp.net account.

Am i missing something?

Thanks
Ravi
 
Hi Ravi,

You indeed have security issues. Does your Oracle client/server support
integrated security?
Try with this connection string instead:
user id=***;data source=***;password=***
Ah, and don't don't don't give asp.net admin access. It is a really bad
idea.
Rather, give it read access on oracle's folders.
 
Miha Markic,
Thenks for the reply.
I implemented your suggestions. Now i get the following
error:

ORA-00162: external dbid length 17 is greater than maximum
(16)

Ravi
 
No way because lot of applications run on this. Is there
any other way. I am able to connect to oracle thro oledb.
But no sucess with oracle client namespace.
 
No way because lot of applications run on this. Is there
any other way. I am able to connect to oracle thro oledb.
But no sucess with oracle client namespace.
Click to expand...
Unless I misunderstand then it's just the name of the database. Edit
your tnsnames.ora to add an alias that's 16 chars or less.
 
Back
Top