OraFAQ Forum: General » ORACLE 8.1.7 Client problems

Home » Other » General » ORACLE 8.1.7 Client problems

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORACLE 8.1.7 Client problems [message #244447]

Tue, 12 June 2007 20:51

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

Michel Cadot
Messages: 68643
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

Report message to a moderator

Re: ORACLE 8.1.7 Client problems [message #244466 is a reply to message #244464]

Wed, 13 June 2007 00:52

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

Michel Cadot
Messages: 68643
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

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

Frank
Messages: 7901
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.

Report message to a moderator

Re: ORACLE 8.1.7 Client problems [message #244477 is a reply to message #244473]

Wed, 13 June 2007 01:11

Michel Cadot
Messages: 68643
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

Report message to a moderator

Re: ORACLE 8.1.7 Client problems [message #244485 is a reply to message #244447]

Wed, 13 June 2007 01:41

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: ORACLE 8.1.7 Client problems [message #244497 is a reply to message #244485]

Wed, 13 June 2007 02:20

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 23:26:08 CDT 2024