Home » Other » General » ORACLE 8.1.7 Client problems
ORACLE 8.1.7 Client problems [message #244447] Tue, 12 June 2007 20:51 Go to next message
ctiong
Messages: 7
Registered: June 2007
Junior Member
Not sure how to start but here goes...

I have 2 pcs. In PC1 only Orace Client was installed and PC2 the full version.

From PC1 I can access the database in PC2 with DBA Studio but I can't connect with SQL Worksheet.

What is the problem? Where should I start looking?

Thanks.

Chuck

[Updated on: Tue, 12 June 2007 21:05]

Report message to a moderator

Re: ORACLE 8.1.7 Client problems [message #244464 is a reply to message #244447] Wed, 13 June 2007 00:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You don't give the same credentials.
You made a typo.
The database crashed between the 2 tests.
You took off the wire between the 2 tests.
You switched off the PC.
You lacked fuel.
A butterfly flapped his wings in Falkland Islands.

Regards
Michel
Re: ORACLE 8.1.7 Client problems [message #244466 is a reply to message #244464] Wed, 13 June 2007 00:52 Go to previous messageGo to next message
ctiong
Messages: 7
Registered: June 2007
Junior Member
Is this suppose to help me?
Well, thanks a bunch......

[Updated on: Wed, 13 June 2007 00:53]

Report message to a moderator

Re: ORACLE 8.1.7 Client problems [message #244468 is a reply to message #244466] Wed, 13 June 2007 00:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, if you think why you have this answer.
(because I am a bastard is not the right answer.)

Regards
Michel

[Updated on: Wed, 13 June 2007 00:58]

Report message to a moderator

Re: ORACLE 8.1.7 Client problems [message #244473 is a reply to message #244447] Wed, 13 June 2007 01:05 Go to previous messageGo to next message
ctiong
Messages: 7
Registered: June 2007
Junior Member
Why do I have this answer?
Maybe my question is not clear enuff? Ok I am a newbie.

Why do you even waste your time by posting a no-help reply?
God knows.....

[Updated on: Wed, 13 June 2007 01:08]

Report message to a moderator

Re: ORACLE 8.1.7 Client problems [message #244474 is a reply to message #244447] Wed, 13 June 2007 01:07 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
ctiong wrote on Wed, 13 June 2007 03:51
What is the problem? Where should I start looking?


At the error message.
Re: ORACLE 8.1.7 Client problems [message #244477 is a reply to message #244473] Wed, 13 June 2007 01:11 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Why do you even waste your time by posting a no-help reply?

Maybe because I try and try and try to help you think not only to solve your problem.

Regards
Michel
Re: ORACLE 8.1.7 Client problems [message #244485 is a reply to message #244447] Wed, 13 June 2007 01:41 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Are DBA Studio and SQL Worksheet in the same Oracle home? Is the tnsnames.ora file that is used by DBA Studio the same tnsnames.ora file that SQL Worksheet is using?

Search your PC for tnsnames.ora and see how many copies you have on it?

David
Re: ORACLE 8.1.7 Client problems [message #244497 is a reply to message #244485] Wed, 13 June 2007 02:20 Go to previous message
ctiong
Messages: 7
Registered: June 2007
Junior Member
Ok solved it.

It was because of the default extension domain on the service name. Deleted the extension and the problem went away.

Thank you very much.

Chuck

[Updated on: Wed, 13 June 2007 02:22]

Report message to a moderator

Previous Topic: SQL Plus font and background color
Next Topic: Re: Exporting tally data to Oracle Database
Goto Forum:
  


Current Time: Sat Dec 10 20:47:01 CST 2016

Total time taken to generate the page: 0.10614 seconds