Zeoslib Portal

hello, You should create an entry in the tnsnames.ora file. Examples: DBNAME =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.10.54) (PORT = 1521))      (CONNECT_DATA =        (SERVER = DEDICATED)        (SERVICE_NAME = service name)      )    ) PAAAAI =    (DESCRIPTION =      (A...

The procedure to send lower case 'begin transaction' is: TZDBLibConnection.StartTransaction procedure; begin    InternalExecuteStatement ('BEGIN TRANSACTION'); end; Which I think is logical to do so, TZDBLibConnection.InternalSetTransactionIsolation should only set the transaction type, not start it.

Looking where the error occurs, I see that the process responsible for repeating the begin transaction is TZDBLibConnection.InternalSetTransactionIsolation in file dbc\ZDbcDbLib.pas line 593. procedure TZDBLibConnection.InternalSetTransactionIsolation(Level: TZTransactIsolationLevel); const IL: arra...

Hello, I encountered the following problem on Zeos 7.0.3 When connected to a MSSQL database defining AutoCommit = false, TransactIsolation = tiReadCommitted, running 2 begin transaction, this can be verified in the log ZSQLMonitor or executing the query SELECT @@TRANCOUNT which returns 2. This cause...

Yes, now works perfectly
Thank you.

Sorry, I'm using http://svn.code.sf.net/p/zeoslib/code-0 ... es/testing.
Is it correct or should I use another path?

I'm using http://svn.code.sf.net/p/zeoslib/code-0

Hello, I have an error with large blob fields in Oracle. I watched TZOracleBlob.ReadBlob procedure (ZDbcOracleResultSet.pas) and obviously the block repeat ..... Until Offset <Cap, only runs once and the blob field is truncated.

regards

Michael,

Excuse me, you're right, the problem was the Oracle client configuration on each machine, by setting in ZConnection clientcodepage UTF8 works perfect regardless of how this set NSL_LANG.

Thank you very much.

cfc.

Hi Michael, All taxes well until you run the program in Windows 32. The machine on which work is Windows 7 64 and varchar fields are read as TWideStringField, but when the same program compiled on my machine I run it on XP 32 or Windows 2003 Server, varchar fields are read as TStringField. Greetings.

Michael, The LONG and LONG RAW datatypes have been deprecated in favour of LOBs for many Oracle versions. But, for example, when Zeos retrieve metadata from database use this filed type. NLS_LANG=AMERICAN_AMERICA.UTF8 clientcodepage is blank in ZConection i'm testing with clientcodepage=UTF8 and fai...

Michael, I am using Oracle and download the latest version of SVN and now I have problems with queries where the answer is a field of type long and has data, if the field is empty does not generate error. The error was detected when looking for the metadata and the data field has DATA_DEFAULT. LOG: ...

Michael,

Now i' m testing /branches/testing-egonhugeist.

Yes, the thread http://zeos.firmos.at/viewtopic.php?t=3522 is solved with this branch.

thanks.

cfc.

hi, I' have a problem when the param of query is Null If the param is null "example: zquery1.parambyname('id').clear" when call de fuction LoadOracleVars in de line 413 of ZdbcOracleUtils (CurrentVar.Data := nil;) the reserved memory is lost and when other call the param have a value give ...

I´ using the last version of svn. The problem is in TZParamsSQLDA.EncodeString line 1801 of ZDbcInterbase6Utils.pas In line 1824 Move(PAnsiChar(Str)^, sqldata^, sqllen); I' declare variable s: RawByteString; and change de line 1824 s := str; Move(PAnsiChar(s)^, sqldata^, sqllen); This works, but not...