By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,365 Members | 1,245 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,365 IT Pros & Developers. It's quick & easy.

Accessing Oracle via Web Service and IIS

P: n/a
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
Mar 13 '07 #1
Share this Question
Share on Google+
8 Replies


P: n/a
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/h...urceEnumerator
Class.htm#CHDEHJCE

Glenn

"David++" <Da***@discussions.microsoft.comwrote in message
news:80**********************************@microsof t.com...
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

Mar 14 '07 #2

P: n/a
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/h...urceEnumerator
Class.htm#CHDEHJCE

Glenn

"David++" <Da***@discussions.microsoft.comwrote in message
news:80**********************************@microsof t.com...
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


Mar 14 '07 #3

P: n/a
David

Are you disposing of your database related objects explicitly?

Glenn

"David++" <Da***@discussions.microsoft.comwrote in message
news:72**********************************@microsof t.com...
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/h...urceEnumerator
Class.htm#CHDEHJCE

Glenn

"David++" <Da***@discussions.microsoft.comwrote in message
news:80**********************************@microsof t.com...
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

Mar 14 '07 #4

P: n/a
Hi Glenn,

I generally do something of the form -

public bool Test(ref string _result)
{
oleConn = new OracleConnection();

try
{
oleConn.Open();

// Do some database stuff

_result = someValue;

return true
}
catch(Exception ex)
{
_result = ex.Message;

return false;
}
finally
{
oleConn.Close();
}
}

The OracleConnection object is a private member of the web service class. I
do not currently call the Dispose() method on the OracleConnection object.
Maybe I should be doing that to clean up instantly the resources allocated to
that instance? So in the 'finally' we would have -

finally
{
oleConn.Close();
oleConn.Dispose();
}

do you think that is better?

Cheers,
david
"Glenn" wrote:
David

Are you disposing of your database related objects explicitly?

Glenn

"David++" <Da***@discussions.microsoft.comwrote in message
news:72**********************************@microsof t.com...
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/h...urceEnumerator
Class.htm#CHDEHJCE
>
Glenn
>
"David++" <Da***@discussions.microsoft.comwrote in message
news:80**********************************@microsof t.com...
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
>
>
>


Mar 15 '07 #5

P: n/a
David

Definately go with the Dispose().

BTW have you got some more detail on the exception?

Glenn

"David++" <Da***@discussions.microsoft.comwrote in message
news:BB**********************************@microsof t.com...
Hi Glenn,

I generally do something of the form -

public bool Test(ref string _result)
{
oleConn = new OracleConnection();

try
{
oleConn.Open();

// Do some database stuff

_result = someValue;

return true
}
catch(Exception ex)
{
_result = ex.Message;

return false;
}
finally
{
oleConn.Close();
}
}

The OracleConnection object is a private member of the web service class.
I
do not currently call the Dispose() method on the OracleConnection object.
Maybe I should be doing that to clean up instantly the resources allocated
to
that instance? So in the 'finally' we would have -

finally
{
oleConn.Close();
oleConn.Dispose();
}

do you think that is better?

Cheers,
david
"Glenn" wrote:
>David

Are you disposing of your database related objects explicitly?

Glenn

"David++" <Da***@discussions.microsoft.comwrote in message
news:72**********************************@microso ft.com...
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/h...urceEnumerator
Class.htm#CHDEHJCE

Glenn

"David++" <Da***@discussions.microsoft.comwrote in message
news:80**********************************@microsof t.com...
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



Mar 15 '07 #6

P: n/a
Hi Glenn,

Dispose() has helped a lot.

About the exception I was getting I didnt save it from before and it has not
re-apeared since making the changes. If it reappears at some point no doubt I
will be googling and searching on here for the remedy.

BTW, I just downloaded the ODP.NET tools from Oracle. I havent installed
them yet (they may even be installed already on this machine?). I have been
using the OracleConnection class for Oracle database stuff, would you say
ODP.NET is the way to go for best Oracle performance?

Cheers,
David

"Glenn" wrote:
David

Definately go with the Dispose().

BTW have you got some more detail on the exception?

Glenn

"David++" <Da***@discussions.microsoft.comwrote in message
news:BB**********************************@microsof t.com...
Hi Glenn,

I generally do something of the form -

public bool Test(ref string _result)
{
oleConn = new OracleConnection();

try
{
oleConn.Open();

// Do some database stuff

_result = someValue;

return true
}
catch(Exception ex)
{
_result = ex.Message;

return false;
}
finally
{
oleConn.Close();
}
}

The OracleConnection object is a private member of the web service class.
I
do not currently call the Dispose() method on the OracleConnection object.
Maybe I should be doing that to clean up instantly the resources allocated
to
that instance? So in the 'finally' we would have -

finally
{
oleConn.Close();
oleConn.Dispose();
}

do you think that is better?

Cheers,
david
"Glenn" wrote:
David

Are you disposing of your database related objects explicitly?

Glenn

"David++" <Da***@discussions.microsoft.comwrote in message
news:72**********************************@microsof t.com...
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/h...urceEnumerator
Class.htm#CHDEHJCE
>
Glenn
>
"David++" <Da***@discussions.microsoft.comwrote in message
news:80**********************************@microsof t.com...
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
>
>
>


Mar 15 '07 #7

P: n/a
David

To be honest I've not compared the performance, but it's designed by Oracle
for Oracle so I would hope to see better performance than the supplied MS
component. Actually, we chose it not for performance reasons but for its
capabilities particularly with XML and bulk inserts. However, there is a
downside to ODP.net, the DataSet designer won't work with it, although I
understand this may be remedied in a release this year. So it's down to a
choice based on the application requirements.

Glenn

"David++" <Da***@discussions.microsoft.comwrote in message
news:46**********************************@microsof t.com...
Hi Glenn,

Dispose() has helped a lot.

About the exception I was getting I didnt save it from before and it has
not
re-apeared since making the changes. If it reappears at some point no
doubt I
will be googling and searching on here for the remedy.

BTW, I just downloaded the ODP.NET tools from Oracle. I havent installed
them yet (they may even be installed already on this machine?). I have
been
using the OracleConnection class for Oracle database stuff, would you say
ODP.NET is the way to go for best Oracle performance?

Cheers,
David

"Glenn" wrote:
>David

Definately go with the Dispose().

BTW have you got some more detail on the exception?

Glenn

"David++" <Da***@discussions.microsoft.comwrote in message
news:BB**********************************@microso ft.com...
Hi Glenn,

I generally do something of the form -

public bool Test(ref string _result)
{
oleConn = new OracleConnection();

try
{
oleConn.Open();

// Do some database stuff

_result = someValue;

return true
}
catch(Exception ex)
{
_result = ex.Message;

return false;
}
finally
{
oleConn.Close();
}
}

The OracleConnection object is a private member of the web service
class.
I
do not currently call the Dispose() method on the OracleConnection
object.
Maybe I should be doing that to clean up instantly the resources
allocated
to
that instance? So in the 'finally' we would have -

finally
{
oleConn.Close();
oleConn.Dispose();
}

do you think that is better?

Cheers,
david
"Glenn" wrote:

David

Are you disposing of your database related objects explicitly?

Glenn

"David++" <Da***@discussions.microsoft.comwrote in message
news:72**********************************@microso ft.com...
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/h...urceEnumerator
Class.htm#CHDEHJCE

Glenn

"David++" <Da***@discussions.microsoft.comwrote in message
news:80**********************************@microsof t.com...
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




Mar 15 '07 #8

P: n/a
Hi Glenn,

I'm keen to have a go with ODP.NET now as we'll be doing exactly that type
of thing here, transferring data in XML to and from an Oracle database via a
Web Service. Sounds like ODP.NET might be a good choice for that.

Well, no doubt I will take a close look tomorrow.

Cheers again,
David

"Glenn" wrote:
David

To be honest I've not compared the performance, but it's designed by Oracle
for Oracle so I would hope to see better performance than the supplied MS
component. Actually, we chose it not for performance reasons but for its
capabilities particularly with XML and bulk inserts. However, there is a
downside to ODP.net, the DataSet designer won't work with it, although I
understand this may be remedied in a release this year. So it's down to a
choice based on the application requirements.

Glenn

"David++" <Da***@discussions.microsoft.comwrote in message
news:46**********************************@microsof t.com...
Hi Glenn,

Dispose() has helped a lot.

About the exception I was getting I didnt save it from before and it has
not
re-apeared since making the changes. If it reappears at some point no
doubt I
will be googling and searching on here for the remedy.

BTW, I just downloaded the ODP.NET tools from Oracle. I havent installed
them yet (they may even be installed already on this machine?). I have
been
using the OracleConnection class for Oracle database stuff, would you say
ODP.NET is the way to go for best Oracle performance?

Cheers,
David

"Glenn" wrote:
David

Definately go with the Dispose().

BTW have you got some more detail on the exception?

Glenn

"David++" <Da***@discussions.microsoft.comwrote in message
news:BB**********************************@microsof t.com...
Hi Glenn,

I generally do something of the form -

public bool Test(ref string _result)
{
oleConn = new OracleConnection();

try
{
oleConn.Open();

// Do some database stuff

_result = someValue;

return true
}
catch(Exception ex)
{
_result = ex.Message;

return false;
}
finally
{
oleConn.Close();
}
}

The OracleConnection object is a private member of the web service
class.
I
do not currently call the Dispose() method on the OracleConnection
object.
Maybe I should be doing that to clean up instantly the resources
allocated
to
that instance? So in the 'finally' we would have -

finally
{
oleConn.Close();
oleConn.Dispose();
}

do you think that is better?

Cheers,
david
"Glenn" wrote:

David

Are you disposing of your database related objects explicitly?

Glenn

"David++" <Da***@discussions.microsoft.comwrote in message
news:72**********************************@microsof t.com...
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/h...urceEnumerator
Class.htm#CHDEHJCE
>
Glenn
>
"David++" <Da***@discussions.microsoft.comwrote in message
news:80**********************************@microsof t.com...
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
>
>
>



Mar 15 '07 #9

This discussion thread is closed

Replies have been disabled for this discussion.