Thanks Craig. i think you are right.the connectString is not set properly.
if i down the ip address, how do i set it?
string connectionString = "Provider=MSDAORA.1;Data source=server;User
ID=username;Password=password";
this is my current setting. i try to replace server with ip+port, it didn't
work either. how do i set it? thanks.
"Craig Deelsnyder" <cdeelsny@NO_SPAM_4_MEyahoo.com> wrote in message
news:eU*************@TK2MSFTNGP09.phx.gbl... wei wrote:
ORA-12154: TNS:could not resolve service name Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: ORA-12154:
TNS:could not resolve service name
looks like something in your connectString is not correct. It should not have to be different for web vs win. I'd check to make sure your web app is setup correctly for database access. Also check the tns settings for your oracle connection on that box.
Actually, maybe it's because of permissions, you can't read the file where the tns values are stored. If this is a dev box, try temporarily changing your user setup in machine.config to SYSTEM instead of machine (it's in the processModel node/section). Then re-run this. See if it works. (and then of course, as a good developer, change machine.config back :-) )
If it fails (which I would hope), then you know it's something with permissions for the aspnet account accessing some Oracle settings/files. Maybe have to give the aspnet user access to that directory. I haven't worked with Oracle in awhile, so I'm drawing from vague
memories... -- Craig Deelsnyder Microsoft MVP - ASP/ASP.NET 2 1777
You do not have a TNS name for the server. With Oracle, you have to have the
Oracle client blah blah on your web machine to connect to Oracle. One of the
items is TNSNames.ora (? - may have spelling wrong). For the server in
question, you have to have a TNS name to use the oracleClient objects.
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
************************************************** *************
Think outside the box!
************************************************** *************
"wei" <wa*****@yahoo.com> wrote in message
news:Os*************@tk2msftngp13.phx.gbl... Thanks Craig. i think you are right.the connectString is not set properly. if i down the ip address, how do i set it? string connectionString = "Provider=MSDAORA.1;Data source=server;User ID=username;Password=password";
this is my current setting. i try to replace server with ip+port, it
didn't work either. how do i set it? thanks. "Craig Deelsnyder" <cdeelsny@NO_SPAM_4_MEyahoo.com> wrote in message news:eU*************@TK2MSFTNGP09.phx.gbl... wei wrote:
ORA-12154: TNS:could not resolve service name Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: ORA-12154: TNS:could not resolve service name
looks like something in your connectString is not correct. It should not have to be different for web vs win. I'd check to make sure your web app is setup correctly for database access. Also check the tns settings for your oracle connection on that box.
Actually, maybe it's because of permissions, you can't read the file where the tns values are stored. If this is a dev box, try temporarily changing your user setup in machine.config to SYSTEM instead of machine (it's in the processModel node/section). Then re-run this. See if it works. (and then of course, as a good developer, change machine.config back :-) )
If it fails (which I would hope), then you know it's something with permissions for the aspnet account accessing some Oracle settings/files. Maybe have to give the aspnet user access to that directory. I haven't worked with Oracle in awhile, so I'm drawing from vague memories... -- Craig Deelsnyder Microsoft MVP - ASP/ASP.NET
You do not have a TNS name for the server. With Oracle, you have to have the
Oracle client blah blah on your web machine to connect to Oracle. One of the
items is TNSNames.ora (? - may have spelling wrong). For the server in
question, you have to have a TNS name to use the oracleClient objects.
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
************************************************** *************
Think outside the box!
************************************************** *************
"wei" <wa*****@yahoo.com> wrote in message
news:Os*************@tk2msftngp13.phx.gbl... Thanks Craig. i think you are right.the connectString is not set properly. if i down the ip address, how do i set it? string connectionString = "Provider=MSDAORA.1;Data source=server;User ID=username;Password=password";
this is my current setting. i try to replace server with ip+port, it
didn't work either. how do i set it? thanks. "Craig Deelsnyder" <cdeelsny@NO_SPAM_4_MEyahoo.com> wrote in message news:eU*************@TK2MSFTNGP09.phx.gbl... wei wrote:
ORA-12154: TNS:could not resolve service name Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: ORA-12154: TNS:could not resolve service name
looks like something in your connectString is not correct. It should not have to be different for web vs win. I'd check to make sure your web app is setup correctly for database access. Also check the tns settings for your oracle connection on that box.
Actually, maybe it's because of permissions, you can't read the file where the tns values are stored. If this is a dev box, try temporarily changing your user setup in machine.config to SYSTEM instead of machine (it's in the processModel node/section). Then re-run this. See if it works. (and then of course, as a good developer, change machine.config back :-) )
If it fails (which I would hope), then you know it's something with permissions for the aspnet account accessing some Oracle settings/files. Maybe have to give the aspnet user access to that directory. I haven't worked with Oracle in awhile, so I'm drawing from vague memories... -- Craig Deelsnyder Microsoft MVP - ASP/ASP.NET
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Mudge |
last post by:
Hi,
My hosting provider only allows me to use 50 connections to my MySQL
database that my Web site will use.
I don't know what this 50 connections means exactly. Does this mean that
only 50...
|
by: pradeep_TP |
last post by:
Hi all,
I have a few questions that I have been wanting to ask for long. These are
all related to ADO.net and specifically to conenction to database.
1) If I have opened a connection to a...
|
by: R Reyes |
last post by:
Hi, I'm trying to modularize my database connections a little better and get
more out of my project with less code.
First check out this common dbOpen() function inside class clsDatabase. I...
|
by: Nick Gilbert |
last post by:
Hi,
I have an asp.net application which runs from a CD-ROM using Cassini. As
such, it is single user only.
The application connects to an Access database when it is loaded, and
keeps the same...
|
by: Lau Lei Cheong |
last post by:
Hello,
Actually I think I should have had asked it long before, but somehow
I haven't.
Here's the scenerio: Say we have a few pages in an ASP.NET project,
each of them needs to connect to...
|
by: Martin B |
last post by:
Hallo!
I'm working with C# .NET 2.0, implementing Client/Server Applications which
are connecting via Network to SQL-Server or Oracle Databases.
To stay independent from the underlaying Database...
|
by: Terry Jolly |
last post by:
Web Solution
Goal: Have a global database connection
Why: (There will be 30+ tables, represented by 30+ classes) I only want to
reference the database connection once.
I put the connection...
|
by: Arsalan Ahmad |
last post by:
Hi all,
I am creating a website in which in an Item detail page there are a number
of web controls (7 or 8) and what is happening that inside each of control's
Page_Load() function I am creating...
|
by: Frinavale |
last post by:
How To Use A Database In Your Program
Many .NET solutions are database driven and so many of us often wonder how to access the database. To help you understand the answer to this question I've...
|
by: Curtis Rutland |
last post by:
How To Use A Database In Your Program Part II
This article is intended to extend Frinny’s excellent article: How to Use a Database in Your Program. Frinny’s article defines the basic concepts...
|
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...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
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...
|
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...
|
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...
|
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,...
| |