Web Services and Oracle Data Access

[Oriol Tomàs]

Hi,

I want to publish a Web Service who returns a dataset with some data from an
Oracle Database.

In the view designer I can preview data from my OracleDataAdapter1. It
returns 3 rows.

When I start the solution and test the web service it returns this error:
System.Data.OracleClient.OracleException: ORA-12154: TNS:no se ha podido
resolver el nombre de servicio

I suppose that it can't open the connection for security reasons.

Somebody knows the solution?

Thanks!

Oriol Tomàs


System.Data.OracleClient.OracleException: ORA-12154: TNS:no se ha podido
resolver el nombre de servicio

at System.Data.OracleClient.DBObjectPool.GetObject(Ob ject owningObject,
Boolean& isInTransaction)
at
System.Data.OracleClient.OracleConnectionPoolManag er.GetPooledConnection(String
encryptedConnectionString, OracleConnectionString options, OracleConnection
owningObject, Boolean& isInTransaction)
at
System.Data.OracleClient.OracleConnection.OpenInte rnal(OracleConnectionString
parsedConnectionString, Object transact)
at System.Data.OracleClient.OracleConnection.Open()
at System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
ConnectionState& originalState)
at System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at WebService4.Service1.HelloWorld() in
c:\inetpub\wwwroot\WebService4\Service1.asmx.vb:li ne 169

[Mike]

it can't find your database. Verify that the TNS name is correct and it does
exist

"Oriol TomÃ*s" wrote:

Hi,

I want to publish a Web Service who returns a dataset with some data from an
Oracle Database.

In the view designer I can preview data from my OracleDataAdapter1. It
returns 3 rows.

When I start the solution and test the web service it returns this error:
System.Data.OracleClient.OracleException: ORA-12154: TNS:no se ha podido
resolver el nombre de servicio

I suppose that it can't open the connection for security reasons.

Somebody knows the solution?

Thanks!

Oriol TomÃ*s


System.Data.OracleClient.OracleException: ORA-12154: TNS:no se ha podido
resolver el nombre de servicio

at System.Data.OracleClient.DBObjectPool.GetObject(Ob ject owningObject,
Boolean& isInTransaction)
at
System.Data.OracleClient.OracleConnectionPoolManag er.GetPooledConnection(String
encryptedConnectionString, OracleConnectionString options, OracleConnection
owningObject, Boolean& isInTransaction)
at
System.Data.OracleClient.OracleConnection.OpenInte rnal(OracleConnectionString
parsedConnectionString, Object transact)
at System.Data.OracleClient.OracleConnection.Open()
at System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
ConnectionState& originalState)
at System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at WebService4.Service1.HelloWorld() in
c:\inetpub\wwwroot\WebService4\Service1.asmx.vb:li ne 169

[Dino Chiesa [Microsoft]]

sounds like a security issue. the webservice runs as user "ASPNET" and
probably visual studio runs under your own identity. this is the likely
source of the problem.

you need to set the oracle config for the aspnet user.
"Oriol Tomàs" <ad***@ad-hoc.net> wrote in message
news:ep**************@TK2MSFTNGP10.phx.gbl...

Hi,

I want to publish a Web Service who returns a dataset with some data from
an Oracle Database.

In the view designer I can preview data from my OracleDataAdapter1. It
returns 3 rows.

When I start the solution and test the web service it returns this error:
System.Data.OracleClient.OracleException: ORA-12154: TNS:no se ha podido
resolver el nombre de servicio

I suppose that it can't open the connection for security reasons.

Somebody knows the solution?

Thanks!

Oriol Tomàs


System.Data.OracleClient.OracleException: ORA-12154: TNS:no se ha podido
resolver el nombre de servicio

at System.Data.OracleClient.DBObjectPool.GetObject(Ob ject owningObject,
Boolean& isInTransaction)
at
System.Data.OracleClient.OracleConnectionPoolManag er.GetPooledConnection(String
encryptedConnectionString, OracleConnectionString options,
OracleConnection owningObject, Boolean& isInTransaction)
at
System.Data.OracleClient.OracleConnection.OpenInte rnal(OracleConnectionString
parsedConnectionString, Object transact)
at System.Data.OracleClient.OracleConnection.Open()
at System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
ConnectionState& originalState)
at System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at WebService4.Service1.HelloWorld() in
c:\inetpub\wwwroot\WebService4\Service1.asmx.vb:li ne 169