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
8  14279 
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
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
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
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
>
>
>
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
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
>
>
>
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
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
>
>
>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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...
|
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...
|
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....
|
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...
|
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...
|
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...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |
