Devart Forums

Hi

I'm trying to connect to an Oracle Cloud using TOraSession.

I have set it up the classic way:
FConnection := TOraSession.Create(nil);
FTransaction := TOraTransaction.Create(FConnection);
FTransaction.DefaultSession := FConnection;
FConnection.LoginPrompt := False;
FConnection.ConnectString := GetConnectString;
FConnection.AutoCommit := true;

Im sure, I use the correct ConnectionString, since I've tested it in an UDL file.
But when connection I get an Error message: Invalid Oracle Home: <nothing>. I doesn't write <nothing>. but just an empty string.

In the enviroment settings I have setup ORACLE_HOME and I've added %ORACLE_HOME%\bin to the path.

What am I doing wrong?

Please make sure that the bitness of your application and a remote Oracle client match in your environment