Devart Forums

akiraiu

MaximG wrote: ↑Mon 09 May 2022 19:33 1. We are not aware of any issues with the Direct mode in ODAC 11.1.2
2. We haven't yet tested ODAC for compatibility with Oracle TDE tablespace encryption

You mean all version ODAC still not test for the compatibility with oracle TDE tablespace encryption with direct mode?

I tested with the ODAC 10.3.9 connect to oracle 19c with TDE tablespace encryption, it seem no problem.
but I worry about there are some unknown problem with the above combination.

Thanks.

akiraiu

I am using ODAC 10.3.9(Delphi 7) Direct Mode connect to Oracle 12c Database and work fine.

Now, Plan to upgrade the oracle db to 19c with TDE on tablespace.
I tested the ODAC 10.3.9 that can connect to oracle 19c successfully and seem no any problem.

My Questions:
1. I checked the release notes of ODAC 11.1.2 that supported the oracle 19c, if I don't upgrade the newest version of ODAC for connecting 19c db. Any unexpected problem???

2. Because the new 19c db configure the TDE tablespace encryption, the ODAC 10.3.9 or the newest version is supported to using Direct Mode the TDE tablespace encryption?

Thanks.

akiraiu

I also got the Invalid Login/password problem, can not connect to oracle 12c with direct mode.
I am using:
Delphi 7 profression
ODAC 10.3.8

sqlnet.ora flie:

SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

But the ODAC 10.3.7 is work fine.

Thanks.

akiraiu

as topic~~

akiraiu

OK. For Above example, I want to Insert the unicode for the column a and c:

Code: Select all

var OraSQL : TOraSQL; 
......... 
OraSQL.SQL.Add ('insert into test (a, b, c) values (:a, :b, :c)'); 
OraSQL.ParamByName ('a').AsWideString := '111'; 
OraSQL.ParamByName ('b').AsInteger := 222; 
OraSQL.ParamByName ('c').AsWideString := '333'; 
OraSQL.Execute;

then ODAC create the parameters type is ftString or ftWideString?

akiraiu

Here part of Code:

Code: Select all

var OraSQL : TOraSQL;
.........
OraSQL.SQL.Add ('insert into test (a, b, c) values (:a, :b, :c)');
OraSQL.ParamByName ('a').AsString := '111';
OraSQL.ParamByName ('b').AsInteger := 222;
OraSQL.ParamByName ('c').AsString := '333';
OraSQL.Execute;
.......

Here I have test table:

Code: Select all

create table test (
  a Varchar2 (10),
  b Number (10),
  c Varchar2 (10)
);

ODAC TOraSQL will help me to create the parameters??

akiraiu

OK. If I want to display some unicode word (portuguese) to calsfields, but I can not use TWideStringField to store it, Then how to display the unicode word?
If I use TStringField to store, I will lose the some unicode word (portuguese).

akiraiu

Then how about the CalsField store the widestring value?
Is it the same problem??

akiraiu

By the way, the above also appear in displaying widestring lookup field in table.

akiraiu

Settings are following:
ODAC 5.55.0.21
Delphi 7.1
OraSession Options (Net = False, UseUnicode = True)
TntUnicodeControls for display Unicode (download from http://www.tntware.com/delphicontrols/u ... nloads.htm)

I created the CalcFields in Design-Time with calsFieldTest : TWideStringField.
The OraTable1 contains "wStr" WideString Field, "calsFieldTest" is CalcFields.

procedure TForm1.OraTable1CalcFields(DataSet: TDataSet);
begin
DataSet.FieldByName ('calsFieldTest').Value := DataSet.FieldByName ('wStr').Value;
end;

The Result fail to display wStr Value in the calsFieldTest CalsField.

akiraiu

Thanks, wait for next build.

akiraiu

I already used "Tnt Delphi UNICODE Controls", but also have this result when I changed the Regional Options ["Chinese (Taiwan)" or "English (United States)"].

akiraiu

Settings are following:
ODAC 5.55.0.21
Delphi 7.1
Oracle 9i 9.2.0.5.0 with (charset = AL32UTF8 & NLS_LENGTH_SEMANTICS=CHAR)
OraSession Options (Net = True, UseUnicode = True)
TntUnicodeControls (download from http://www.tntware.com/delphicontrols/u ... nloads.htm)
(chinese or english) Windows XP Professional SP1 (Control Panel->Regional and Language Options->Regional Options->Chinese (Taiwan))

I already have some data that contains portuguese and chinese in Unicode DB table.
when I set the Regional Options to "Chinese (Taiwan)",
the chinese display fine, but some portuguese can not display.

when I set the Regional Options to "English (United States)",
the portuguese display fine, but the chinese can not display.

how can I display the Portuguese and Chinese successful with Net=True and Regional Options->Chinese (Taiwan))?

Akira

akiraiu

Paul wrote:We cannot reproduce your problem with VARCHAR fields in
ODAC5.50.0.18, Oracle 9i 9.2.0.5 (charset is AL32UTF8, NLS_LENGTH_SEMANTICS=CHAR)
What results do you have with net=false? What type of field do you try to view? What characters do you try to insert?
Please check the result of expression TWideStringField(OraQuery1.FieldByName('FIELD')).Value; when net=false and net=true

hi,
I got the problem with net = true. When net = false without this problem.
The Field in Oracle is VARCHAR2.
And I have tried TWideStringField(OraQuery1.FieldByName('FIELD')).Value with net = true (not problem with net = false).
It is also cannot display some port. char.
And I tried the following port. char. (not just the following char.): çûîâ

Thanks.

akiraiu

hi,
My Test Environment:
ODAC5.50.0.18
Oracle 9i 9.2.0.5 (charset is AL32UTF8, NLS_LENGTH_SEMANTICS=CHAR)
Delphi 7.1
OraSession options : net := true, useunicode := true, charlength := 1
TntUnicodeControls
(unicode supported VCL, download here: http://www.tntware.com/delphicontrols/unicode/)

My problem is that, use tnt unicode controls with net options to connect to oracle and save Portuguese char, after save some portuguese can not display, but it can success to save the all portuguese (why I know it can success to save because I use JSP to test retrieve the data that can success to display in utf-8 web page)

On the other hand, when I no use net option to connect to oracle with tnt unicode controls display data, both save and display is success.

why use net options have that display problem?

thx
Akira

Devart Forums

Search found 22 matches

Re: ODAC Direct Mode Connect to Oracle with TDE

ODAC Direct Mode Connect to Oracle with TDE

Re: 10.3.8 and Direct connection fails

OraDeveloper Studio Support Unicode display?

ODAC will automatically create the Params for TOraSQL?

Problem to Display WideString in WideString's CalcFields

Problem to display Portuguese and Chinese with Net=True in Unicode DB.

Can not Display some portuguese char in Net?