On a specific machine TOracleSession.LogOn fails. No EOracleError is fired but Sysutils.Exception. The Exception.Message is '.' Same Logon with a program that is not a Service succeeds. (Same OS user, db user, etc.) My problem is the stupid error message (.) I am not able to locate the error...
No the demo works neither. But I have downloaded the current DOA release. Here all works fine.
So I will have to persuade my boss to buy the new release.
Here is a little example, unfortunately only in C++:
void __fastcall TForm1::Button1Click(TObject *Sender)
{
OS->LogOn();
if(OS->Connected)
{
TOracleObject* OraObj = new TOracleObject(OS, "TDemoPerson", "");
ShowMessage(OraObj->Name);
delete OraObj;
}
OS->LogOff();
}
On creating a TOracleObject with a TOracleSession that is connected to an Oracle 10g database always occurs an exception . My DOA-Version is 3.4.6.1. Does this problem also exist in the current release?
No, this error occurs if your database has not bben set up with an unicode character set.
But the problem with DOA is, in my opinion, that all string properties are String and not WideString.
All my trails to get an unicode string via TOracleQuery.FieldAsString have failed. For example I tried 'StringToWideChar'. But the result is always a string like '