473,856 Members | 1,659 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Accessing Oracle via Web Service and IIS

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
8 14320
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#CHDEH JCE

Glenn

"David++" <Da***@discussi ons.microsoft.c omwrote in message
news:80******** *************** ***********@mic rosoft.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
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#CHDEH JCE

Glenn

"David++" <Da***@discussi ons.microsoft.c omwrote in message
news:80******** *************** ***********@mic rosoft.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
David

Are you disposing of your database related objects explicitly?

Glenn

"David++" <Da***@discussi ons.microsoft.c omwrote in message
news:72******** *************** ***********@mic rosoft.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#CHDEH JCE

Glenn

"David++" <Da***@discussi ons.microsoft.c omwrote in message
news:80******** *************** ***********@mic rosoft.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
Hi Glenn,

I generally do something of the form -

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

try
{
oleConn.Open();

// Do some database stuff

_result = someValue;

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

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

The OracleConnectio n object is a private member of the web service class. I
do not currently call the Dispose() method on the OracleConnectio n 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***@discussi ons.microsoft.c omwrote in message
news:72******** *************** ***********@mic rosoft.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#CHDEH JCE
>
Glenn
>
"David++" <Da***@discussi ons.microsoft.c omwrote in message
news:80******** *************** ***********@mic rosoft.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
David

Definately go with the Dispose().

BTW have you got some more detail on the exception?

Glenn

"David++" <Da***@discussi ons.microsoft.c omwrote in message
news:BB******** *************** ***********@mic rosoft.com...
Hi Glenn,

I generally do something of the form -

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

try
{
oleConn.Open();

// Do some database stuff

_result = someValue;

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

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

The OracleConnectio n object is a private member of the web service class.
I
do not currently call the Dispose() method on the OracleConnectio n 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***@discussi ons.microsoft.c omwrote in message
news:72******* *************** ************@mi crosoft.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#CHDEH JCE

Glenn

"David++" <Da***@discussi ons.microsoft.c omwrote in message
news:80******** *************** ***********@mic rosoft.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
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 OracleConnectio n 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***@discussi ons.microsoft.c omwrote in message
news:BB******** *************** ***********@mic rosoft.com...
Hi Glenn,

I generally do something of the form -

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

try
{
oleConn.Open();

// Do some database stuff

_result = someValue;

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

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

The OracleConnectio n object is a private member of the web service class.
I
do not currently call the Dispose() method on the OracleConnectio n 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***@discussi ons.microsoft.c omwrote in message
news:72******** *************** ***********@mic rosoft.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#CHDEH JCE
>
Glenn
>
"David++" <Da***@discussi ons.microsoft.c omwrote in message
news:80******** *************** ***********@mic rosoft.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
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***@discussi ons.microsoft.c omwrote in message
news:46******** *************** ***********@mic rosoft.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 OracleConnectio n 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***@discussi ons.microsoft.c omwrote in message
news:BB******* *************** ************@mi crosoft.com...
Hi Glenn,

I generally do something of the form -

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

try
{
oleConn.Open();

// Do some database stuff

_result = someValue;

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

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

The OracleConnectio n object is a private member of the web service
class.
I
do not currently call the Dispose() method on the OracleConnectio n
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***@discussi ons.microsoft.c omwrote in message
news:72******* *************** ************@mi crosoft.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#CHDEH JCE

Glenn

"David++" <Da***@discussi ons.microsoft.c omwrote in message
news:80******** *************** ***********@mic rosoft.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
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***@discussi ons.microsoft.c omwrote in message
news:46******** *************** ***********@mic rosoft.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 OracleConnectio n 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***@discussi ons.microsoft.c omwrote in message
news:BB******** *************** ***********@mic rosoft.com...
Hi Glenn,

I generally do something of the form -

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

try
{
oleConn.Open();

// Do some database stuff

_result = someValue;

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

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

The OracleConnectio n object is a private member of the web service
class.
I
do not currently call the Dispose() method on the OracleConnectio n
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***@discussi ons.microsoft.c omwrote in message
news:72******** *************** ***********@mic rosoft.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#CHDEH JCE
>
Glenn
>
"David++" <Da***@discussi ons.microsoft.c omwrote in message
news:80******** *************** ***********@mic rosoft.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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
12386
by: Gilles Cadorel | last post by:
Sur un PC, nous avons installé plusieurs version d'Oracle Client. Plusieurs logiciels tiers utilisant Oracle ne demandent pas lors de leur installation, quelle version d'Oracle utiliser. Ces logiciels fonctionnent correctement mais nous aimerions savoir à coup sûr, quel Client Oracle est réellement utilisé. Merci d'avance
3
5257
by: Jake McDermott | last post by:
We have a few developers that use Oracle 9i (9.2.0.4.0) on their personal workstations for testing purposes. Recently, weve made the decision to upgrade them to WinXP so that they are able to use some other functionalities of the OS, but we are running into a totally odd problem with Oracle. It seems that, Installing Oracle runs just fine, and our ant scripts to build the database work well...but when we reboot the computer, the database...
6
4347
by: Jeff | last post by:
Has anyone had any luck accessing an Oracle database from a web service? I have a C# DLL with various code to query an Oracle database. If I call the methods in this DLL from a Windows Forms application everything works just fine. However, if I call the methods in this DLL from a web service, I receive the following error when the database connection is opened: Error: ORA-12154: TNS:could not resolve service name Does anyone know...
1
1613
by: Dave | last post by:
Hi All I'm having a problem connecting to an Oracle database using C# I have a service name : "SN I have a user id :"UID I have a password : "PWD" I can find snippets of code on the web but am confused as to what refernces to match up with what connection strings I would like to use an Oracle not a Microsoft provider
0
1721
by: Anonymous User | last post by:
Hi, I am working on a mobile application that consists of a number of handheld scanners, an Xml Web service and an Oracle 9i database in a highly secure environment. The .Net Compact Framework application running on the scanners executes Web service methods, which in turn execute Oracle database functions. The Web service and the Oracle database are running on separate servers. The Web service uses the Microsoft OLE DB driver for Oracle....
13
7487
by: Chris Botha | last post by:
The machine is running XP Pro with all the latest service packs, etc. I must access an Oracle database so I installed the Oracle client stuff. I can query Oracle from a Windows app, no problem. Using the exact same code (copy and paste) into a Web app I get the following error "Error while trying to retrieve text for error ORA-01019". Security I thought, so I use Impersonation on the Web site, then the aspnet_wp.exe crashes with "The...
1
3031
by: MAL | last post by:
Hello, I have 2 classes that work great as a windows app to retrieve and process data from an Oracle9i db. When I implement them in a Service program running as Local System, it fails on the .open. I am using OLEDB for Oracle 9.2.0.4. I have verified the Oracle Client install, Local Sys' path variable, and followed MSKB article 259959(Debugging connectivity issues w/ Oracle). Here is the error:
2
4090
by: Mark Brown | last post by:
I'm trying to access an Oracle database vb.net. I found several examples. I tried following each one, but I get the same error no matter what I try. I don't really understand what the error means (I've never tried accessing an Oracle database before). The error I get is: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I installed the oracle dll and added it as reference (I get the same error...
0
3155
by: Temporary | last post by:
C# Web Service in IIS Stops Connecting to Oracle (via ADO.NET) Over Time I have a Web Service, written in C#, published on a Windows XT Web Server under IIS, which repeatedly connects to an Oracle 9x database via ADO, processes, disconnects from the database, and exits. The Web Service is triggered by our Tibco messaging system; in our test environment, it is
0
11063
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10699
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10790
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10390
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9535
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7932
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7098
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5762
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
3
3203
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.