Page 1 of 1

Delphi 2010+ZeosLib+oracle10g

Posted: 20.06.2012, 01:13
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!

Posted: 20.06.2012, 10:15
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

Posted: 20.06.2012, 14:40
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

Posted: 20.06.2012, 23:14
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

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

Posted: 21.06.2012, 01:34
by luizcesarap
can you point me to these articles?

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

Luiz

Posted: 21.06.2012, 12:28
by EgonHugeist
luizcesarap,

that would be fine. Did you test my branch?

Michael