Oracle Client Namespace


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
 
Ad

Advertisements

M

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

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
 
R

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

Advertisements

L

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

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Oracle Client 5
Where's my Oracle namespace? 1
Oracle Client Issue 2
Bug in Oracle Client 2
Install Oracle Client 3
Oracle Client and ADO.NET 3
Multiple Oracle Clients 0
Oracle Client Parameters 5

Top