Can't connect to Oracle11g with Zeos.6.6.0

Forum related to version 6.5.1 (alpha) and 6.6.x (beta) of ZeosLib's DBOs

Moderators: gto, cipto_kh, EgonHugeist

Post Reply
zekeriye
Fresh Boarder
Fresh Boarder
Posts: 3
Joined: 06.12.2007, 10:19

Can't connect to Oracle11g with Zeos.6.6.0

Post by zekeriye »

Can't connect to Oracle11g with Zeos.6.6.0 with Delphi7

username : Username
Hostname : Database_server_name
Port : 0
Database : database_name
Pass : User_password
Protocol : 9i / Oracle

I got an error with messages :
"SQL Error : ORA-15154:TNS:could not resolve the connect identifier specified"
and does not connect;

How can I connect to oracle11g wit h zeos 6.6.0 using Delphi 7 ?
pol
Senior Boarder
Senior Boarder
Posts: 91
Joined: 13.10.2005, 08:19

Post by pol »

Can you connect to other Oracle versions? As far as I know, connection methods didn't have changed.
I leave Hostname empty, and in Database there is the entry from my tnsnames.ora. That should also worj for Oracle 11g.

hth
Rüdiger
zekeriye
Fresh Boarder
Fresh Boarder
Posts: 3
Joined: 06.12.2007, 10:19

Post by zekeriye »

I can connect another components from delphi7
gcr
Fresh Boarder
Fresh Boarder
Posts: 15
Joined: 18.12.2007, 11:30

Post by gcr »

Hi,

You have always this problem ?


I have a problem when compiling on Windows XP and using on Vista
No problem if i compil on Vista and using on vista or XP

gcr
pol
Senior Boarder
Senior Boarder
Posts: 91
Joined: 13.10.2005, 08:19

Post by pol »

What error message do you get?
gcr
Fresh Boarder
Fresh Boarder
Posts: 15
Joined: 18.12.2007, 11:30

Post by gcr »

The problem seems come from Windows Vista 64 Bits with Oracle 10.2.3 (special vista edition). With 32bits, we have no problem.

thank you
gilles
Post Reply