Problem since installing 5.00.20
-
- Posts: 14
- Joined: Thu 07 Aug 2008 09:42
Problem since installing 5.00.20
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.
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.
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.
-
- Posts: 14
- Joined: Thu 07 Aug 2008 09:42
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.
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.
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.
-
- Posts: 14
- Joined: Thu 07 Aug 2008 09:42
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..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 have this problem too
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 have this problem too. You can try overtake (until new version) the problem by "unicode=true" clause in connection string.
Kind regards, PaRi
-
- Posts: 14
- Joined: Thu 07 Aug 2008 09:42