September 21, 2011 at 10:50 am
Stefan Krzywicki (9/21/2011)
Ninja's_RGR'us (9/21/2011)
Stefan Krzywicki (9/21/2011)
Gianluca Sartori (9/21/2011)
Stefan Krzywicki (9/21/2011)
I know a few people here have used Oracle quite a bit over the last year or so. I'm having trouble creating a linked server connection to an Oracle database. I'm getting the errortns listener was not given the service_name in connect_data
when I try to connect. Any ideas? Is there a forum here where I should post this as a question?
Check you tnsnames.ora, you should find the service name/SID in there.
You can always post it as a question in the "Working with Oracle" forums and post the URL here.
I've been fiddling with that file, but I'm not getting it to work.
Ah, thanks! I'd missed that forum section.
That's the point of keeping it hidden and burried way down there 😉
I think it is more a "willful blindness". I have no desire to work with Oracle, so my eyes just skim past it. : -)
Can't argue with that. I never know there were 3 of them and that the first 1 was like #4 in the forums list. I swear I never saw it!
September 21, 2011 at 11:05 am
Stefan Krzywicki (9/21/2011)
Ninja's_RGR'us (9/21/2011)
Stefan Krzywicki (9/21/2011)
Gianluca Sartori (9/21/2011)
Stefan Krzywicki (9/21/2011)
I know a few people here have used Oracle quite a bit over the last year or so. I'm having trouble creating a linked server connection to an Oracle database. I'm getting the errortns listener was not given the service_name in connect_data
when I try to connect. Any ideas? Is there a forum here where I should post this as a question?
Check you tnsnames.ora, you should find the service name/SID in there.
You can always post it as a question in the "Working with Oracle" forums and post the URL here.
I've been fiddling with that file, but I'm not getting it to work.
Ah, thanks! I'd missed that forum section.
That's the point of keeping it hidden and burried way down there 😉
I think it is more a "willful blindness". I have no desire to work with Oracle, so my eyes just skim past it. : -)
:-D:hehe:
Today we had an Oracle consultant (BI systems engineer, not a DBA) in our offices and I was discussing some (very serious) issues with an Oracle database. Basically, it stops responding every one or two days, blocking everything.
When I saw the consultant, I just said out loud: "Oh, well, if it doesn't stop this behaviour I think we'll have to move the data in a working RDBMS, such as SQL Server."
His face turned red and he shouted: "At least wait for me to go home before saying this kind of things! I disagree with everything you say! Oracle is the best RDBMS in the world! If it doesn't work it's all your fault!" ...
Well, it wasn't fair, but you can't even imagine how good that made me feel. 🙂
-- Gianluca Sartori
September 21, 2011 at 11:08 am
Gianluca Sartori (9/21/2011)
Stefan Krzywicki (9/21/2011)
Ninja's_RGR'us (9/21/2011)
Stefan Krzywicki (9/21/2011)
Gianluca Sartori (9/21/2011)
Stefan Krzywicki (9/21/2011)
I know a few people here have used Oracle quite a bit over the last year or so. I'm having trouble creating a linked server connection to an Oracle database. I'm getting the errortns listener was not given the service_name in connect_data
when I try to connect. Any ideas? Is there a forum here where I should post this as a question?
Check you tnsnames.ora, you should find the service name/SID in there.
You can always post it as a question in the "Working with Oracle" forums and post the URL here.
I've been fiddling with that file, but I'm not getting it to work.
Ah, thanks! I'd missed that forum section.
That's the point of keeping it hidden and burried way down there 😉
I think it is more a "willful blindness". I have no desire to work with Oracle, so my eyes just skim past it. : -)
:-D:hehe:
Today we had an Oracle consultant (BI systems engineer, not a DBA) in our offices and I was discussing some (very serious) issues with an Oracle database. Basically, it stops responding every one or two days, blocking everything.
When I saw the consultant, I just said out loud: "Oh, well, if it doesn't stop this behaviour I think we'll have to move the data in a working RDBMS, such as SQL Server."
His face turned red and he shouted: "At least wait for me to go home before saying this kind of things! I disagree with everything you say! Oracle is the best RDBMS in the world! If it doesn't work it's all your fault!" ...
Well, it wasn't fair, but you can't even imagine how good that made me feel. 🙂
Next time you need to shoot a video of this... before you shoot him with your words :-D.
September 21, 2011 at 11:14 am
Gianluca Sartori (9/21/2011)
...:-D:hehe:
Today we had an Oracle consultant (BI systems engineer, not a DBA) in our offices and I was discussing some (very serious) issues with an Oracle database. Basically, it stops responding every one or two days, blocking everything.
When I saw the consultant, I just said out loud: "Oh, well, if it doesn't stop this behaviour I think we'll have to move the data in a working RDBMS, such as SQL Server."
His face turned red and he shouted: "At least wait for me to go home before saying this kind of things! I disagree with everything you say! Oracle is the best RDBMS in the world! If it doesn't work it's all your fault!" ...
Well, it wasn't fair, but you can't even imagine how good that made me feel. 🙂
But he's absolutely right: It's all your (or your company's) fault to start with Oracle in the first place! 🙂
No way to argue about it....
September 21, 2011 at 11:16 am
If anyone is interested in helping me get archaic Oracle to work with modern SQL Server
http://www.sqlservercentral.com/Forums/Topic1178868-1044-1.aspx
Of course, it isn't like Oracle has actually changed much in the last 40 years, but it is probably just enough different to cause headaches. : -)
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
September 21, 2011 at 11:17 am
Gianluca Sartori (9/21/2011)
Stefan Krzywicki (9/21/2011)
Ninja's_RGR'us (9/21/2011)
Stefan Krzywicki (9/21/2011)
Gianluca Sartori (9/21/2011)
Stefan Krzywicki (9/21/2011)
I know a few people here have used Oracle quite a bit over the last year or so. I'm having trouble creating a linked server connection to an Oracle database. I'm getting the errortns listener was not given the service_name in connect_data
when I try to connect. Any ideas? Is there a forum here where I should post this as a question?
Check you tnsnames.ora, you should find the service name/SID in there.
You can always post it as a question in the "Working with Oracle" forums and post the URL here.
I've been fiddling with that file, but I'm not getting it to work.
Ah, thanks! I'd missed that forum section.
That's the point of keeping it hidden and burried way down there 😉
I think it is more a "willful blindness". I have no desire to work with Oracle, so my eyes just skim past it. : -)
:-D:hehe:
Today we had an Oracle consultant (BI systems engineer, not a DBA) in our offices and I was discussing some (very serious) issues with an Oracle database. Basically, it stops responding every one or two days, blocking everything.
When I saw the consultant, I just said out loud: "Oh, well, if it doesn't stop this behaviour I think we'll have to move the data in a working RDBMS, such as SQL Server."
His face turned red and he shouted: "At least wait for me to go home before saying this kind of things! I disagree with everything you say! Oracle is the best RDBMS in the world! If it doesn't work it's all your fault!" ...
Well, it wasn't fair, but you can't even imagine how good that made me feel. 🙂
That sounds pretty funny. I'd think if it were really the best, the consultant would be able to say "Oh, you just have this configured wrong, let me show you."
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
September 21, 2011 at 11:21 am
SQLRNNR (9/21/2011)
Roy Ernest (9/21/2011)
Yes, I did the presentation for my user group on resource governor. Only 12 people attended it. So there is still a big chunk out there that has not seen that presentation.I think this would be a really good preso for a sql sat.
I submitted that as a session. 🙂
-Roy
September 21, 2011 at 11:26 am
Ninja's_RGR'us (9/21/2011)
SQLRNNR (9/21/2011)
Ninja's_RGR'us (9/21/2011)
SQLRNNR (9/21/2011)
Ninja's_RGR'us (9/21/2011)
L' Eomot Inversé (9/21/2011)
Ninja's_RGR'us (9/21/2011)
The real short answer here is :Why = Pourquoi
What for = Pour <space> quoi.
In the case of your sig, it's definitely 1 word.
Well, as it's definitely a "What for" and not a "Why" I don't understand why you say it has to be one word?
It's "For what do these people exist" not "Why do these people exist".
My memory may be playing me up, but I'm pretty sure I recall it being written as two words in the early 90s, when I first saw it.
I'm not a french teacher but I'm more than decent at spelling and I promise you it's 1 word unless you completely mis-expressed your intention.
In both meaning of the phrase you still have to use only 1 word unless I'm missing a deep nuance in the language (wouldn't be the first time).
In this case, I see the intent that Tom is trying to express and I believe Pour Quoi is correct.
Pour quoi = pour cela, pour quelle chose (c'est l'opposé de 'pour qui').
Sure, it's not like anybody's going to read / understand it anyways.
:w00t:
With or without the language differences :hehe:
I'd like to know if mor than 10% of the people actually read the sig.
It would surprise me if as many as 10% did.
And from that, if anything over 5% actually understand french.
I suspect less than 5% in USA, but much more than 5% in Europe, the Middle East, Africa, and Quebec; without knowing the proportion of USA members, can't guess the proportion who understand French.
Tom
September 21, 2011 at 11:28 am
Roy Ernest (9/21/2011)
SQLRNNR (9/21/2011)
Roy Ernest (9/21/2011)
Yes, I did the presentation for my user group on resource governor. Only 12 people attended it. So there is still a big chunk out there that has not seen that presentation.I think this would be a really good preso for a sql sat.
I submitted that as a session. 🙂
So now I guess you have to review the submission and veto if it's worth it or not? 😀
September 21, 2011 at 11:29 am
Sorry for you & your spouses loss Jim.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 21, 2011 at 11:29 am
LutzM (9/21/2011)
Gianluca Sartori (9/21/2011)
...:-D:hehe:
Today we had an Oracle consultant (BI systems engineer, not a DBA) in our offices and I was discussing some (very serious) issues with an Oracle database. Basically, it stops responding every one or two days, blocking everything.
When I saw the consultant, I just said out loud: "Oh, well, if it doesn't stop this behaviour I think we'll have to move the data in a working RDBMS, such as SQL Server."
His face turned red and he shouted: "At least wait for me to go home before saying this kind of things! I disagree with everything you say! Oracle is the best RDBMS in the world! If it doesn't work it's all your fault!" ...
Well, it wasn't fair, but you can't even imagine how good that made me feel. 🙂
But he's absolutely right: It's all your (or your company's) fault to start with Oracle in the first place! 🙂
No way to argue about it....
Difficult to disagree with that - but it could be worse, at least they aren't trying to use DB2.
Tom
September 21, 2011 at 11:35 am
Stefan Krzywicki (9/21/2011)
If anyone is interested in helping me get archaic Oracle to work with modern SQL Serverhttp://www.sqlservercentral.com/Forums/Topic1178868-1044-1.aspx
Of course, it isn't like Oracle has actually changed much in the last 40 years, but it is probably just enough different to cause headaches. : -)
40 years? Oracle Release 2 (the first release) was only 32 years ago. :laugh:
Tom
September 21, 2011 at 11:36 am
L' Eomot Inversé (9/21/2011)
LutzM (9/21/2011)
Gianluca Sartori (9/21/2011)
...:-D:hehe:
Today we had an Oracle consultant (BI systems engineer, not a DBA) in our offices and I was discussing some (very serious) issues with an Oracle database. Basically, it stops responding every one or two days, blocking everything.
When I saw the consultant, I just said out loud: "Oh, well, if it doesn't stop this behaviour I think we'll have to move the data in a working RDBMS, such as SQL Server."
His face turned red and he shouted: "At least wait for me to go home before saying this kind of things! I disagree with everything you say! Oracle is the best RDBMS in the world! If it doesn't work it's all your fault!" ...
Well, it wasn't fair, but you can't even imagine how good that made me feel. 🙂
But he's absolutely right: It's all your (or your company's) fault to start with Oracle in the first place! 🙂
No way to argue about it....
Difficult to disagree with that - but it could be worse, at least they aren't trying to use DB2.
I was working for a company around 5 years ago that got data feeds in various flat-file formates, uploaded it all to DB2 and then exported it in smaller segments to Access. I was fixing a VB6 program that they had that was written by a COBOL programmer to allow users to transform the data and then upload it to SQL Server or Oracle, the user had a choice.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
September 21, 2011 at 11:37 am
L' Eomot Inversé (9/21/2011)
Stefan Krzywicki (9/21/2011)
If anyone is interested in helping me get archaic Oracle to work with modern SQL Serverhttp://www.sqlservercentral.com/Forums/Topic1178868-1044-1.aspx
Of course, it isn't like Oracle has actually changed much in the last 40 years, but it is probably just enough different to cause headaches. : -)
40 years? Oracle Release 2 (the first release) was only 32 years ago. :laugh:
Wow, so the first release was already 8 years out of date! : -)
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
September 21, 2011 at 11:38 am
L' Eomot Inversé (9/21/2011)
Stefan Krzywicki (9/21/2011)
If anyone is interested in helping me get archaic Oracle to work with modern SQL Serverhttp://www.sqlservercentral.com/Forums/Topic1178868-1044-1.aspx
Of course, it isn't like Oracle has actually changed much in the last 40 years, but it is probably just enough different to cause headaches. : -)
40 years? Oracle Release 2 (the first release) was only 32 years ago. :laugh:
Well, technically my body's only aged 42 years in the last century. Neither is an untrue statement because of the scope of time listed.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 15 posts - 30,196 through 30,210 (of 66,816 total)
You must be logged in to reply to this topic. Login to reply