Search found 9 matches

by xutanou
19.05.2017, 19:02
Forum: ZeosLib 7.1 stable Forum
Topic: ORA-01406: fetched column value was truncated
Replies: 0
Views: 392

ORA-01406: fetched column value was truncated

Good evening :D After I had successfully connected to Oracle 10 XE, I had another problem... :cry: when using a zquery or a ztable in certain cases the program returned the oci error 01406 :evil: , I was shure that my database was ok and after a lot of temptatives and tests I found that the guilty o...
by xutanou
09.05.2017, 19:27
Forum: ZeosLib 7.1 stable Forum
Topic: Ora 10 xe windows 10/64
Replies: 9
Views: 626

Re: Ora 10 xe windows 10/64

Good evening Everibody :D I'm glad to explain that at last I have found a solution !!! :idea: after a lot of googling and trying as many combinations as I could today I found a post that helped me, so I write down here my solution for others with the same problem: in the Tconnection component: Datab...
by xutanou
28.10.2016, 14:44
Forum: ZeosLib 7.1 stable Forum
Topic: Ora 10 xe windows 10/64
Replies: 9
Views: 626

Re: Ora 10 xe windows 10/64

Good evening, Miab3, I tryed your suggestion some time ago and it didn't work, I have tryied just now and it doesen't work either. Marsupilami, my application and Lazarus are in the same machine as the oracle server is installed, in fact I have tryed in the same machine and in a remote computer in t...
by xutanou
24.10.2016, 15:43
Forum: ZeosLib 7.1 stable Forum
Topic: Ora 10 xe windows 10/64
Replies: 9
Views: 626

Re: Ora 10 xe windows 10/64

I didn't mention that I can connect with sqlplus from a client to my database on the server using the connection string as below:

sqlplus myuser/mypassword@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=muhostIP)(Port=1521))(CONNECT_DATA=(SID=XE)))

thanks :wink:
by xutanou
24.10.2016, 15:27
Forum: ZeosLib 7.1 stable Forum
Topic: Ora 10 xe windows 10/64
Replies: 9
Views: 626

Re: Ora 10 xe windows 10/64

Hy marsupilami,
thanks for your response, here are my parameters in the zconnection component:

DATABASE= XE
HOSTNAME= empty
PASSWORD= mypassword
PORT=1521
PROTOCOL= ORACLE
USER= myuser

apart I have the Library location pointing to where the appropiate oci.dll is

The response is:
Error.png
by xutanou
13.10.2016, 22:38
Forum: ZeosLib 7.1 stable Forum
Topic: Ora 10 xe windows 10/64
Replies: 9
Views: 626

Ora 10 xe windows 10/64

Good evening everybody, I'm still trying to connect to ora 10 xe from zeos, now I have migrated all my system to win 10/64, I'm using Lazarus 1.6 and Zeos 7.1.4 All my system is 64 bit Oracle 10 xe is 32 bit and it is installed in the server. I can connect to the server with different oracle admin t...
by xutanou
28.03.2013, 12:01
Forum: ZeosLib 7.0 Stable Forum
Topic: Impossible conect to Ora 10G xe
Replies: 3
Views: 930

Thanks for your reply, in the tnsnames.ora file I have XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.25.72.230)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_F...
by xutanou
26.03.2013, 13:55
Forum: ZeosLib 7.0 Stable Forum
Topic: Impossible conect to Ora 10G xe
Replies: 3
Views: 930

II have been teiting The same Zeoslib in delphi 7 with the same result: "OCI ERROR 12154 tns could not resolve the connect identifier specified"
by xutanou
25.03.2013, 19:20
Forum: ZeosLib 7.0 Stable Forum
Topic: Impossible conect to Ora 10G xe
Replies: 3
Views: 930

Impossible conect to Ora 10G xe

Hy everybody, I'm trying to connect from Lazarus 1.0.8 fpc 2.6.2 wit zeos 7.0.3 and always I get the same message error: "OCI ERROR 12154 tns could not resolve the connect identifier specified". I'm in a client and I want to connect to the server. the params I use are: Database: XE Host na...

Go to advanced search