Zeoslib Portal

Thank you marsupilami for your response, when I have a little time I will check if I can implement your solutions and I let you know the results

thank you again

Good morning, thank you for your fast response :D I just was looking at your solutions, and as aehimself suggested I tryed commiting after execution and it works !!!, Thanks. I can't see any problem with other columns (maybe I'm not able to interpretate the debugger messages :( ) I did some more tes...

Good afeternoon everyone, here goes my question: I'm connecting to a mssql server 2012 with Zeos 7.2.14 (using ADO) and lazarus 2.2.6 all under win 10 64. The table that I have to access (and that i can't modify its structure, because it is part of a huge database that is not mine): column 2 is defi...

Good morning everybody, I have been working with zeos and lazarus under windows 10/64 with connections to ora 10g xe, firebird 2.5 and postgresql (actually 14) with not isues. Now I'm porting my aplications to linux with no isues in firebird and postgresql, but I'm not able to get connection to orac...

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...

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...

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...

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

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:

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...

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...

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"

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...