Re: Accessing Oracle via Web Service and IIS

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

  • Re: IIS Hosting Webservice which accesses a COM server
    ... I've create a COM server in VFP which I try to access from a Webservice ... If you want to run executables on IIS from a script (i.e. an ASP, ASP.Net, ... well as Web Service Extension for the appropriate Script Engine. ...
    (microsoft.public.inetserver.iis.security)
  • Re: interprocess comms in local network
    ... Server needs to be an application with buttons and menus as it will need to ... I also need to set up permissioning such that only clients that I've ... > ASP.NET provides support for implementing a web service. ... > If IIS was installed when you installed the .NET Framework, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: IIS 6.0 quits responding
    ... Your setup for Windows Server 2003 sounds fine. ... have no idea how SNMP is able to tell that IIS is not working. ... The SNMP Monitoring on another server is showing that Web Service is not ...
    (microsoft.public.inetserver.iis)
  • Re: Calling a Web Service?
    ... the Business will not allow the AIX server to be on the ... So my issue remains how do I call a web service when I can't see IIS? ... you wrote some sort of proxy, how would the AIX box know how to access it? ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: Help connecting to Access DB from web service
    ... The Access database is located on a different server than ... While developing / debugging the web service is hosted on my development ... When deployed it is being host with IIS. ... What are the differences between the 'ASP.NET Development Server' and IIS ...
    (microsoft.public.dotnet.framework.adonet)