Oracle Client Namespace

[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

 

[Miha Markic]

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.

 

[Ravi]

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

 

[Miha Markic]

Hi Ravi,

Seems that hostname is too long - can you shorten it?
Read the thread:
http://groups.google.com/groups?hl=...e=UTF-8&oe=UTF-8&as_ugroup=*dotnet*&lr=&hl=en

 

[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.

 

[Lyndon Hills]

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.

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.