Re: Accessing Oracle via Web Service and IIS

Tech-Archive recommends: Fix windows errors by optimizing your registry

David

Are you disposing of your database related objects explicitly?

Glenn

"David++" <David@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:72C986A8-9146-4D6E-8098-06FDA904AAEA@xxxxxxxxxxxxxxxx
Hi Glenn,

Thanks for the reply. I had a look again at the IIS configuration for the
Website which I created to test the Web Service from. It seems that I was
not
giving enough priveleges to the Virtual Directory for that website. By
default I think it only has 'Read' as an option, so I checked Write,
Script
Source Access, and Directory Browsing and this solved the problem... just
a
slight error on my behalf!

The problem I have now is that the Oracle requests I make are not as fast
at
all as when running them through the VS2005 built in server, in fact they
seem to begin to fail when I continually call a test method of the Web
Service very quickly i.e. every second or 0.5 second. I also got an error
about 'connection pooling' so I think I will now look into that.

Oh well, onwards and upwards...

Cheers,
David

"Glenn" wrote:

David

The connection string "Data Source" property can't be matching any entry
in
the tnsnames.ora file on the server executing the code. Are you running
with multiple Oracle homes?

If your using ODP.NET, which I would recommend you do, you could always
check what data sources are available from the current home. Take a
look
at

http://download-uk.oracle.com/docs/html/B28089_01/OracleDataSourceEnumerator
Class.htm#CHDEHJCE

Glenn

"David++" <David@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:807C329C-96F0-4430-A008-4CE81D04F88A@xxxxxxxxxxxxxxxx
Hi,

I have been developing Web Services in VS2005. Usually I use the built
in
server in VS2005 to test and develop the Web Service.

However I now want to make this Web Service available to other
computers
(and applications) in our local company network.

When the service runs it accesses an Oracle database and pulls some
data
out. It works fine when running in VS2005 server. To allow the Web
Service
to
be used by others I have created a Web Site in IIS and placed the Web
Service
and its files in their. The IIS server I have started running. I am
able
to
access and use the Web Service from other machines via the IIS server,
the
problem is when I try to connect to the Oracle database it fails -

Database error: ORA-12154: TNS:could not resolve the connect
identifier
specified

This also happens when I use my local machine and access the Web
Service
via
IIS locally, even though it succeeds when I run the same Web Service
from
the
VS2005 built in Server.

Do I have to add the database to IIS or somehow configure IIS to point
to
the database, or the TNSNAMES.ora file??

Thanks for any tips,
David





.

Relevant Pages

  • WSE 3.0 Running under default ASPNet user
    ... UsernameTokenManager which needs to access a remote database. ... service is set up in IIS to use anonymous access with a UserID and Password ... The web service needs to access a database on a remote server, ... UsernameTokenManager class) the database access is done via the ASPNET ...
    (microsoft.public.dotnet.framework.webservices.enhancements)
  • Re: Accessing Oracle via Web Service and IIS
    ... The OracleConnection object is a private member of the web service class. ... Are you disposing of your database related objects explicitly? ... The problem I have now is that the Oracle requests I make are not as fast ... The connection string "Data Source" property can't be matching any entry ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: Accessing Oracle via Web Service and IIS
    ... Dispose() has helped a lot. ... I just downloaded the ODP.NET tools from Oracle. ... using the OracleConnection class for Oracle database stuff, ... The OracleConnection object is a private member of the web service class. ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: Accessing Oracle via Web Service and IIS
    ... The OracleConnection object is a private member of the web service class. ... Are you disposing of your database related objects explicitly? ... The problem I have now is that the Oracle requests I make are not as ... The connection string "Data Source" property can't be matching any ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: Oracle connectivity
    ... You haven't said whether you are working with Oracle Lite on the device ... Oracle.Lite.Data.dll which is a .NETCF provider for the database. ... > - Execute an Oracle PL/SQL stored procedure designed to return ... > Write a Web Service, most likely of the XML variety, to run on the host. ...
    (microsoft.public.dotnet.framework.compactframework)