|
ORA-12154 TNS:could not resolve service name
Cause: The service name specified is not defined correctly in the TNSNAMES.ORA file.
Action: Make the following checks and correct the error:
Verify that a TNSNAMES.ORA file exists and is in the proper place and accessible. See the operating system specific manual for details on the required name and location.
Check to see that the service name exists in one of the TNSNAMES.ORA files and add it if necessary.
Make sure there are no syntax errors anywhere in the file. Particularly look for unmatched parentheses or stray characters. Any error in a TNSNAMES.ORA file makes it unusable. See the Oracle Net Services Administrator's Guide. If possible, regenerate the configuration files using the Oracle Network Manager.
Rupa
|
|
|
|
|
User Id=SYSTEM;Password=MANAGER;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.4)(PORT=1521))(CONNECT_DATA=(SID=XE)))
Use you connection string like this.
Thanks & Regards,
Anil Chelasani
|
|
|
|
|
I need to show a grid on an asp.net C# page that has a list of customers and the count of records in a table for them.
I have a stored procedure that will return the count for a single customer.
I'm using a C# class that returns a dataset which then gets bound to the grid on the C# page that calls it.
I'm wondering what the best way of building the dataset is. I'm assuming that I call the stored procedure for each customer and then add the results to a dataset.
But do I need a temp dataset to put the stored procedure results in each time it is run and then add the results to a master dataset which I return to the grid page ? Or can I create one dataset and then keep adding to it by running the stored procedure for each customer ?
|
|
|
|
|
Yes, you can insert your data to one dataset for each stored procedure query.
However, making several round trips to your database and adding one record at a time to a dataset doesn't sound like the best usaged of resources if you have several customers to display. Why don't you let the database gather your data in one trip via your storaged procedure!
|
|
|
|
|
Hello,
Can tell me which is the best for sql server performance set rowcount 500 or select top 500 records.
500 is the number of records for select.
Best Regards,
S Kumar
|
|
|
|
|
Dunno if this helps...
"You may have heard of a SET command called SET ROWCOUNT. Like the TOP operator, it is designed to limit how many rows are returned from a SELECT statement. In effect, the SET ROWCOUNT and the TOP operator perform the same function.
While in most cases, using either option works equally efficiently, there are some instances (such as rows returned from an unsorted heap) where the TOP operator is more efficient than using SET ROWCOUNT. Because of this, using the TOP operator is preferable to using SET ROWCOUNT to limit the number of rows returned by a query."
Not my work but quoted from...
http://www.sql-server-performance.com/transact_sql_select.asp[^]
I've always used the TOP command myself. Better stick to that.
|
|
|
|
|
SET ROWCOUNT xxx operates on all transactions, so if you set it ALL queries running in the database at that time will be limited to 500 rows. This is most likely undesirable.
|
|
|
|
|
Hi,
I will not put database level, in sps I am using Set rowcount xxx and at last set rowcount 0.
Best Regards,
S Kumar
|
|
|
|
|
how can i represente a row in a numerical field in a star coordinate(1 star/row)
please help
|
|
|
|
|
how can i represente a row in a numerical field in a star coordinate(1 star/row)
please help
|
|
|
|
|
What exactly is a "star coordinate"?
--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters
|
|
|
|
|
it is a king of graph representation to represent numerical values in a graph form
|
|
|
|
|
MAYKY wrote: represent numerical values in a graph form
What development environment are you using to create the application in which you plan to display the graph?
What exactly is the data in each row?
What exactly is the graph suppose to look like?
--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters
|
|
|
|
|
well, suppose that i wanna display the results of each student in 5 subjects(for example) in a graph representation. this is an easy way to represente numerical values.
i know that there is a function or a class in the visual studio(c#) that can do this task but i can't find it
|
|
|
|
|
In my project i would like take the values persent in the t1 to t2 if t1 is updated and that time the t2 also to be updated how to do it?
|
|
|
|
|
Write a trigger.
Arthur Dent - "That would explain it. All my life I've had this strange feeling that there's something big and sinister going on in the world."
Slartibartfast - "No. That's perfectly normal paranoia. Everybody in the universe gets that."
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
All you have to do is return a boolean Value from the Stored Procedure which is used to Update T1. If the Boolean value is '1'(Success), then tell the system to update T2 with another Stored Procedure.
|
|
|
|
|
Or, as I stated in the post above, write a trigger. If you want to copy the values from T1 to T2 based on an insert/update/delete then this is the easiest and best way to do it.
Arthur Dent - "That would explain it. All my life I've had this strange feeling that there's something big and sinister going on in the world."
Slartibartfast - "No. That's perfectly normal paranoia. Everybody in the universe gets that."
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Hi All,
I have 2 tables
Table name: Property_Master
Pm_id | Remarks
1 | Good
2 | Bad
3 | fair
Table Name: Property_Details
PD_id | Pd_Pm_Id | Price
1 | 1 | 2000
2 | 1 | 2100
3 | 2 | 5000
4 | 2 | 5500
5 | 3 | 2500
I want following result
PM_Id | Pd_Pm_Id | Price | Remarks
1 | 1 | 2000 | Good
2 | 2 | 5000 | Bad
3 | 3 | 2500 | Fair
How to write SQL query for it. How it is possible. Please help me.
Jegastar
|
|
|
|
|
See the answers that we gave to you yesterday.
It looks like you need to use a join. BTW - this also looks suspiciously like homework, so don't expect people on this site to do it for you.
Arthur Dent - "That would explain it. All my life I've had this strange feeling that there's something big and sinister going on in the world."
Slartibartfast - "No. That's perfectly normal paranoia. Everybody in the universe gets that."
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
I am sorry. But just say whether it is possible or not.
Jegastar
|
|
|
|
|
I already gave you a hint. If you've got two tables and you need the results out of both, use a JOIN. Google it.
Arthur Dent - "That would explain it. All my life I've had this strange feeling that there's something big and sinister going on in the world."
Slartibartfast - "No. That's perfectly normal paranoia. Everybody in the universe gets that."
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
I realise that you are trying to help mate, but if you have the time to give him a hint, you also have the time to explain to him what a Join is.
You don't have to give him the answer, but your attitude should be more like a supportive teacher than a guy who tells people to 'Google it' and leave you alone.
If everyone simply googles everything, then there is no need for this website is there? Your hints are appreciated and helpful, especially when I get them, but for all newbies including myself, it's the attitude that bites.
Don't take this the wrong way. I would like to see positive and supportive attitude on forums like this as I'm am sure many people would.
EDIT: Don't make sweeping statements that people on this site "won't do his homework for him" because regardless of whether it is homework, we all need help with our work. It's what this site is for.. go figure..
|
|
|
|
|
Thanks for the insight, especially as I spend a lot of my time answering questions for people. However, you will find that there are a lot of times when it looks as though people want you to do their homework for them, and the best thing that you can do for them is to give them a hint and see how they go from their.
I spend a large amount of my time helping people here, giving something back to the CP community.
Dayekh wrote: EDIT: Don't make sweeping statements that people on this site "won't do his homework for him" because regardless of whether it is homework, we all need help with our work. It's what this site is for.. go figure..
Errm actually, the site isn't for homework (and you will find that a lot of people on this site will answer you in precisely the same way that I did - not a sweeping statement, but the fact that I have used this site for a long time). I don't think that teachers would appreciate us doing the homework for somebody. That doesn't help them - and I speak as somebody who used to be a teacher. Give them a hint certainly, point them in the general direction, but don't give them the answer. If you do this, then you sell them short because they have not answered things for themselves - and missed the sense of achievement that they will get from this.
Dayekh wrote: If everyone simply googles everything, then there is no need for this website is there? Your hints are appreciated and helpful, especially when I get them, but for all newbies including myself, it's the attitude that bites.
Don't take this the wrong way. I would like to see positive and supportive attitude on forums like this as I'm am sure many people would.
As soon as somebody says something like this, I automatically take it the wrong way. If I didn't want to be bothered, I wouldn't have answered the post. What I do want is for you to learn something when I answer, and that means that I will often give you hints to point you in the right direction. That way, you learn something on your own and it sticks. If I give you the answer then you don't learn anything. You won't remember it.
If you don't like my attitude, then mate, that is your problem and not mine. I'm not going to change the way that I answer just for you. If I can help, I will. If I think that you need a specific answer, I will give you one. If I think that you can undertake a personal journey and learn something on your own, I will give you a hint. And, more importantly, if you had followed the threads of my conversation with this guy, you would see that I had attempted to help him before.
Arthur Dent - "That would explain it. All my life I've had this strange feeling that there's something big and sinister going on in the world."
Slartibartfast - "No. That's perfectly normal paranoia. Everybody in the universe gets that."
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
I am very happy with your reply mate. You have replied in a very intellectual manner and did not flame me. People with such responses are ones who deserve posting on this site.
Pete O`Hanlon wrote: if you had followed the threads of my conversation with this guy, you would see that I had attempted to help him before.
I do not know much about this guy, but something about your second response what like you were attempting to shoo him off. That was the statement I didn't like.
Pete O`Hanlon wrote: Errm actually, the site isn't for homework (and you will find that a lot of people on this site will answer you in precisely the same way that I did - not a sweeping statement, but the fact that I have used this site for a long time). I don't think that teachers would appreciate us doing the homework for somebody. That doesn't help them - and I speak as somebody who used to be a teacher. Give them a hint certainly, point them in the general direction, but don't give them the answer. If you do this, then you sell them short because they have not answered things for themselves - and missed the sense of achievement that they will get from this.
About the Homework factor.. I cannot completely agree with you, simply because work is work at the end of the day. It is the response which counts. As I have said in my post, you don't need to give them the answers. I was only talking about the attitude. It was not hostile, but distant. That's all.
When you tell someone to google something, just explain to him why you are not giving the answer. Many people do not know that the best way to learn is to 'teach him how to fish' so to speak. They will just assume that you are unhelpful, which is not the case.
In anycase, I suppose everyone helps in their own way. What can I say. And indeed the best way to help is to 'teach a man to fish' as they say.
Pete O`Hanlon wrote: Thanks for the insight, especially as I spend a lot of my time answering questions for people.
Every member of this site is a contribution, whether they ask questions or reply to them. We all supply this large FAQ with puzzles and solutions.. somewhat. And for that, they are a credit to such a community. And for that, I hope none of this ramble has affected the professional relationship between coders such as yourself and I. Take care, and be gentle
|
|
|
|