Home » Infrastructure » Windows » Connect Oracle from Win7
Connect Oracle from Win7 [message #588172] Sat, 22 June 2013 02:53 Go to next message
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



Re: Connect Oracle from Win7 [message #588173 is a reply to message #588172] Sat, 22 June 2013 02:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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
Re: Connect Oracle from Win7 [message #588174 is a reply to message #588173] Sat, 22 June 2013 03:46 Go to previous messageGo to next message
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)
)
)
Re: Connect Oracle from Win7 [message #588175 is a reply to message #588174] Sat, 22 June 2013 03:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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
Re: Connect Oracle from Win7 [message #588176 is a reply to message #588175] Sat, 22 June 2013 04:36 Go to previous messageGo to next message
vbhowmick
Messages: 8
Registered: June 2009
Junior Member
connection chain? not clear
Re: Connect Oracle from Win7 [message #588179 is a reply to message #588176] Sat, 22 June 2013 08:47 Go to previous messageGo to next message
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/
Re: Connect Oracle from Win7 [message #588181 is a reply to message #588176] Sat, 22 June 2013 09:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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

Re: Connect Oracle from Win7 [message #588208 is a reply to message #588181] Sun, 23 June 2013 11:04 Go to previous messageGo to next message
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
Re: Connect Oracle from Win7 [message #588209 is a reply to message #588208] Sun, 23 June 2013 11:25 Go to previous messageGo to next message
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.
Re: Connect Oracle from Win7 [message #588416 is a reply to message #588209] Tue, 25 June 2013 12:36 Go to previous messageGo to next message
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.
Re: Connect Oracle from Win7 [message #588417 is a reply to message #588416] Tue, 25 June 2013 12:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So the problem is in .Net configuration.

Regards
Michel
Re: Connect Oracle from Win7 [message #588444 is a reply to message #588417] Tue, 25 June 2013 23:49 Go to previous messageGo to next message
vbhowmick
Messages: 8
Registered: June 2009
Junior Member
where is that configuration ?
In dot net i started from add new data source.
Re: Connect Oracle from Win7 [message #588448 is a reply to message #588444] Wed, 26 June 2013 00:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read Data Provider for .NET Developer's Guide

Regards
Michel
Re: Connect Oracle from Win7 [message #588457 is a reply to message #588448] Wed, 26 June 2013 01:50 Go to previous messageGo to next message
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
Re: Connect Oracle from Win7 [message #588460 is a reply to message #588457] Wed, 26 June 2013 01:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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
Re: Connect Oracle from Win7 [message #588473 is a reply to message #588460] Wed, 26 June 2013 02:37 Go to previous messageGo to next message
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.
Re: Connect Oracle from Win7 [message #588489 is a reply to message #588176] Wed, 26 June 2013 03:37 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
vbhowmick wrote on Sat, 22 June 2013 09:36
connection chain? not clear


Connection string.
Re: Connect Oracle from Win7 [message #588491 is a reply to message #588489] Wed, 26 June 2013 03:40 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
We fixed that, you are a couple of days late! Smile

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


Current Time: Fri Mar 29 02:09:40 CDT 2024