Delphi 2010+ZeosLib+oracle10g

The alpha/beta tester's forum for ZeosLib 7.0.x series

Report problems concerning our Delphi 2009+ version and new Zeoslib 7.0 features here.

This is a forum that will be removed once the 7.X version goes into stable!!

Moderators: gto, EgonHugeist, olehs

Locked
luizcesarap
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: 15.03.2012, 02:29
Contact:

Delphi 2010+ZeosLib+oracle10g

Post by luizcesarap »

Hello all,

I have big problem with delphi 2010 + zeos-dev 7.0.0 + Oracle 10G.

Every time I connect with ZConnection.Connected = True is the error "ORA-12154: TNS: could not resolve the connect identifier specified", but the bank is working properly, so I have done in the same application with delphi 7 same configuration and the same component.

Connects perfectly. That same equipment have pl / sql and sql usually refer proving that the connections are acceptable.

Have searched on the internet, and every forum that I am more confused I get. I see this problem happen in 64-bit platforms, but use windows xp 32 bit D2010 and ZeosLib 7.

Have debuguei font from start to finish and do not know why he can not identify who is active tns.

I found a document on the internet where the critical flaws apontas ZeosLib and one claiming to have no solution for this case. That's got some real alternative?

Do I have to leave after years of using this fabulous component by a problem that no one can solve or at least give a quick and practical.

Does not the problem itself delphi2010 that now the variables are of type string and AnsiString zeos it is being lost?

As I said above there are two versions of the same component with d7 and configuration works perfectly, why then does not work with delphi 2010.


If someone can help me thank you!
User avatar
EgonHugeist
Zeos Project Manager
Zeos Project Manager
Posts: 1936
Joined: 31.03.2011, 22:38

Post by EgonHugeist »

luizcesarap,

Hmm that's a good question, what's going wrong. Did you try to use my branch?: http://zeos.firmos.at/viewtopic.php?t=3427

There i've started to complete the unicode parts for oracle.

I can report you a similar issue. If my Vista64 does some spezial updates then oracle runs into the issue that the tns listener is equal lost like you've reported. And i'm not able to fix oracle. I always have to reinstall this server. Btw i'm using XE developer for some tests here.

I found a document on the internet where the critical flaws apontas ZeosLib and one claiming to have no solution for this case. That's got some real alternative?
can you point me to these articles?

Michael
Best regards, Michael

You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image
miab3
Zeos Test Team
Zeos Test Team
Posts: 1310
Joined: 11.05.2012, 12:32
Location: Poland

Post by miab3 »

Oracle 11g R2 Express(Win-32) works for me on DXE2-32 and Lazarus1.1win-32 connecting to by the instantclient-basic-nt-11.
[s]For D2006 when I try to connect I get AV.[/s]
The D2006 also works (it was a mistake the system configuration).

Lazarus1.1win-64 and DXE2-64 also working.

D2006 works but unlike the other has problems with the national character when set to UTF8.
(Zeos7eh1399)

Michal Abramczyk
User avatar
EgonHugeist
Zeos Project Manager
Zeos Project Manager
Posts: 1936
Joined: 31.03.2011, 22:38

Post by EgonHugeist »

@miab3,
D2006 works but unlike the other has problems with the national character when set to UTF8.
What do you mean here exactly? I've just started with oracle...

Michael
Best regards, Michael

You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image
luizcesarap
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: 15.03.2012, 02:29
Contact:

I'll see if I saved pdf file and send you.

Post by luizcesarap »

can you point me to these articles?

I'll see if I saved pdf file and send you.

Luiz
User avatar
EgonHugeist
Zeos Project Manager
Zeos Project Manager
Posts: 1936
Joined: 31.03.2011, 22:38

Post by EgonHugeist »

luizcesarap,

that would be fine. Did you test my branch?

Michael
Best regards, Michael

You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image
Locked