UniDAC oracle connection at DelphiXE (TNS/Direct) problem

ioannisa · Post by **ioannisa** » Tue 14 Dec 2010 11:58

Hello, I am experiensing problems connecting to unidac oracle at DelphiXE under Windows7 x64. I am active subscriber to UniDAC and I have installed the latest component update given at 08-DEC-2010. The oracle version is 10.1.0. However other PCs run my program and connect (at least with the direct connection executable I produce). Mine doesn't (maybe because the laptop I am working in is not at the domain of the company?).

I have SQL Navigator installed connecting fine at oracle through TNS, but under UniDAC I cannot connect.

If I try to connect through TNS I get the error:
ORA-12154: TNS:could not resolve the connect identifier specified

If I try to connect directly I get the error:
NET: Network error (Windows socket error: A request to send or receive data was disallowed because the socket is not connected and (when sending on a datagram socket using a sendto call) no address was supplied (10057), on API 'send').

------------

I have to make clear that sql navigator connecting at the same TNS connects without any problem.

My tnsnames.ora contains
SRS2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.100)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = SRS2)
)
)

At the connection editor (for TNS Connection) I give
Provider: Oracle
username: srs2
password: ****** (the password)
server: SRS2

---------------------------------------------

Similarly if I try the direct connection, I set at the options tab of the connection editor "Direct = True" and at the connection editor I change the "Server" to

192.168.0.100:1521:SRS2

----------------------------------------------

Both connections fail.
What am I doing wrong given that on the same PC the SQL Navigator connects through TNS perfectly fine?

ioannisa · Post by **ioannisa** » Tue 14 Dec 2010 14:05

To keep you up to date:

The same problem doesn't exist if I try to connect the same project, with the same version of UniDAC components under Delphi7 at WindowsXP 32bit.

That makes me believe that the problem is because of the following reasons:
1) Maybe your delphiXE component has a problem that the delphi7 doesn't
2) Maybe DelphiXE has some problem that Delphi7 doesn't
3) Maybe Windows7 has some problem that WindowsXP doesn't
4) Maybe x64 version of OS conflicts with something the x86 doesn't.

Is this helpful?

ioannisa · Post by **ioannisa** » Tue 14 Dec 2010 14:20

Some even further briefing:

I found out the following:

I ran the compiled file at Delphi7, WindowsXP (32bit) on the pc that had the problem (Windows7 x64, DelphiXE).

I simply ran the "exe" file that was produced in delphi7, and the program runs fine.

That means that the problem focuses on the component for the DelphiXE.

bork · Post by **bork** » Tue 14 Dec 2010 14:21

Thank you for the information. We will check it under Delphi XE.

I posted an answer in the topic http://www.devart.com/forums/viewtopic.php?t=19669 . Please do not duplicate topics.

Also the Direct mode doesn't support RAC servers and such support will not be added soon.