Devart Forums

Ever since we started using 5.00.20, we've been having a weird problem with the data retrived. When trying to fetch the VARCHAR2(50) field, "value" from our configuration table, we get "LastUse" instead of the actual value "LastUsedProject". Similarly, "LocationAndSize" becomes "Locatio".

Has anyone experienced anything similar? We haven't changed any code in places that would cause this behaviour, and the offending line is as close to the provider as possible:

string name = r["Name"].ToString();

where r is a DbDataReader.

We cannot reproduce this issue.
Please make sure that the problem persists with VARCHAR2, not NVARCHAR2 (there were some modifications with NVARCHAR2 in the last build). Please specify your connection string, the version of the Oracle server, your current charset at your database.

Could you please send me (alexsh*devart*com) a small test project that reproduces the problem? Please include definitions of database objects and avoid using third-party components.

I just discovered something new:

This connection string works fine:
- User ID=XXXXX; Password=XXXXX; Data Source=MARSNET; Direct=False;

This one doesn't:
User ID=XXXXX; Password=XXXXX; Data Source=AppServer; SID=orcl; Direct=true; Port=1522;

Do you have any ideas as to what the problem is using direct?

The problem is not new to 5.0.20.0, it is also there in 5.0.12.0. It might not be a bug in the provider at all, but any ideas as to where this problem lies are greatly appreciated.

We cannot reproduce the problem.
Please give us the following information.
1. Version of your Oracle server, its charset.
2. What regional settings are set on your computer (Control Panel --> Regional and Language Options, the Regional options tab (Standards and formats, Location) and the Advanced tab (Language for non-Unicode programs))?
3. Could you please send me (alexsh*devart*com) a small test project that reproduces the problem? Please include definitions of database objects and avoid using third-party components.

Shalex wrote:We cannot reproduce the problem.
Please give us the following information.
1. Version of your Oracle server, its charset.
2. What regional settings are set on your computer (Control Panel --> Regional and Language Options, the Regional options tab (Standards and formats, Location) and the Advanced tab (Language for non-Unicode programs))?
3. Could you please send me (alexsh*devart*com) a small test project that reproduces the problem? Please include definitions of database objects and avoid using third-party components.

We're moving it from a virtual machine to hardware, I'll let you know if this solves it, otherwise I'll post the information you requested..

Hi,
we have this problem too. You can try overtake (until new version) the problem by "unicode=true" clause in connection string.

Kind regards, PaRi

We were moving to a new server anyway (old was 10.2.0.3.0, new is 10.2.0.4.0), and that seems to have done the trick.

I honestly don't know what caused this, but for us, it is resolved. I'm partial to blame the Virtual PC setup. I'll try the unicode on the old server tag just out of curiosity.

We have reproduced the problem with the NVARCHAR2 column in the Direct mode when the Unicode property is set to false. We will post here when the problem is resolved.

We have fixed the problem with the NVARCHAR2 column in the Direct mode when the Unicode property is set to false.
Look forward to the next build of dotConnect for Oracle.