ZeosLib 7.1 testers-thread
@EgonHugeist, @mdaems,
Zeos 7.1 R2494.
I still have trouble with Oracle types NCLOB, CLOB and BFILE for this sample table:
CREATE TABLE "B types"
(
TFLOAT FLOAT,
TNCLOB NCLOB,
TCLOB CLOB,
TBLOB BLOB,
TBFILE BFILE
)
The errors occur when attempting to write or read ZTable record and are also related to the selected ClientCodepage.
Michal
Zeos 7.1 R2494.
I still have trouble with Oracle types NCLOB, CLOB and BFILE for this sample table:
CREATE TABLE "B types"
(
TFLOAT FLOAT,
TNCLOB NCLOB,
TCLOB CLOB,
TBLOB BLOB,
TBFILE BFILE
)
The errors occur when attempting to write or read ZTable record and are also related to the selected ClientCodepage.
Michal
@EgonHugeist, @mdaems,
Zeos7.1-(beta) branches_ testing_R2496:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):
- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.40),
(For Linux currently I have no way to test)
(Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.29, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17).
I see two problems as I mentioned:
- with the TableName for ado-sqlncli MSSQL,
- with Oracle types NCLOB, CLOB and BFILE.
Michal
Zeos7.1-(beta) branches_ testing_R2496:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):
- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.40),
(For Linux currently I have no way to test)
(Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.29, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17).
I see two problems as I mentioned:
- with the TableName for ado-sqlncli MSSQL,
- with Oracle types NCLOB, CLOB and BFILE.
Michal
@EgonHugeist, @mdaems,
Zeos7.1-(beta) branches_ testing_R2500:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):
- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.40),
(For Linux currently I have no way to test)
(Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.29, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17).
I see two problems as I mentioned:
- with the TableName with space for ado-sqlncli MSSQL,
- with Oracle types NCLOB, CLOB and BFILE.
Michal
Zeos7.1-(beta) branches_ testing_R2500:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):
- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.40),
(For Linux currently I have no way to test)
(Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.29, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17).
I see two problems as I mentioned:
- with the TableName with space for ado-sqlncli MSSQL,
- with Oracle types NCLOB, CLOB and BFILE.
Michal
@EgonHugeist, @mdaems,
Zeos7.1-(beta) branches_ testing_R2502:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
ADO TableName with a space fixed.
I have tested on:
- DXE2 32/64 -> C++(32).
(The need to add ZAdoToken.pas to ZParseSql.dpk)
Remained these "B types" of ORACLE.
Michal
Zeos7.1-(beta) branches_ testing_R2502:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
ADO TableName with a space fixed.
I have tested on:
- DXE2 32/64 -> C++(32).
(The need to add ZAdoToken.pas to ZParseSql.dpk)
Remained these "B types" of ORACLE.
Michal
@EgonHugeist, @mdaems,
Zeos7.1-(beta) branches_ testing_R2506:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):
- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.40),
(For Linux currently I have no way to test)
(Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.29, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17).
(Now, with the appropriate settings CodePage no errors in ORACLE.)
Michal
Zeos7.1-(beta) branches_ testing_R2506:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):
- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.40),
(For Linux currently I have no way to test)
(Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.29, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17).
(Now, with the appropriate settings CodePage no errors in ORACLE.)
Michal
@EgonHugeist
Zeos7.1_R2506 DXE2-32
This mistake I gets when try opening the table after INSERT BFILE.
(attached)
(Directory and file exist).
This is a bit of a BFILE:
http://www.idevelopment.info/data/Oracl ... S_30.shtml
http://docs.oracle.com/cd/B10501_01/app ... l12bfl.htm
Michal
Zeos7.1_R2506 DXE2-32
This mistake I gets when try opening the table after INSERT BFILE.
(attached)
(Directory and file exist).
This is a bit of a BFILE:
http://www.idevelopment.info/data/Oracl ... S_30.shtml
http://docs.oracle.com/cd/B10501_01/app ... l12bfl.htm
Michal
You do not have the required permissions to view the files attached to this post.
- EgonHugeist
- Zeos Project Manager
- Posts: 1936
- Joined: 31.03.2011, 22:38
miab3,
hint on creating the Directory oracle doesn't check if it exists.
I added a test with BFILE reading and updating it. It works perfectly. The raised error isn't related to Zeos in this case. Max size of the Directory is 60Bytes (a very low value novadays).
Just look to the diff of my test:
http://sourceforge.net/p/zeoslib/code-0 ... 01f0f:2504
I assing 'C:\temp' as Dir (in my test) and did copy the hourse.jpg to temp. than i run my tests.. No issues to see.
hint on creating the Directory oracle doesn't check if it exists.
I added a test with BFILE reading and updating it. It works perfectly. The raised error isn't related to Zeos in this case. Max size of the Directory is 60Bytes (a very low value novadays).
Just look to the diff of my test:
http://sourceforge.net/p/zeoslib/code-0 ... 01f0f:2504
I assing 'C:\temp' as Dir (in my test) and did copy the hourse.jpg to temp. than i run my tests.. No issues to see.
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/
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/
@EgonHugeist, @mdaems,
Zeos7.1-(beta) branches_ testing_R2508:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):
- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.40),
(For Linux currently I have no way to test)
(Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.29, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17).
Michal
Zeos7.1-(beta) branches_ testing_R2508:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):
- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.40),
(For Linux currently I have no way to test)
(Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.29, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17).
Michal
@EgonHugeist
Zeos7.1-(beta) branches_ testing_R2517:
Delphi2006:
ZDbcDbLibUtils.pas:line390:
Result := {$IFDEF WITH_UNITANSISTRINGS}AnsiStrings.{$ENDIF}AnsiQuotedStr(PlainDriver.ZPlainString(SoftVarManager.GetAsString(Value), ConSettings, zCP_UTF8), '''')
[Pascal Error] ZDbcDbLibUtils.pas(390): E2034 Too many actual parameters
Michal
Zeos7.1-(beta) branches_ testing_R2517:
Delphi2006:
ZDbcDbLibUtils.pas:line390:
Result := {$IFDEF WITH_UNITANSISTRINGS}AnsiStrings.{$ENDIF}AnsiQuotedStr(PlainDriver.ZPlainString(SoftVarManager.GetAsString(Value), ConSettings, zCP_UTF8), '''')
[Pascal Error] ZDbcDbLibUtils.pas(390): E2034 Too many actual parameters
Michal
@EgonHugeist, @mdaems,
Zeos7.1-(beta) branches_ testing_R2518:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):
- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.40),
(For Linux currently I have no way to test)
(Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.29, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17).
Michal
Zeos7.1-(beta) branches_ testing_R2518:
http://svn.code.sf.net/p/zeoslib/code-0 ... sting-7.1/
compiles and runs on (I have tested):
- D2006,
- D2007 -> C++,
- DXE2 32/64 -> C++(32),
- Lazarus Windows7-64 1.1.0/fpc 2.7.1 32/64 (CodeTyphon ver 4.40),
(For Linux currently I have no way to test)
(Firebird 2.5.3, MySQL 5.5.18, MariaDB 5.5.29, PostgreSQL 9.2.2, MSSQL 2008 R2 Express(mssql, FreeTDS, ado-sqlncli), *.mdb-ado-Jet.OLEDB.4.0, Oracle Database Express Edition 11g Release 2, SQLite 3.7.17).
Michal
- EgonHugeist
- Zeos Project Manager
- Posts: 1936
- Joined: 31.03.2011, 22:38
miab3,
have no Access, Michal. But AFAIK is there no real support for binary Data with Access, Michal. Use Base64 or BinToHex falues instead. And convert them back on accessing the Fields.
Am i wrong?
have no Access, Michal. But AFAIK is there no real support for binary Data with Access, Michal. Use Base64 or BinToHex falues instead. And convert them back on accessing the Fields.
Am i wrong?
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/
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/