OraFAQ Forum: Windows » Connect Oracle from Win7

Home » Infrastructure » Windows » Connect Oracle from Win7

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

Connect Oracle from Win7 [message #588172]

Sat, 22 June 2013 02:53

vbhowmick
Messages: 8
Registered: June 2009

Junior Member

Hi,

Recently i have installed oracle 10g.2 in my laptop under Win-7 64bit. But cannot
connect oracle from Windows form [C#], Office application[Excel] and odbc. Showing error
[Tns could not resolve the connect identifier specified Drivers SQLSetconnectAttr failed ]

Though I can connect oracle from toad and sqlplus and form 6i.

Please help me out.

Vasker

Report message to a moderator

Re: Connect Oracle from Win7 [message #588173 is a reply to message #588172]

Sat, 22 June 2013 02:58

Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You are pointing on a tnsnames.ora that does not contain the entry you mentioned in your connect chain.

Regards
Michel

Report message to a moderator

Re: Connect Oracle from Win7 [message #588174 is a reply to message #588173]

Sat, 22 June 2013 03:46

vbhowmick
Messages: 8
Registered: June 2009

Junior Member

Hi ,
Thanks for reply . I checked the tnsnames.ora

orcl=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 'hostname')(PORT = 1521))
)
(CONNECT_DATA =
(SID = orcl)
(SERVER = DEDICATED)
)
)

Report message to a moderator

Re: Connect Oracle from Win7 [message #588175 is a reply to message #588174]

Sat, 22 June 2013 03:54

Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

And your connection chain?
And are you sure this is the one you use?

Regards
Michel

Report message to a moderator

Re: Connect Oracle from Win7 [message #588176 is a reply to message #588175]

Sat, 22 June 2013 04:36

vbhowmick
Messages: 8
Registered: June 2009

Junior Member

connection chain? not clear

Report message to a moderator

Re: Connect Oracle from Win7 [message #588179 is a reply to message #588176]

Sat, 22 June 2013 08:47

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

ORA-12154 ALWAYS only occurs on SQL Client & no SQL*Net packets ever leave client system
ORA-12154 NEVER involves the listener, the database itself or anything on the DB Server.
ORA-12154 occurs when client requests a connection to some DB server system using some connection string.
TNS-03505 is thrown by tnsping & is same error as ORA-12154 thrown by sqlplus or others.
The lookup operation fails because the name provided can NOT be resolved to any remote DB.
The analogous operation would be when you wanted to call somebody, but could not find their name in any phonebook.
The most frequent cause for the ORA-12154 error is when the connection alias can not be found in tnsnames.ora.
The lookup operation of the alias can be impacted by the contents of the sqlnet.ora file; specifically DOMAIN entry.
TROUBLESHOOTING GUIDE: ORA-12154 & TNS-12154 TNS:could not resolve service name [ID 114085.1]
http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/

Report message to a moderator

Re: Connect Oracle from Win7 [message #588181 is a reply to message #588176]

Sat, 22 June 2013 09:41

Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

vbhowmick wrote on Sat, 22 June 2013 11:36

connection chain? not clear

user/psw@tnsentry or the like.

Regards
Michel

Report message to a moderator

Re: Connect Oracle from Win7 [message #588208 is a reply to message #588181]

Sun, 23 June 2013 11:04

vbhowmick
Messages: 8
Registered: June 2009

Junior Member

user/psw@tnsentry is working well from command . But odbc or dot net cant connect still . os win 7 64

Report message to a moderator

Re: Connect Oracle from Win7 [message #588209 is a reply to message #588208]

Sun, 23 June 2013 11:25

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>user/psw@tnsentry is working well from command .
Above indicates that listener & database are OK

>But odbc or dot net cant connect still . os win 7 64
indicates client side misconfiguration.
root cause & fix are external to Oracle.

Report message to a moderator

Re: Connect Oracle from Win7 [message #588416 is a reply to message #588209]

Tue, 25 June 2013 12:36

vbhowmick
Messages: 8
Registered: June 2009

Junior Member

Now can connect from excel and odbc after re-install office from "Program Files (x86)" to "Program Files".
But .net still can't connect showing error TNs could not resolve the connect identifier specified .

Please help.

Report message to a moderator

Re: Connect Oracle from Win7 [message #588417 is a reply to message #588416]

Tue, 25 June 2013 12:55

Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

So the problem is in .Net configuration.

Regards
Michel

Report message to a moderator

Re: Connect Oracle from Win7 [message #588444 is a reply to message #588417]

Tue, 25 June 2013 23:49

vbhowmick
Messages: 8
Registered: June 2009

Junior Member

where is that configuration ?
In dot net i started from add new data source.

Report message to a moderator

Re: Connect Oracle from Win7 [message #588448 is a reply to message #588444]

Wed, 26 June 2013 00:22

Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Read Data Provider for .NET Developer's Guide

Regards
Michel

Report message to a moderator

Re: Connect Oracle from Win7 [message #588457 is a reply to message #588448]

Wed, 26 June 2013 01:50

vbhowmick
Messages: 8
Registered: June 2009

Junior Member

Hi i tried the same with Php as well and its working well . But not with .net

Report message to a moderator

Re: Connect Oracle from Win7 [message #588460 is a reply to message #588457]

Wed, 26 June 2013 01:57

Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

So definitively a .Net problem.
Had you a look to the link I pointed you to?

Regards
Michel

Report message to a moderator

Re: Connect Oracle from Win7 [message #588473 is a reply to message #588460]

Wed, 26 June 2013 02:37

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

What is your exact client and server version?

There is a bug that ODBC connections don't work when the executable that used the ODBC connection is in a directory with a bracket that was fixed in 10.2.0.5 (Bug 3807408), both the Client and the server have to have at least that version.

Report message to a moderator

Re: Connect Oracle from Win7 [message #588489 is a reply to message #588176]

Wed, 26 June 2013 03:37

gazzag
Messages: 1114
Registered: November 2010
Location: Bedwas, UK

Senior Member

vbhowmick wrote on Sat, 22 June 2013 09:36

connection chain? not clear

Connection string.

Report message to a moderator

Re: Connect Oracle from Win7 [message #588491 is a reply to message #588489]

Wed, 26 June 2013 03:40

Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

We fixed that, you are a couple of days late! Smile

Smile

Regards
Michel

Report message to a moderator

Previous Topic:	Oracle 10g installation asking for product.xml
Next Topic:	Unable to continue Oracle 11g Release 2 installation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 22 17:06:29 CDT 2023